On Oracle
Saturday, July 28, 2018
row cache mutex in Oracle 12.2.0.1.0
›
In Oracle 12.2.0.1.0 (12cR2), "row cache mutex" replaced 12.1.0.2.0 (12cR1) "latch: row cache objects", similar to ...
plshprof command-line utility in Oracle 12.2.0.1.0
›
The plshprof command-line utility generates HTML reports from raw profiler output files. In Oracle 12.2.0.1.0 (12cR2), plshprof is changed...
Tuesday, July 3, 2018
12c Online Statistics Gathering for Direct Path Insert and 3 Side Effects
›
Oracle 12c introduced Online Statistics Gathering for direct path Bulk Loads (CTAS and IAS), documented in: Online Statistics Gatherin...
Monday, April 9, 2018
TM lock and No Transaction Commit, TX & TM Locks and No Transaction Visible
›
Oracle Document wrote: TRANSACTION groups SQL statements so that they are either all committed, which means they are applied to the da...
Tuesday, March 6, 2018
'enq: RO - fast object reuse' and 'enq: KO - fast object checkpoint' Final Blocker
›
In Wait Event: 'enq: RO - fast object reuse' and 'enq: KO - fast object checkpoint', CKPT is shown as final_blocking_sessio...
Oracle 12.1 Wait Event: 'log file sync: SCN ordering' Demo
›
Oracle MOS Document: What is the Difference Between 'log File Sync: SCN Ordering' and 'log File Sync' (Doc ID 236...
‹
›
Home
View web version