Oracle Cloud Trial:
Up to 3,500 Free Hours
Back to Oracle Blogs
Follow Roger Macnicol
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...
Wednesday, August 2, 2017
The beginners guide to Oracle Table Scans
I was asked a question yesterday that reminded me there are always people completely new to the topic who need an introduction - somewhere to start before the...
Integrated Cloud Applications & Platform Services
Oracle Content Marketing Login