Find current shared pool usage of my programhttp://www.orafaq.com/forum/./mv/msg/185537/573633/#msg_573633
I have a package when it runs, it terminates with

"unable to allocate 4120 bytes of shared memory"

error at a particular INSERT statement. So everytime we had this error, we had to flush the shared pool area, after which it would run without issues(for 3-4 weeks).

It had a dynamic subpartition clause framed, which made it to repharse the query every time.
So to reduce this, we removed the subpartition clause(made it to static query), which did benefit of not getting shared pool error.

I would like to find the current shared pool memory usage of my program.
Is there a way I could find the live consumption of shared pool area of my program(pkg).

Regards
Srivaths]]>srivaths2013-01-01T14:09:41-00:00Re: Find current shared pool usage of my programhttp://www.orafaq.com/forum/./mv/msg/185537/573634/#msg_573634
no, but in some sense does not really matter.
The SHARED GLOBAL AREA is appropriately named.
The SQL within the SGA is literally "shared" & not owned by any single schema.

>we had to flush the shared pool area,
BAD approach to eliminate the symptom.]]>BlackSwan2013-01-01T14:53:47-00:00Re: Find current shared pool usage of my programhttp://www.orafaq.com/forum/./mv/msg/185537/573636/#msg_573636
srivaths2013-01-01T15:20:21-00:00Re: Find current shared pool usage of my programhttp://www.orafaq.com/forum/./mv/msg/185537/573638/#msg_573638
Hiding information does not help to help you.