Oracle Cloud Platform Trial:
Up to 3,500 Free Hours
Back to Oracle Blogs
Follow Roger Macnicol
Recent Posts by Roger Macnicol
Thursday, August 16, 2018
First if you want don't know what an Exadata Quarantine is read
. Someone asked whether you can create your own Exadata Cell quarantine and, if you can, why...
Thursday, March 29, 2018
New in 18c: Introduction to In-Memory External Tables in 18c
On June 10th 2014, Larry Ellison officially launched the new Oracle Database In-Memory option which introduced revolutionary dual-format storage to access the...
Friday, March 23, 2018
Introduction to In-Memory External Tables (IMXT )
This article has been moved to the
Oracle Database In-Memory
Friday, March 9, 2018
Create External Table as Select
I was looking through a test script and saw something I didn't know you could do in Oracle. I mentioned it to an Oracle ACE and he didn't know it either. I then...
Thursday, March 8, 2018
Understanding External Table URowids
I finally found time to get back to External Tables and have a list of blog posts I need to write on this topic. Here's a brief one. DBMS_ROWID will nicely break...
Tuesday, January 23, 2018
How to tell if the Exadata column cache is fully loaded
When a background activity is happening on the cell you typically can't use RDBMS v$ views to monitor it in the same way. One such question is how to tell if a...
Wednesday, November 15, 2017
Revisiting buffer cache Very Large Object Threshold (VLOT)
If you turn on NSMTIO tracing you will see references to VLOT: qertbFetch:[MTT < OBJECT_SIZE < VLOT]: Checking cost to read from caches (local/remote) and...
Thursday, November 9, 2017
Random thoughts on block sizes
I heard "Oracle only tests on 8k and doesn't really test 16k" I heard someone assert that one reason you should only use 8k block sizes is that, and I quote,...
Wednesday, October 25, 2017
External Tables Part 1: Project Columns All vs Referenced
I normally blog about table scans on Oracle native data but Oracle also supports a wide variety of features for scanning external tables and I need to cover...
Integrated Cloud Applications & Platform Services
Oracle Content Marketing Login