Archive for August, 2009
Exciting seminars in Dallas arena
If you live in Dallas area, there are two very important seminars coming up: Tanel Poder is presenting his Advanced Oracle troubleshooting seminar on September 9-11, 2009. . Jonathan Lewis presenting two day seminar cost based optimization and writing efficient SQL on Oct 28 and Oct 29 2009. These two gentlemen needs no introduction. ...
Shared pool freelists (and durations)
My earlier blog about shared pool duration got an offline response from one of my reader: " So, you say that durations aka mini-heaps have been introduced from 10g onwards. I have been using Steve Adams' script shared_pool_free_lists.sql. Is that not accurate anymore?" </p Shared pool free lists I have a great respect for Steve Adams . In many ways, he has been a great virtual mentor and his insights are so remarkable. Coming ...
ORA-4031 and Shared Pool Duration
After reading my earlier post on shared pool A stroll through shared pool heap , one of my client contacted me with an interesting ORA-4031 issue. Client was getting ORA-4031 errors and shared pool size was over 4GB ( in a RAC environment). Client DBA queried v$sgastat to show that there is plenty of free memory in the shared pool. We researched the issue and it is worth blogging. Client DBA was confused ...
