Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> shared pool content

shared pool content

From: <pat.crain_at_gmail.com>
Date: 22 Mar 2005 13:58:53 -0800
Message-ID: <1111528733.953729.28800@o13g2000cwo.googlegroups.com>


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


Received on Tue Mar 22 2005 - 15:58:53 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US