If you are visually impaired or blind, you can visit the PDF version by Pressing CONTROL + ALT + 4
<br /> #PTK<br /> PASS<br /> ORACLE<br /> TABLE<br /> SCANS<br /> How to<br /> improve<br /> performance<br /> and release<br /> space<br /> THE KNOWLEDGE<br /> WWW.UKOUG.ORG<br /> AUTUMN 2019 / ISSUE 71<br /> F O R M E R LY O R A C L E S C E N E<br /> AN INDEPENDENT<br /> PUBLICATION NOT<br /> AFFILIATED WITH<br /> THE ORACLE<br /> CORPORATION<br /> TECH<br /> EDITION<br /> TURN OVER FOR<br /> BUSINESS<br /> APPS<br /> OCI +<br /> AZURE<br /> = ???<br /> What could the<br /> Oracle/Microsoft<br /> cloud partnership<br /> mean for you?<br /> The compute cloud performance<br /> SHOWDOWN<br /> ORACLE v AWS v IBM v GOOGLE v MICROSOFT – WHO’LL COME OUT ON TOP IN THE IAAS STAKES?<br /> 1 - 4 D E C E M B E R 2 0 1 9 // T H E G R A N D B R I G H T O <a title="#PTK Issue 71 Tech page 1" href="http://viewer.zmags.com/publication/d169f1f9?page=1"> #PTK PASS ORACLE TABLE SCANS How to im</a> <a title="#PTK Issue 71 Tech page 2" href="http://viewer.zmags.com/publication/d169f1f9?page=2"> 1 - 4 D E C E M B E R 2 0 1 9 // T H E G R A N D </a> <a title="#PTK Issue 71 Tech page 3" href="http://viewer.zmags.com/publication/d169f1f9?page=3"> #PTK Tech | Autumn 2019 IN THIS ISSUE 09 The </a> <a title="#PTK Issue 71 Tech page 4" href="http://viewer.zmags.com/publication/d169f1f9?page=4"> Welcome to the new issue of #PTK Pass The Knowle</a> <a title="#PTK Issue 71 Tech page 5" href="http://viewer.zmags.com/publication/d169f1f9?page=5"> TECH | VOLUNTEERING T A S R ME &the UKOUG Z</a> <a title="#PTK Issue 71 Tech page 6" href="http://viewer.zmags.com/publication/d169f1f9?page=6"> NEWS ETC... OCI/Azure partnership set to reduce c</a> <a title="#PTK Issue 71 Tech page 7" href="http://viewer.zmags.com/publication/d169f1f9?page=7"> UKOUG EVENTS TECH | EVENTS Sharing knowledg</a> <a title="#PTK Issue 71 Tech page 8" href="http://viewer.zmags.com/publication/d169f1f9?page=8"> The best things about being a UKOUG member </a> <a title="#PTK Issue 71 Tech page 9" href="http://viewer.zmags.com/publication/d169f1f9?page=9"> TECH | OCI/AZURE The technical i</a> <a title="#PTK Issue 71 Tech page 10" href="http://viewer.zmags.com/publication/d169f1f9?page=10"> VPN is nothing more than specifying a few setting</a> <a title="#PTK Issue 71 Tech page 11" href="http://viewer.zmags.com/publication/d169f1f9?page=11"> Oracle Cloud Infrastructure Dynamic Routing Ga</a> <a title="#PTK Issue 71 Tech page 12" href="http://viewer.zmags.com/publication/d169f1f9?page=12"> The compute cloud performance SHOW Put to the tes</a> <a title="#PTK Issue 71 Tech page 13" href="http://viewer.zmags.com/publication/d169f1f9?page=13"> TECH | CLOUDS COMPARED OW 10-SECO Attai</a> <a title="#PTK Issue 71 Tech page 14" href="http://viewer.zmags.com/publication/d169f1f9?page=14"> M ost clou</a> <a title="#PTK Issue 71 Tech page 15" href="http://viewer.zmags.com/publication/d169f1f9?page=15"> Figure 1 Compute cloud cost per month comparison </a> <a title="#PTK Issue 71 Tech page 16" href="http://viewer.zmags.com/publication/d169f1f9?page=16"> host load testing. This is a simple workload gene</a> <a title="#PTK Issue 71 Tech page 17" href="http://viewer.zmags.com/publication/d169f1f9?page=17"> Figure 8 Average response time (ms) Thro</a> <a title="#PTK Issue 71 Tech page 18" href="http://viewer.zmags.com/publication/d169f1f9?page=18"> Exadata Cloud at Customer: Real-life experiences</a> <a title="#PTK Issue 71 Tech page 19" href="http://viewer.zmags.com/publication/d169f1f9?page=19"> T he Ora</a> <a title="#PTK Issue 71 Tech page 20" href="http://viewer.zmags.com/publication/d169f1f9?page=20"> 2 Database storage – the ratio between DATA and </a> <a title="#PTK Issue 71 Tech page 21" href="http://viewer.zmags.com/publication/d169f1f9?page=21"> SUPPORTED GRID INFRASTRUCTURE A N D D ATA B A S E</a> <a title="#PTK Issue 71 Tech page 22" href="http://viewer.zmags.com/publication/d169f1f9?page=22"> Table access full, part II Performance: chained r</a> <a title="#PTK Issue 71 Tech page 23" href="http://viewer.zmags.com/publication/d169f1f9?page=23"> TECH | TABLE SCANS 10-SECOND SUMMARY This a</a> <a title="#PTK Issue 71 Tech page 24" href="http://viewer.zmags.com/publication/d169f1f9?page=24"> together is known as a ‘next rowid’, which is abb</a> <a title="#PTK Issue 71 Tech page 25" href="http://viewer.zmags.com/publication/d169f1f9?page=25"> PERFORMANCE TIP Using Direct Path loads can lead</a> <a title="#PTK Issue 71 Tech page 26" href="http://viewer.zmags.com/publication/d169f1f9?page=26"> If you realise you should have created a tab</a> <a title="#PTK Issue 71 Tech page 27" href="http://viewer.zmags.com/publication/d169f1f9?page=27"> TECH | TABLE SCANS PERFORMANCE CHANGES IN 19C </a> <a title="#PTK Issue 71 Tech page 28" href="http://viewer.zmags.com/publication/d169f1f9?page=28"> Designing an asynchronous application inter</a> <a title="#PTK Issue 71 Tech page 29" href="http://viewer.zmags.com/publication/d169f1f9?page=29"> TECH | ASYNCHRONOUS APPLICATION INTERFACES </a> <a title="#PTK Issue 71 Tech page 30" href="http://viewer.zmags.com/publication/d169f1f9?page=30"> data files could be loaded into the staging table</a> <a title="#PTK Issue 71 Tech page 31" href="http://viewer.zmags.com/publication/d169f1f9?page=31"> TECH | ASYNCHRONOUS APPLICATION INTERFACES Loo</a> <a title="#PTK Issue 71 Tech page 32" href="http://viewer.zmags.com/publication/d169f1f9?page=32"> TECH | TURN OVER FOR BUSINESS APPS Turn over now!</a>