If you are visually impaired or blind, you can visit the PDF version by Pressing CONTROL + ALT + 4
<br /> Spring 15 Issue 56<br /> Optimising a Distributed Query<br /> A strategy and hint from subject<br /> matter expert Jonathan Lewis<br /> Introduction to Oracle<br /> Martin Widlake provides an overview<br /> of the Oracle RDBMS architecture<br /> Getting it Right First Time<br /> Pythian's Michael Abbey highlights<br /> the importance of planning<br /> OracleScene<br /> Serving the Oracle Community<br /> A User Interface<br /> Philosophy<br /> Oracle Alta UI<br /> www.ukoug.org<br /> An independent publication not affiliated with<br /> Oracle Corporation<br /> This edition's<br /> sponsor:<br /> OracleScene<br /> DIGITAL<br /> SPRING 15<br /> Welcome to Oracle Scene<br /> Oracle Scene Editorial Team<br /> Editor: Brendan Tierney<br /> Email: editor@ukoug.org.uk<br /> UKOUG Contact: Brigit Wells<br /> Email: brigit@ukoug.org<br /> Sales: Kerry Stuart<br /> Email: kerry@ukoug.org<br /> UKOUG Governance<br /> A full listing of Board members, along<a title="Oracle Scene Issue 56 page 1" href="http://viewer.zmags.com/publication/cdb0833d?page=1"> Spring 15 Issue 56 Optimising a Distributed Q</a> <a title="Oracle Scene Issue 56 page 2" href="http://viewer.zmags.com/publication/cdb0833d?page=2"> OracleScene DIGITAL SPRING 15 Welcome to Oracle </a> <a title="Oracle Scene Issue 56 page 3" href="http://viewer.zmags.com/publication/cdb0833d?page=3"> First Word First word Spring is all about freshn</a> <a title="Oracle Scene Issue 56 page 4" href="http://viewer.zmags.com/publication/cdb0833d?page=4"> OracleScene DIGITAL SPRING 15 News and Reviews 2</a> <a title="Oracle Scene Issue 56 page 5" href="http://viewer.zmags.com/publication/cdb0833d?page=5"> News and Reviews UKOUG Partner of the Year Award</a> <a title="Oracle Scene Issue 56 page 6" href="http://viewer.zmags.com/publication/cdb0833d?page=6"> SPRING 15 We're so much more than a Solaris </a> <a title="Oracle Scene Issue 56 page 7" href="http://viewer.zmags.com/publication/cdb0833d?page=7"> Focus on: Next Gen Next Gen UK</a> <a title="Oracle Scene Issue 56 page 8" href="http://viewer.zmags.com/publication/cdb0833d?page=8"> OracleScene DIGITAL SPRING 15 Development </a> <a title="Oracle Scene Issue 56 page 9" href="http://viewer.zmags.com/publication/cdb0833d?page=9"> FIGURE 1 everyday lives away from IT, such as o</a> <a title="Oracle Scene Issue 56 page 10" href="http://viewer.zmags.com/publication/cdb0833d?page=10"> SPRING 15 Development: Grant Ronald </a> <a title="Oracle Scene Issue 56 page 11" href="http://viewer.zmags.com/publication/cdb0833d?page=11"> FIGURE 4 part of our lives developin</a> <a title="Oracle Scene Issue 56 page 12" href="http://viewer.zmags.com/publication/cdb0833d?page=12"> SPRING 15 Development: Grant Ronald whether ro</a> <a title="Oracle Scene Issue 56 page 13" href="http://viewer.zmags.com/publication/cdb0833d?page=13"> Technology Demystifying WORKLOAD Sy</a> <a title="Oracle Scene Issue 56 page 14" href="http://viewer.zmags.com/publication/cdb0833d?page=14"> SPRING 15 Technology: Franck Pachot I stop my </a> <a title="Oracle Scene Issue 56 page 15" href="http://viewer.zmags.com/publication/cdb0833d?page=15"> mblkrds: 2053-2030=23 this matches the ‘physical </a> <a title="Oracle Scene Issue 56 page 16" href="http://viewer.zmags.com/publication/cdb0833d?page=16"> SPRING 15 Technology: Franck Pachot The Formul</a> <a title="Oracle Scene Issue 56 page 17" href="http://viewer.zmags.com/publication/cdb0833d?page=17"> Do you wonder why I’ve only 14 multiblock request</a> <a title="Oracle Scene Issue 56 page 18" href="http://viewer.zmags.com/publication/cdb0833d?page=18"> OracleScene SPRING 15 7-9 DECEMBER 2015 </a> <a title="Oracle Scene Issue 56 page 19" href="http://viewer.zmags.com/publication/cdb0833d?page=19"> 8-9 DECEMBER 2015 What happen</a> <a title="Oracle Scene Issue 56 page 20" href="http://viewer.zmags.com/publication/cdb0833d?page=20"> OracleScene DIGITAL SPRING 15 Licensing </a> <a title="Oracle Scene Issue 56 page 21" href="http://viewer.zmags.com/publication/cdb0833d?page=21"> Licensing: Grégory Steulet Oracle Support will </a> <a title="Oracle Scene Issue 56 page 22" href="http://viewer.zmags.com/publication/cdb0833d?page=22"> OracleScene DIGITAL SPRING 15 Licensing: Grégory</a> <a title="Oracle Scene Issue 56 page 23" href="http://viewer.zmags.com/publication/cdb0833d?page=23"> • Oracle Database Standard Edition One may only b</a> <a title="Oracle Scene Issue 56 page 24" href="http://viewer.zmags.com/publication/cdb0833d?page=24"> SPRING 15 Licensing: Grégory Steulet Vcenter S</a> <a title="Oracle Scene Issue 56 page 25" href="http://viewer.zmags.com/publication/cdb0833d?page=25"> Licensing: Grégory Steulet - On an OVCA, you c</a> <a title="Oracle Scene Issue 56 page 26" href="http://viewer.zmags.com/publication/cdb0833d?page=26"> OracleScene DIGITAL SPRING 15 Oracle </a> <a title="Oracle Scene Issue 56 page 27" href="http://viewer.zmags.com/publication/cdb0833d?page=27"> Oracle: Dermot O'Kelly to connect these diff</a> <a title="Oracle Scene Issue 56 page 28" href="http://viewer.zmags.com/publication/cdb0833d?page=28"> OracleScene DIGITAL SPRING 15 Technology Distr</a> <a title="Oracle Scene Issue 56 page 29" href="http://viewer.zmags.com/publication/cdb0833d?page=29"> -------------------------------------------------</a> <a title="Oracle Scene Issue 56 page 30" href="http://viewer.zmags.com/publication/cdb0833d?page=30"> OracleScene DIGITAL SPRING 15 Technology: Jonath</a> <a title="Oracle Scene Issue 56 page 31" href="http://viewer.zmags.com/publication/cdb0833d?page=31"> Rows (1st) Rows (avg) Rows (max) Row Source Opera</a> <a title="Oracle Scene Issue 56 page 32" href="http://viewer.zmags.com/publication/cdb0833d?page=32"> OracleScene DIGITAL SPRING 15 Back to Basics Se</a> <a title="Oracle Scene Issue 56 page 33" href="http://viewer.zmags.com/publication/cdb0833d?page=33"> Oracle is your Data Waiter This situation is a li</a> <a title="Oracle Scene Issue 56 page 34" href="http://viewer.zmags.com/publication/cdb0833d?page=34"> SPRING 15 Back to Basics: Martin Widlake s</a> <a title="Oracle Scene Issue 56 page 35" href="http://viewer.zmags.com/publication/cdb0833d?page=35"> are not classed as part of the database, but they</a> <a title="Oracle Scene Issue 56 page 36" href="http://viewer.zmags.com/publication/cdb0833d?page=36"> OracleScene DIGITAL SPRING 15 Oracle ACE Program</a> <a title="Oracle Scene Issue 56 page 37" href="http://viewer.zmags.com/publication/cdb0833d?page=37"> st tion le ers Organic growth from mode beginnin</a> <a title="Oracle Scene Issue 56 page 38" href="http://viewer.zmags.com/publication/cdb0833d?page=38"> OracleScene DIGITAL SPRING 15 Technology Do It</a> <a title="Oracle Scene Issue 56 page 39" href="http://viewer.zmags.com/publication/cdb0833d?page=39"> Version 2 The following plan is the expanded and </a> <a title="Oracle Scene Issue 56 page 40" href="http://viewer.zmags.com/publication/cdb0833d?page=40"> OracleScene DIGITAL SPRING 15 Technology Th</a> <a title="Oracle Scene Issue 56 page 41" href="http://viewer.zmags.com/publication/cdb0833d?page=41"> great deal more to Exadata than networks and serv</a> <a title="Oracle Scene Issue 56 page 42" href="http://viewer.zmags.com/publication/cdb0833d?page=42"> SPRING 15 Technology: Martin Power • A back-to</a> <a title="Oracle Scene Issue 56 page 43" href="http://viewer.zmags.com/publication/cdb0833d?page=43"> kmod-vgc-drivers-<distribution or kernel version></a> <a title="Oracle Scene Issue 56 page 44" href="http://viewer.zmags.com/publication/cdb0833d?page=44"> SPRING 15 Technology: Martin Power 2. Create a</a> <a title="Oracle Scene Issue 56 page 45" href="http://viewer.zmags.com/publication/cdb0833d?page=45"> The vgc-vshare-wait utility has configuration opt</a> <a title="Oracle Scene Issue 56 page 46" href="http://viewer.zmags.com/publication/cdb0833d?page=46"> SPRING 15 Technology: Martin Power Syntax: DBM</a> <a title="Oracle Scene Issue 56 page 47" href="http://viewer.zmags.com/publication/cdb0833d?page=47"> Accelerate Oracle® Databases with Smarter, Faster</a> <a title="Oracle Scene Issue 56 page 48" href="http://viewer.zmags.com/publication/cdb0833d?page=48"> OracleScene DIGITAL SPRING 15 Applications Innov</a> <a title="Oracle Scene Issue 56 page 49" href="http://viewer.zmags.com/publication/cdb0833d?page=49"> Applications Innovation OracleScene additional c</a> <a title="Oracle Scene Issue 56 page 50" href="http://viewer.zmags.com/publication/cdb0833d?page=50"> OracleScene DIGITAL SPRING 15 Applications Innov</a> <a title="Oracle Scene Issue 56 page 51" href="http://viewer.zmags.com/publication/cdb0833d?page=51"> Applications Innovation: Andreas Chatziantoniou &</a> <a title="Oracle Scene Issue 56 page 52" href="http://viewer.zmags.com/publication/cdb0833d?page=52"> OracleScene DIGITAL SPRING 15 Applications Innov</a> <a title="Oracle Scene Issue 56 page 53" href="http://viewer.zmags.com/publication/cdb0833d?page=53"> Technology OracleScene additional content DIGITA</a> <a title="Oracle Scene Issue 56 page 54" href="http://viewer.zmags.com/publication/cdb0833d?page=54"> SPRING 15 Technology: Antonis Antoniou & Ronald v</a> <a title="Oracle Scene Issue 56 page 55" href="http://viewer.zmags.com/publication/cdb0833d?page=55"> Technology: Antonis Antoniou & Ronald van Luttikh</a> <a title="Oracle Scene Issue 56 page 56" href="http://viewer.zmags.com/publication/cdb0833d?page=56"> OracleScene DIGITAL SPRING 15 Technology: Antoni</a> <a title="Oracle Scene Issue 56 page 57" href="http://viewer.zmags.com/publication/cdb0833d?page=57"> Technology: Antonis Antoniou & Ronald van Luttikh</a> <a title="Oracle Scene Issue 56 page 58" href="http://viewer.zmags.com/publication/cdb0833d?page=58"> SPRING 15 Technology: Antonis Antoniou & Ronald v</a> <a title="Oracle Scene Issue 56 page 59" href="http://viewer.zmags.com/publication/cdb0833d?page=59"> Technology: Antonis Antoniou & Ronald van Luttikh</a> <a title="Oracle Scene Issue 56 page 60" href="http://viewer.zmags.com/publication/cdb0833d?page=60"> OracleScene DIGITAL SPRING 15 Technology Orac</a> <a title="Oracle Scene Issue 56 page 61" href="http://viewer.zmags.com/publication/cdb0833d?page=61"> FIGURE 1: DADEDIT. DAD FORM As usual, an increa</a> <a title="Oracle Scene Issue 56 page 62" href="http://viewer.zmags.com/publication/cdb0833d?page=62"> SPRING 15 Technology: Luis Rodríguez Fernández </a> <a title="Oracle Scene Issue 56 page 63" href="http://viewer.zmags.com/publication/cdb0833d?page=63"> Technology OracleScene additional content DIGI</a> <a title="Oracle Scene Issue 56 page 64" href="http://viewer.zmags.com/publication/cdb0833d?page=64"> SPRING 15 Technology: Peter de Vaal & Nicolay Moo</a> <a title="Oracle Scene Issue 56 page 65" href="http://viewer.zmags.com/publication/cdb0833d?page=65"> Select the products to configure: OID and optiona</a> <a title="Oracle Scene Issue 56 page 66" href="http://viewer.zmags.com/publication/cdb0833d?page=66"> SPRING 15 Technology: Peter de Vaal & Nicolay Moo</a> <a title="Oracle Scene Issue 56 page 67" href="http://viewer.zmags.com/publication/cdb0833d?page=67"> Header here OracleScene additional content DIGIT</a> <a title="Oracle Scene Issue 56 page 68" href="http://viewer.zmags.com/publication/cdb0833d?page=68"> SPRING 15 Technology: Jeff Smith with the </a> <a title="Oracle Scene Issue 56 page 69" href="http://viewer.zmags.com/publication/cdb0833d?page=69"> Tasks, drill into findings and view reports • Run</a> <a title="Oracle Scene Issue 56 page 70" href="http://viewer.zmags.com/publication/cdb0833d?page=70"> OracleScene DIGITAL SPRING 15 Technology: Jeff S</a> <a title="Oracle Scene Issue 56 page 71" href="http://viewer.zmags.com/publication/cdb0833d?page=71"> Creating opportunities to connect </a> <a title="Oracle Scene Issue 56 page 72" href="http://viewer.zmags.com/publication/cdb0833d?page=72"> Oracle Cloud Applications HCM Human Capital Rec</a>