<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>