Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> shared pool content
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
![]() |
![]() |