ORA- 4031 – A Case Study

Today I will be taking up one ORA-4031 issue we faced on one of our client database. Please note that SQL statements mentioned below have been changed and does not…

Read Full Recipe
340 views 6:00 pm 0 Comments

Shared Sub Pools

Today I will discuss about Shared pool subpools which have been introduced in release 9iR2 and higher (To be precise > and can be controlled by a hidden parameter "_kghdsidx_count…

Read Full Recipe
545 views 2:01 pm 2 Comments