In the previous blog, I demonstrated creating an empty table with BASIC Compression and then populating it.
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“.
Unlike tracing for particular SQL statements, you can also trace by PID (Oracle PID) or Server Process ID (SPID).
The Linux-powered device is beautiful on its own but with billions of Linux-powered devices out there it is not particularly unique.
My previous blogpost covered using ALTER SYSTEM/SESSION to set tracing for a specific SQL_ID that has been determined in advance.