On Oracle
Saturday, July 22, 2017
nls_database_parameters, dc_props, latch: row cache objects
›
This Blog will demonstrate latch: row cache objects on Dictionary Cache dc_props when querying nls_database_parameters. Note: all tests ar...
v$database select and control file sequential read
›
V$DATABASE is one single row view, displaying information about the database from the control file. Its content is a direct mapping of contr...
Tuesday, July 11, 2017
Getting Oracle Transaction Commit SCN
›
This Blog demonstrates one approach to get exact Commit SCN and compare it with other methods. It has not only (Oracle) academic interest, b...
Thursday, May 25, 2017
JDBC, Oracle object/collection, dbms_pickler, NOPARALLEL sys.type$ query
›
When using the JDBC Thin driver to invoke PL/SQL programs with Oracle objects / collections, we can observe dbms_pickler calls, and two NOP...
‹
›
Home
View web version