Re: shared pool content

On 22 Mar 2005 13:58:53 -0800, pat.crain_at_gmail.com wrote:

>I'm seeing significant pressure in shared pool after partitioning my
>DB. In statspak I can track rapid growth in a pool labled "partitioning
>d". Question... what is this? Is there any document that explains
>details of shared pool structure and contents? I'm interested in
>learning more about specific pool allocations such as "KQR M PO", "ges
>enqueues", etc. Snip from a 150 minute statspak report follow. Note the
>growth in "partitioning d".
>
>SGA breakdown difference for DB: QC39A Instance: QC39A1 Snaps: 139 -197
>
>Pool Name Begin value End value % Diff
>------ ------------------------------ ---------------- ----------------
>-------
>
>shared parameters 7,112 4,696 -33.97
>shared partitioning d 60,544 3,086,776 #######
>shared sessions 3,005,600 3,005,600 0.00
>shared sim memory hea 153,480 153,480 0.00
>shared sql area 106,691,216 2,972,856 -97.21
>shared table definiti 3,808 5,808 52.52
>shared trigger inform 600 864 44.00
>buffer_cache 134,217,728 134,217,728 0.00
>fixed_sga 734,616 734,616 0.00
>log_buffer 4,458,496 4,458,496 0.00
>-------------------------------------------------------------

This particular area increased from 60k to 3 M At the other hand the sql area decreased from 106 M to 2M I wouldn't bother about the 'shared partitioning d' which the cached dictionary info on partitions, and I would bother about the sql area decrease.
I would also bother about a log_buffer of 4M.

--
Sybrand Bakker, Senior Oracle DBA