On Oracle
Tuesday, August 2, 2016
ORA-04025 library object lock on AQ queue and SQL cursor
›
AQ dequeue throws: ORA-04025: maximum allowed library object lock allocated for S.KSUN_QUEUE in an Oracle 12c batch application when ...
Monday, June 13, 2016
SQL Parsing in serializable transaction throws ORA-08177: can't serialize access for this transaction
›
Setting serializable isolation level in Oracle 12c (12.1.0.2.0), SQL Parsing can throw: ORA-08177: can't serialize access for this tr...
Tuesday, May 17, 2016
Oracle Fixed Table Practice
›
Fixed objects x$ tables and their indexes are memory structures storing run-time information. They are open to outside as normal tables beca...
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....
‹
›
Home
View web version