Yesterday, I demonstrated a DataGuard Switchover from a 2node RAC(ASM) database to a SingleInstance(FileSystem) Database.
Most default installation guides for Grid Infrastructure will have you creating a DATA Disk Group during the install.
The DIRECT parameter for SQLLoader Command-Line enables Direct Path Load which uses a Direct Path API instead of a regular INSERT statement to load data into the target table.
After the curious finding in my previous blog post, where a Partition’s HighWaterMark was noticeably higher than that for a non-Partitioned Table but then shrunk on a MOVE operation, retrying the same rows with a different pattern of INSERT statements.
I have upgraded my Oracle Database Certified Professional status from 11g to 12c, having passed the 1Z0-060 Exam last Monday.
Taking the test case from my first Blog Post on compression, is there any way to support OLTP ?As demonstrated in the first Blog Post and here, once the table undergoes DML, its size changes.
To quote the 11.2 documentation, “Although it is referred to as block compression, it might be helpful to think of block compression as block skipping“.