On Oracle
Monday, April 11, 2016
sql_id and idn to shared pool subpool
›
Oracle shared pool is divided into a few of subpools(maximum 7). Each sql_id is mapped to its subpool by hash function: subpool no = mo...
Monday, February 15, 2016
Native Code Files: Ora-7445 [Ioc_pin_shared_executable_object()] Reproducing
›
PL/SQL and JAVA Native Code Files are used in Oracle to boost performance. Blog: Remove Stale Native Code Files on AIX discussed the gene...
Wednesday, January 13, 2016
Performance of Oracle Object Collection Comparisons - Part2
›
In Blog: Blog Performance of Oracle Object Collection Comparisons - Part1 we discussed two functions: SET, Equal and Not Equal Comparisons....
Performance of Oracle Object Collection Comparisons - Part1
›
Oracle object types are user-defined types that make it possible to model real-world entities, similar to the class mechanism in C++ and Jav...
Tuesday, January 12, 2016
Foreign Keys and Library Cache Locks: Analysis
›
Blog: Foreign Keys and Library Cache Locks reveals one case of "Library Cache Locks" and demonstrated the test with a professiona...
‹
›
Home
View web version