If you are visually impaired or blind, you can visit the PDF version by Pressing CONTROL + ALT + 4
<br /> Summer 15 Issue 57<br /> Recovering & Restoring Datafiles<br /> Franck Pachot runs through contexts<br /> in RAC & Multitenant 12c instances<br /> What is XQuery?<br /> Ian Carpenter explains & shows how<br /> to use it from the Oracle Database<br /> Implementation Tactics<br /> Time-saving OEM 12c tips from<br /> Philip Brown<br /> OracleScene<br /> Serving the Oracle Community<br /> <br /> <br /> <br /> M<br /> P<br /> I<br /> &<br /> R<br /> W<br /> O<br /> V<br /> E<br /> E<br /> N<br /> D<br /> Oracle SQL<br /> Developer<br /> Version 4.1<br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br<a title="Oracle Scene Issue 57 page 1" href="http://viewer.zmags.com/publication/dd0ea62e?page=1"> Summer 15 Issue 57 Recovering & Restoring Dat</a> <a title="Oracle Scene Issue 57 page 2" href="http://viewer.zmags.com/publication/dd0ea62e?page=2"> LEVERAGE</a> <a title="Oracle Scene Issue 57 page 3" href="http://viewer.zmags.com/publication/dd0ea62e?page=3"> Welcome to Oracle Scene Inside this issue Oracl</a> <a title="Oracle Scene Issue 57 page 4" href="http://viewer.zmags.com/publication/dd0ea62e?page=4"> OracleScene DIGITAL SUMMER 15 First Word First </a> <a title="Oracle Scene Issue 57 page 5" href="http://viewer.zmags.com/publication/dd0ea62e?page=5"> Applications Innovation </a> <a title="Oracle Scene Issue 57 page 6" href="http://viewer.zmags.com/publication/dd0ea62e?page=6"> SUMMER 15 News & Reviews Advance Your Skills </a> <a title="Oracle Scene Issue 57 page 7" href="http://viewer.zmags.com/publication/dd0ea62e?page=7"> News & Reviews UKOUG Partner of the Year Awards 2</a> <a title="Oracle Scene Issue 57 page 8" href="http://viewer.zmags.com/publication/dd0ea62e?page=8"> Congratulations! You've just been elected the new</a> <a title="Oracle Scene Issue 57 page 9" href="http://viewer.zmags.com/publication/dd0ea62e?page=9"> permitting, I certainly hope I can get there this</a> <a title="Oracle Scene Issue 57 page 10" href="http://viewer.zmags.com/publication/dd0ea62e?page=10"> OracleScene DIGITAL SUMMER 15 Oracle Securing</a> <a title="Oracle Scene Issue 57 page 11" href="http://viewer.zmags.com/publication/dd0ea62e?page=11"> Oracle: Alan Hartwell A recent report found </a> <a title="Oracle Scene Issue 57 page 12" href="http://viewer.zmags.com/publication/dd0ea62e?page=12"> Oracle DIGITAL Oracle SQL D</a> <a title="Oracle Scene Issue 57 page 13" href="http://viewer.zmags.com/publication/dd0ea62e?page=13"> Technology: Jeff Smith FIGURE 2: </a> <a title="Oracle Scene Issue 57 page 14" href="http://viewer.zmags.com/publication/dd0ea62e?page=14"> OracleScene DIGITAL SUMMER 15 Technology: Jeff S</a> <a title="Oracle Scene Issue 57 page 15" href="http://viewer.zmags.com/publication/dd0ea62e?page=15"> Technology: Jeff Smith Statements Log Panel Vi</a> <a title="Oracle Scene Issue 57 page 16" href="http://viewer.zmags.com/publication/dd0ea62e?page=16"> SUMMER 15 Te Jef mith chnology: fS </a> <a title="Oracle Scene Issue 57 page 17" href="http://viewer.zmags.com/publication/dd0ea62e?page=17"> Techn log th o y: Jeff Smi </a> <a title="Oracle Scene Issue 57 page 18" href="http://viewer.zmags.com/publication/dd0ea62e?page=18"> OracleScene DIGITAL SUMMER 15 Technology </a> <a title="Oracle Scene Issue 57 page 19" href="http://viewer.zmags.com/publication/dd0ea62e?page=19"> I’ve run the ‘alter system’ from RMAN because we </a> <a title="Oracle Scene Issue 57 page 20" href="http://viewer.zmags.com/publication/dd0ea62e?page=20"> SUMMER 15 Technology: Franck Pachot database, </a> <a title="Oracle Scene Issue 57 page 21" href="http://viewer.zmags.com/publication/dd0ea62e?page=21"> RMAN> repair failure; Strategy: The repair inclu</a> <a title="Oracle Scene Issue 57 page 22" href="http://viewer.zmags.com/publication/dd0ea62e?page=22"> OracleScene DIGITAL SUMMER 15 Technology: Franck</a> <a title="Oracle Scene Issue 57 page 23" href="http://viewer.zmags.com/publication/dd0ea62e?page=23"> Exclusive offer for readers of OracleScene Scor</a> <a title="Oracle Scene Issue 57 page 24" href="http://viewer.zmags.com/publication/dd0ea62e?page=24"> OracleScene DIGITAL SUMMER 15 Focus on: UKOUG Co</a> <a title="Oracle Scene Issue 57 page 25" href="http://viewer.zmags.com/publication/dd0ea62e?page=25"> Focus on: UKOUG Conferences 2015 7-9 DEC 2015 </a> <a title="Oracle Scene Issue 57 page 26" href="http://viewer.zmags.com/publication/dd0ea62e?page=26"> In 5 years, JT Group's revenue has moved from £90</a> <a title="Oracle Scene Issue 57 page 27" href="http://viewer.zmags.com/publication/dd0ea62e?page=27"> Advertorial: Certus Solutions Our Oracle Taleo </a> <a title="Oracle Scene Issue 57 page 28" href="http://viewer.zmags.com/publication/dd0ea62e?page=28"> OracleScene DIGITAL SUMMER 15 Technology </a> <a title="Oracle Scene Issue 57 page 29" href="http://viewer.zmags.com/publication/dd0ea62e?page=29"> Technology: Philip Brown F</a> <a title="Oracle Scene Issue 57 page 30" href="http://viewer.zmags.com/publication/dd0ea62e?page=30"> SUMMER 15 Technology: Philip Brown Issue 4: (N</a> <a title="Oracle Scene Issue 57 page 31" href="http://viewer.zmags.com/publication/dd0ea62e?page=31"> Issues 6: (Not) Bothering About Target Properties</a> <a title="Oracle Scene Issue 57 page 32" href="http://viewer.zmags.com/publication/dd0ea62e?page=32"> OracleScene DIGITAL SUMMER 15 Technology All Ch</a> <a title="Oracle Scene Issue 57 page 33" href="http://viewer.zmags.com/publication/dd0ea62e?page=33"> Technology: Ian Carpenter SQL/XML functions XQ</a> <a title="Oracle Scene Issue 57 page 34" href="http://viewer.zmags.com/publication/dd0ea62e?page=34"> OracleScene DIGITAL SUMMER 15 Technology: Ian Ca</a> <a title="Oracle Scene Issue 57 page 35" href="http://viewer.zmags.com/publication/dd0ea62e?page=35"> Technology: Ian Carpenter Summary This article </a> <a title="Oracle Scene Issue 57 page 36" href="http://viewer.zmags.com/publication/dd0ea62e?page=36"> OracleScene DIGITAL SUMMER 15 Back to Basics Ser</a> <a title="Oracle Scene Issue 57 page 37" href="http://viewer.zmags.com/publication/dd0ea62e?page=37"> Tables and indexes are stored in tablespaces. Eac</a> <a title="Oracle Scene Issue 57 page 38" href="http://viewer.zmags.com/publication/dd0ea62e?page=38"> SUMMER 15 Back to Basics Series: Martin Widlake </a> <a title="Oracle Scene Issue 57 page 39" href="http://viewer.zmags.com/publication/dd0ea62e?page=39"> Not caching full scans of large tables makes sens</a> <a title="Oracle Scene Issue 57 page 40" href="http://viewer.zmags.com/publication/dd0ea62e?page=40"> SUMMER 15 Back to Basics Series: Martin Widlake </a> <a title="Oracle Scene Issue 57 page 41" href="http://viewer.zmags.com/publication/dd0ea62e?page=41"> UKOUG: Get Certified Get Certified! Take Advantage</a> <a title="Oracle Scene Issue 57 page 42" href="http://viewer.zmags.com/publication/dd0ea62e?page=42"> OracleScene DIGITAL SUMMER 15 Technology Indexi</a> <a title="Oracle Scene Issue 57 page 43" href="http://viewer.zmags.com/publication/dd0ea62e?page=43"> FIGURE 1: ROADWORK DATA window) and want to fin</a> <a title="Oracle Scene Issue 57 page 44" href="http://viewer.zmags.com/publication/dd0ea62e?page=44"> SUMMER 15 Technology: James Checkley </a> <a title="Oracle Scene Issue 57 page 45" href="http://viewer.zmags.com/publication/dd0ea62e?page=45"> --Listing 4: Descend to node pipelined function C</a> <a title="Oracle Scene Issue 57 page 46" href="http://viewer.zmags.com/publication/dd0ea62e?page=46"> OracleScene DIGITAL SUMMER 15 ACE Showcase My Jo</a> <a title="Oracle Scene Issue 57 page 47" href="http://viewer.zmags.com/publication/dd0ea62e?page=47"> ACE Showcase: René Antúnez </a> <a title="Oracle Scene Issue 57 page 48" href="http://viewer.zmags.com/publication/dd0ea62e?page=48"> OracleScene DIGITAL SUMMER 15 Licence Management</a> <a title="Oracle Scene Issue 57 page 49" href="http://viewer.zmags.com/publication/dd0ea62e?page=49"> Licence Management: Sibaji Dey Choudhury </a> <a title="Oracle Scene Issue 57 page 50" href="http://viewer.zmags.com/publication/dd0ea62e?page=50"> SUMMER 15 Licence Management: Sibaji Dey Choudhur</a> <a title="Oracle Scene Issue 57 page 51" href="http://viewer.zmags.com/publication/dd0ea62e?page=51"> As far as server partitioning is concerned, hard </a> <a title="Oracle Scene Issue 57 page 52" href="http://viewer.zmags.com/publication/dd0ea62e?page=52"> OracleScene DIGITAL SUMMER 15 Business Analytics</a> <a title="Oracle Scene Issue 57 page 53" href="http://viewer.zmags.com/publication/dd0ea62e?page=53"> FIGURE 1.1: CURRENT SETUP What we will do is: </a> <a title="Oracle Scene Issue 57 page 54" href="http://viewer.zmags.com/publication/dd0ea62e?page=54"> SUMMER 15 Business Analytics: Kiran Tailor 4) </a> <a title="Oracle Scene Issue 57 page 55" href="http://viewer.zmags.com/publication/dd0ea62e?page=55"> Business Analytics: Kiran Tailor Field Par</a> <a title="Oracle Scene Issue 57 page 56" href="http://viewer.zmags.com/publication/dd0ea62e?page=56"> OracleScene DIGITAL SUMMER 15 Business Analytics</a> <a title="Oracle Scene Issue 57 page 57" href="http://viewer.zmags.com/publication/dd0ea62e?page=57"> HTeacdhenrohloegrey Histograms: Pre-12c & Now H</a> <a title="Oracle Scene Issue 57 page 58" href="http://viewer.zmags.com/publication/dd0ea62e?page=58"> OracleScene DIGITAL SUMMER 15 Technology: Anju G</a> <a title="Oracle Scene Issue 57 page 59" href="http://viewer.zmags.com/publication/dd0ea62e?page=59"> Technology: Anju Garg Thus, prior to 12c, freq</a> <a title="Oracle Scene Issue 57 page 60" href="http://viewer.zmags.com/publication/dd0ea62e?page=60"> OracleScene DIGITAL SUMMER 15 Technology: Anju G</a> <a title="Oracle Scene Issue 57 page 61" href="http://viewer.zmags.com/publication/dd0ea62e?page=61"> Technology: Anju Garg In 12c, frequency histog</a> <a title="Oracle Scene Issue 57 page 62" href="http://viewer.zmags.com/publication/dd0ea62e?page=62"> OracleScene DIGITAL SUMMER 15 Technology: Anju G</a> <a title="Oracle Scene Issue 57 page 63" href="http://viewer.zmags.com/publication/dd0ea62e?page=63"> Technology: Anju Garg Hybrid Histograms A hybr</a> <a title="Oracle Scene Issue 57 page 64" href="http://viewer.zmags.com/publication/dd0ea62e?page=64"> OracleScene DIGITAL SUMMER 15 Technology: Anju G</a> <a title="Oracle Scene Issue 57 page 65" href="http://viewer.zmags.com/publication/dd0ea62e?page=65"> Header here Next Gen Birmingham City University </a> <a title="Oracle Scene Issue 57 page 66" href="http://viewer.zmags.com/publication/dd0ea62e?page=66"> Are you ready to deliver, ready to engage? HCM </a>