Home » RDBMS Server » Performance Tuning » how we can match variable sga using v$sga and v$sgastat views (Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi)
how we can match variable sga using v$sga and v$sgastat views [message #521832] Fri, 02 September 2011 05:29 Go to next message
msol25
Messages: 396
Registered: June 2011
Senior Member
I am querrying v$sga and getting variable size : 211337216 bytes.when querrying
v$sgastat then getting

java Pool : 16777216
Large Pool : 41943040
Shared pool : 398560392

But as per my knowledge following condition should satisfy,but not getting


  Variable sga = java pool + large pool + shared pool

   select   pool,name,sum(bytes)
   from     v$sgastat
   where    pool in ('shared pool','java pool','large pool')
   group by pool,name;

Here variable size using v$sga : 211337216 bytes

and java pool + large pool + shared pool : 211302536 bytes.




but it should match?
Re: how we can match variable sga using v$sga and v$sgastat views [message #521839 is a reply to message #521832] Fri, 02 September 2011 05:57 Go to previous messageGo to next message
msol25
Messages: 396
Registered: June 2011
Senior Member
Please Michel reply my question...I have little bit urgency...
Re: how we can match variable sga using v$sga and v$sgastat views [message #521844 is a reply to message #521839] Fri, 02 September 2011 06:17 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Why is it so urgent?
And why don't you post what we request?

Regards
Michel
Re: how we can match variable sga using v$sga and v$sgastat views [message #521845 is a reply to message #521844] Fri, 02 September 2011 06:30 Go to previous messageGo to next message
msol25
Messages: 396
Registered: June 2011
Senior Member
Michel,

Not getting about your request.Please tell me i'll follow your suggestions..

Where i m wrong..not getting..

Please help me..
Re: how we can match variable sga using v$sga and v$sgastat views [message #521850 is a reply to message #521845] Fri, 02 September 2011 06:55 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Use SQL*Plus and copy and paste your session, the WHOLE session.

Please read OraFAQ Forum Guide

Regards
Michel
Re: how we can match variable sga using v$sga and v$sgastat views [message #521852 is a reply to message #521850] Fri, 02 September 2011 07:08 Go to previous messageGo to next message
msol25
Messages: 396
Registered: June 2011
Senior Member
Hi Michel,

Please find details :


SQL> select * from v$sga;

NAME                      VALUE                                                 
-------------------- ----------                                                 
Fixed Size              2085192                                                 
Variable Size         469765816                                                 
Database Buffers       46137344                                                 
Redo Buffers            6299648                                                 

SQL> select * from v$sgastat;

POOL         NAME                            BYTES                              
------------ -------------------------- ----------                              
             fixed_sga                     2085192                              
             buffer_cache                 46137344                              
             log_buffer                    6299648                              
shared pool  dpslut_kfdsg                      512                              
shared pool  hot latch diagnostics             160                              
shared pool  ENQUEUE STATS                   11928                              
shared pool  transaction                    295328                              
shared pool  KCB buffer wait statistic        3352                              
shared pool  invalid low rba queue            2048                              
shared pool  KQF optimizer stats table        4824                              
shared pool  CCursor                      13614968                              

POOL         NAME                            BYTES                              
------------ -------------------------- ----------                              
shared pool  ksunfy: system-global sta        3240                              
shared pool  Alert log                         520                              
shared pool  DISPATCHERS INFO                  240                              
shared pool  plwpil:wa                        4264                              
shared pool  kzekm heap descriptor             304                              
shared pool  kelt translation table            312                              
shared pool  trace buf hdr xtend             35088                              
shared pool  kglsim recovery area             2904                              
shared pool  procs_kfgbsg                      616                              
shared pool  service names array                56                              
shared pool  qtree_kwqbspse                     40                              

POOL         NAME                            BYTES                              
------------ -------------------------- ----------                              
shared pool  SHARED SERVERS INFO               240                              
shared pool  ASH buffers                  13421776                              
shared pool  sga listelement                  2048                              
shared pool  object queue hash table d       15104                              
shared pool  PX subheap desc                   256                              
shared pool  PX msg pool struct               1088                              
shared pool  Managed Standby Proc Arra       24576                              
shared pool  KQR M SO                      1900392                              
shared pool  KSIR SGA                          128                              
shared pool  BRANCH TABLE SEGMENTED AR      152736                              
shared pool  KGKP sga                           32                              

POOL         NAME                            BYTES                              
------------ -------------------------- ----------                              
shared pool  SGA Obsolete Param Source          16                              
shared pool  osp pool handles                    8                              
shared pool  SGA - SWRF Time Model Bas          64                              
shared pool  KSK SGA                         76592                              
shared pool  sys event stats for Other      199136                              
shared pool  spfile callback table: ks         448                              
shared pool  kcrrny                          33760                              
shared pool  Service-level trace setti         536                              
shared pool  LRMPD SGA Table                167440                              
shared pool  namhsh_kfgsg                      288                              
shared pool  msg Q child latches               896                              

POOL         NAME                            BYTES                              
------------ -------------------------- ----------                              
shared pool  plwda:PLW_STR_NEW_LEN_VEC           8                              
shared pool  Prefetch history buffer a         320                              
shared pool  Prefetch client count per          32                              
shared pool  ptr to sessions under idl          64                              
shared pool  returns from metrics req       763904                              
shared pool  xslongops                        2592                              
shared pool  qm_init_uga_helper: qmkm           16                              
shared pool  qesmmaInitialize: ta_qesm         264                              
shared pool  kglsim pin list arr              1224                              
shared pool  kqlpWrntoStr:string               208                              
shared pool  kebm test replies               28672                              

POOL         NAME                            BYTES                              
------------ -------------------------- ----------                              
shared pool  XDB Schema Cac                7960504                              
shared pool  ges enqueue cur. usage pe           8                              
shared pool  Detached dump directory           520                              
shared pool  kscdnfyinithead                    16                              
shared pool  ges deadlock xid hash tab       17800                              
shared pool  ges recovery domain table         176                              
shared pool  writes stopped lock conte          24                              
shared pool  X$KSVIS table                     128                              
shared pool  KUPP subheap desc                 232                              
shared pool  idtab_kfksg                     45320                              
shared pool  dbwr actual working sets           64                              

POOL         NAME                            BYTES                              
------------ -------------------------- ----------                              
shared pool  dbwriter coalesce struct           48                              
shared pool  trace buffer header array       35088                              
shared pool  KTUR HIST INFO                   4840                              
shared pool  kodosgi kodos                      32                              
shared pool  UNDO INFO SEGMENTED ARRAY       25896                              
shared pool  jsksncb: 9                      28992                              
shared pool  jsksncb: 8                       1024                              
shared pool  ksv work msg                     4464                              
shared pool  ges process hash table          14080                              
shared pool  file # translation table        33656                              
shared pool  kfkid hash                       4104                              

POOL         NAME                            BYTES                              
------------ -------------------------- ----------                              
shared pool  kkj jobq  wor                    4128                              
shared pool  joxlod exec hp                 974496                              
shared pool  kglsim heap                   3273984                              
shared pool  KFG SO child                     5056                              
shared pool  Wait event pointers               336                              
shared pool  KJCTS process batching st          80                              
shared pool  KTCN: Obj Invalidation Se        2336                              
shared pool  threshold ale                   12192                              
shared pool  1:kngisga                       32088                              
shared pool  KEWS statistic metadata         12032                              
shared pool  kgsk subheap descriptor           136                              

POOL         NAME                            BYTES                              
------------ -------------------------- ----------                              
shared pool  pq_krcpx                          960                              
shared pool  kglsim main lru size           151040                              
shared pool  kso req alloc heapds              280                              
shared pool  PQ/ResSched                      1040                              
shared pool  SERVICE NAME ENTRY                168                              
shared pool  sim lru segments                 5120                              
shared pool  PL/SQL MPCODE                 1961000                              
shared pool  object queue hash buckets      525312                              
shared pool  object stat dummy statprv         144                              
shared pool  LGWR-network Server info        27648                              
shared pool  logout storm management           880                              

POOL         NAME                            BYTES                              
------------ -------------------------- ----------                              
shared pool  ASM map operations               3616                              
shared pool  ArchLog Dest Array               7656                              
shared pool  analytic workspace               3616                              
shared pool  sim trace buf                    5144                              
shared pool  qm_init_sga:oidctx                  8                              
shared pool  Sort Segment                    12368                              
shared pool  qm_init_uga:qmsg                20632                              
shared pool  enqueue                        293600                              
shared pool  buffer handles                 154008                              
shared pool  sga node map                       16                              
shared pool  message pool context area       11760                              

POOL         NAME                            BYTES                              
------------ -------------------------- ----------                              
shared pool  cinfo_kfnsg                      4104                              
shared pool  kks stats                          40                              
shared pool  KSFV SGA                          824                              
shared pool  ASM rollback operations          2592                              
shared pool  lckhsr_kffsg                       24                              
shared pool  ASM extent pointer array       191680                              
shared pool  krvxlctx                          248                              
shared pool  parallel_max_servers            12160                              
shared pool  resize request state obje      368000                              
shared pool  rules engine aggregate st        1416                              
shared pool  krvxdka                           592                              

POOL         NAME                            BYTES                              
------------ -------------------------- ----------                              
shared pool  network connections             62880                              
shared pool  SGA - SWRF Metrics ksuTim        1216                              
shared pool  simulator latch/bucket st       11264                              
shared pool  change notification obj m       16416                              
shared pool  MS alert log                    72704                              
shared pool  knlsg                             120                              
shared pool  KGLS SP                          4704                              
shared pool  ksfqpa                          62432                              
shared pool  kfdsga                            128                              
shared pool  kfmdsg                            144                              
shared pool  kffsga                            120                              

POOL         NAME                            BYTES                              
------------ -------------------------- ----------                              
shared pool  buffer_pool_desc_array           3384                              
shared pool  kzulu                             560                              
shared pool  object queue                   459984                              
shared pool  object level                   435120                              
shared pool  sim trace buf context             200                              
shared pool  X$SKGXPIA                        2680                              
shared pool  character set memory           354072                              
shared pool  character set object           243832                              
shared pool  sess Q child latches              896                              
shared pool  X$KSXPIA                         2680                              
shared pool  qesmmaInitialize: oa_qesm         112                              

POOL         NAME                            BYTES                              
------------ -------------------------- ----------                              
shared pool  Heap0: KGL                    6861360                              
shared pool  KEWS statistic maps              2728                              
shared pool  KEWS sysstat values               256                              
shared pool  xsoqmehift                       2848                              
shared pool  ksxp shared state                  72                              
shared pool  ksfm state object                  32                              
shared pool  ges lmd process descripto        2760                              
shared pool  writes stopped lock state          24                              
shared pool  kwqmncini-slv                     240                              
shared pool  database NCHAR language h         568                              
shared pool  dbwr working sets kcbdbws          16                              

POOL         NAME                            BYTES                              
------------ -------------------------- ----------                              
shared pool  temp lob duration state o        3296                              
shared pool  KEWS fixed SGA                   4600                              
shared pool  ksleid alloc                      112                              
shared pool  KSFD SGA I/O b                3977064                              
shared pool  koh dur heap                      352                              
shared pool  KSN WaitID                        520                              
shared pool  kfkrec_kfdsg                       24                              
shared pool  kksss-heap                      17120                              
shared pool  table definiti                   2536                              
shared pool  resumable                        2720                              
shared pool  KTCN: Row Change Segmente       34496                              

POOL         NAME                            BYTES                              
------------ -------------------------- ----------                              
shared pool  ges process array              407040                              
shared pool  ksuloi: long op free list         128                              
shared pool  ksbtnfy: infrequent actio        1800                              
shared pool  call                            69896                              
shared pool  kelr other metrics table           40                              
shared pool  KSXR pending reply queue       100280                              
shared pool  grplut_kfgsg                      512                              
shared pool  kglsim hash table bkts        4194304                              
shared pool  incr ckpt write count arr         168                              
shared pool  trace events array              68000                              
shared pool  event-class map                  3560                              

POOL         NAME                            BYTES                              
------------ -------------------------- ----------                              
shared pool  Core dump directory               520                              
shared pool  memory transfer history         19208                              
shared pool  plwshs:temphdl                     48                              
shared pool  sim cache nbufs                   640                              
shared pool  Parameter Handle                 1656                              
shared pool  parameter blocks                11960                              
shared pool  SWRF Alerted                     4160                              
shared pool  param hash values                5984                              
shared pool  PX QC deq stats                  1480                              
shared pool  archive_lag_target               9624                              
shared pool  Saved job ids                    8000                              

POOL         NAME                            BYTES                              
------------ -------------------------- ----------                              
shared pool  Banner Storage                   2048                              
shared pool  qmps connections                65280                              
shared pool  broker globals                    160                              
shared pool  parameter table block          347024                              
shared pool  KGSK sga                         2480                              
shared pool  krvxmctx                           40                              
shared pool  parameter text value             4704                              
shared pool  redo allocation latch(es)        2400                              
shared pool  replication session stats       88704                              
shared pool  SGA structure for SWRF (K         240                              
shared pool  kga sga                             8                              

POOL         NAME                            BYTES                              
------------ -------------------------- ----------                              
shared pool  SGA - SWRF Metrics WCTime        1216                              
shared pool  kfmsg                            3608                              
shared pool  KFK SGA                          1144                              
shared pool  latch classes                     352                              
shared pool  kfgsga                            104                              
shared pool  kfgbsg                             40                              
shared pool  Closed Thread SCN Bitvec         8448                              
shared pool  simulator hash buckets          66560                              
shared pool  State object subpools            3968                              
shared pool  AWR Table Info (KEW layer         872                              
shared pool  qesmmaInitialize: pa_qesm       11088                              

POOL         NAME                            BYTES                              
------------ -------------------------- ----------                              
shared pool  kglsim object batch           3848544                              
shared pool  ksws service events             37120                              
shared pool  kebm slave message                152                              
shared pool  X$KSFQP ANCHOR                     80                              
shared pool  event descriptor table          49976                              
shared pool  dbwriter coalesce buffer      1049088                              
shared pool  KTC cch latches                  1760                              
shared pool  kglsim hash table                8208                              
shared pool  kcbl statistics                  6144                              
shared pool  Global Context Heap descr         400                              
shared pool  generic process shared st         456                              

POOL         NAME                            BYTES                              
------------ -------------------------- ----------                              
shared pool  ksv slave class                 14512                              
shared pool  ges enqueue max. usage pe           8                              
shared pool  X$KSVII table                     512                              
shared pool  kcrrorlerr.alo                     48                              
shared pool  ges reserved msg buffers       824008                              
shared pool  KKJ SHRD WRQS                     288                              
shared pool  KJC receiver                      264                              
shared pool  database creation languag         568                              
shared pool  kks stats mem                      64                              
shared pool  Temporary Tables State Ob       30208                              
shared pool  jsksncb: 7                     489472                              

POOL         NAME                            BYTES                              
------------ -------------------------- ----------                              
shared pool  kwrsnfy: kwrs                    1624                              
shared pool  gcs mastership buckets           6144                              
shared pool  kglsim sga                      30456                              
shared pool  enqueue_hash_chain_latche        1280                              
shared pool  ges scan queue array              176                              
shared pool  kzulsg SGA                       2080                              
shared pool  trace_knlasg                      504                              
shared pool  SEQ S.O.                        20160                              
shared pool  sql area                     25865968                              
shared pool  dlo fib struct                  12832                              
shared pool  trigger source                  17560                              

POOL         NAME                            BYTES                              
------------ -------------------------- ----------                              
shared pool  kolfsgi: KOLF's SGA initi           8                              
shared pool  kea advisor definition ca         480                              
shared pool  kelr system metrics table         280                              
shared pool  ksb ci process list (each         704                              
shared pool  ksuloi: long op statistic       86688                              
shared pool  User dump directory               520                              
shared pool  groups_kfgbsg                    4096                              
shared pool  ksfv subheap descriptor           184                              
shared pool  KEWS sesstat seg tbl                8                              
shared pool  enqueue resources              108496                              
shared pool  Wait History                    60480                              

POOL         NAME                            BYTES                              
------------ -------------------------- ----------                              
shared pool  KSXR global channels             1288                              
shared pool  instance cnxn information        6048                              
shared pool  qmtb_init_data                   1712                              
shared pool  latchnum to latch map            3152                              
shared pool  post stats                       1120                              
shared pool  Checkpoint queue               821248                              
shared pool  message pool freequeue         954768                              
shared pool  prirec_kfmdsg                      24                              
shared pool  MTTR advisory context            1648                              
shared pool  log_simultaneous_copies          3200                              
shared pool  PARAMETER ENTRY                    96                              

POOL         NAME                            BYTES                              
------------ -------------------------- ----------                              
shared pool  repository                     692408                              
shared pool  parallel kcbibr                    32                              
shared pool  state objects                    9160                              
shared pool  object level stat table           864                              
shared pool  PRESENTATION TABLE               2048                              
shared pool  scntab_krcpx                    11256                              
shared pool  KQR L SO                       151552                              
shared pool  KGLS SGA                           24                              
shared pool  mvobj part des                  69952                              
shared pool  RTA Boundary Info thread        12672                              
shared pool  buffers waiting for write          24                              

POOL         NAME                            BYTES                              
------------ -------------------------- ----------                              
shared pool  krbmror                       4659200                              
shared pool  joxs heap                        8432                              
shared pool  SGA - AWR Metric RBSM str         504                              
shared pool  SQL Memory Manager Base W       13400                              
shared pool  change tracking state cha        3744                              
shared pool  pso child tracebuf ptrs           880                              
shared pool  kponfy                            672                              
shared pool  name-service table              15856                              
shared pool  cross-platform compliance        2120                              
shared pool  xssinfo                          5952                              
shared pool  KQR ENQ                        103200                              

POOL         NAME                            BYTES                              
------------ -------------------------- ----------                              
shared pool  namrec_kfdsg                       24                              
shared pool  Client ID trace settings         3872                              
shared pool  xdbconf                             8                              
shared pool  plwda:PLW_STR_NEW_VAL_VEC           8                              
shared pool  plwppwp:PLW_STR_NEW_VAL_V          32                              
shared pool  obj stat memo                 2351592                              
shared pool  SGA - SWRF Metric Eidbuf        80696                              
shared pool  process count for each CI         296                              
shared pool  Processor group descripto         256                              
shared pool  channel context areas           31304                              
shared pool  heap_kfsg                         136                              

POOL         NAME                            BYTES                              
------------ -------------------------- ----------                              
shared pool  reservation state object         2744                              
shared pool  SGA - SWRF Metric CHBs         395928                              
shared pool  init_heap_kfsg                 578800                              
shared pool  KTI latch structure              2080                              
shared pool  kcrfa structures                 5280                              
shared pool  KCB undo bitvec                  4096                              
shared pool  kebm slave reply                   88                              
shared pool  kpssnfy: kpsssgct                  32                              
shared pool  kpscad: kpscscon                 4768                              
shared pool  ksmd unit test 1                 5184                              
shared pool  ksim client list                  168                              

POOL         NAME                            BYTES                              
------------ -------------------------- ----------                              
shared pool  kglsim latch area                2720                              
shared pool  kks stats latch                   640                              
shared pool  ges resource hash seq tab         128                              
shared pool  kglsim latches                    136                              
shared pool  KEWS External IDs                 768                              
shared pool  kqlpaac:value-1                   320                              
shared pool  KSPD key heap                    4072                              
shared pool  ksv direct ms                    2224                              
shared pool  KCB Table Scan                     40                              
shared pool  messages                        22880                              
shared pool  HTTP fixed headers                 72                              

POOL         NAME                            BYTES                              
------------ -------------------------- ----------                              
shared pool  KTU latches                      1320                              
shared pool  KGSKI schedule                  58184                              
shared pool  Undo Meta Data                    104                              
shared pool  File Space Usage                11336                              
shared pool  dgtab_kfmdsg                    13184                              
shared pool  event classes                     128                              
shared pool  txncallback                     28512                              
shared pool  ges resource pools                248                              
shared pool  KJCTS implicit batching s          80                              
shared pool  KCB where statistics arra       25888                              
shared pool  KCB incremental ckpt entr         512                              

POOL         NAME                            BYTES                              
------------ -------------------------- ----------                              
shared pool  trigger inform                   2232                              
shared pool  kpummst global in the SGA        1128                              
shared pool  ASM file                        19200                              
shared pool  qmn tasks                        4128                              
shared pool  KCB Table Scan Bitmap             248                              
shared pool  KCB Table Scan Buffer         3981120                              
shared pool  PLS chunk                         352                              
shared pool  KSXR large reply queue         168104                              
shared pool  KESTB existence bitvec          16384                              
shared pool  ksb cic process list              584                              
shared pool  FileOpenBlock                 1085392                              

POOL         NAME                            BYTES                              
------------ -------------------------- ----------                              
shared pool  sort segment handle              3872                              
shared pool  latch descriptor table           1576                              
shared pool  qtree_kwqbsgn                      40                              
shared pool  active checkp                    5664                              
shared pool  segmented arrays                12768                              
shared pool  partitioning d                 328552                              
shared pool  stat hash values                 1520                              
shared pool  object level stats hash t         512                              
shared pool  channel handle                  31176                              
shared pool  Auto tune undo info                96                              
shared pool  sql area:KOKA                   64768                              

POOL         NAME                            BYTES                              
------------ -------------------------- ----------                              
shared pool  UNDO INFO                          16                              
shared pool  name-service request             2592                              
shared pool  latch recovery structures         976                              
shared pool  Label Cache Heap descrptr         160                              
shared pool  qm_init_sga:qmdpsg                 32                              
shared pool  recov_kgqbtctx                   4392                              
shared pool  Cursor Stats                  1767152                              
shared pool  quiescing session                3872                              
shared pool  SHRINK STAT                      3000                              
shared pool  DML lock                       143848                              
shared pool  Monitor Modification Hash         512                              

POOL         NAME                            BYTES                              
------------ -------------------------- ----------                              
shared pool  max allowable # log files      337600                              
shared pool  PX server deq stats              1480                              
shared pool  KSXR SGA                        27848                              
shared pool  kks stbkt                     1572864                              
shared pool  JSX SGA                           112                              
shared pool  Background process state           48                              
shared pool  KGLS heap                     4215328                              
shared pool  ksfqpar                        483240                              
shared pool  quiesce system context            384                              
shared pool  SGA struct - SWRF Metrics        2096                              
shared pool  client/application info l        1280                              

POOL         NAME                            BYTES                              
------------ -------------------------- ----------                              
shared pool  kksss                           12528                              
shared pool  change notification regis       16416                              
shared pool  kohsg                               8                              
shared pool  KGLS SD                          2592                              
shared pool  kzull                             640                              
shared pool  library cache                13453512                              
shared pool  ksfqpn                        1188144                              
shared pool  kfasga                           1048                              
shared pool  row cache child latch            6560                              
shared pool  osp allocation                  23480                              
shared pool  Pre-Warm Initialized Seti         512                              

POOL         NAME                            BYTES                              
------------ -------------------------- ----------                              
shared pool  rules engine context              200                              
shared pool  set_descriptor_array            43776                              
shared pool  SGA Param Source Table            192                              
shared pool  SGA structure for kelr           2336                              
shared pool  listener addresses                 40                              
shared pool  KSI resource types               2704                              
shared pool  trigger condition node             72                              
shared pool  ktlbk state objects             96048                              
shared pool  x$rule_set                      17608                              
shared pool  DBWR event stats array            192                              
shared pool  ksws RLB SGA ctx                   40                              

POOL         NAME                            BYTES                              
------------ -------------------------- ----------                              
shared pool  kghx free lists                 42448                              
shared pool  ges deadlock xid freelist       11264                              
shared pool  X$KSVIT table                     512                              
shared pool  kodosgi kopfdo                    416                              
shared pool  TXN TABLE SEGMENTED ARRAY      126688                              
shared pool  FileIdentificatonBlock         449664                              
shared pool  KFM state obj                    3360                              
shared pool  kso req alloc                    4136                              
shared pool  kwqmncini-tbl                     288                              
shared pool  KKKI consumer                    4136                              
shared pool  Temporary storage for RTA          16                              

POOL         NAME                            BYTES                              
------------ -------------------------- ----------                              
shared pool  KTU lat struct                   1760                              
shared pool  kks stats hds                    1024                              
shared pool  joxs struct                       144                              
shared pool  jsksncb: 4                       4080                              
shared pool  kkj jobq slav                    1280                              
shared pool  eventlist to post commits         192                              
shared pool  dev2node map                     4096                              
shared pool  VIRTUAL CIRCUITS                 3736                              
shared pool  sessions                       691496                              
shared pool  enqueue_hash                    13776                              
shared pool  KTCN: Hash Table Segmente        5184                              

POOL         NAME                            BYTES                              
------------ -------------------------- ----------                              
shared pool  kmgsb circular statistics      108800                              
shared pool  kglsim count of pinned he        8160                              
shared pool  ksunfy: is parent statist        3240                              
shared pool  ksunfy: nodes of hierarch         320                              
shared pool  kglsim alloc latch area          2720                              
shared pool  fdhsh_kffsg                     16392                              
shared pool  fdrec_kffsg                        24                              
shared pool  work area tab                  270144                              
shared pool  AW SGA                             40                              
shared pool  kspd run-time context              16                              
shared pool  KSQ event description            5864                              

POOL         NAME                            BYTES                              
------------ -------------------------- ----------                              
shared pool  latch hashvalue table            1576                              
shared pool  PQ/BizCard                       1536                              
shared pool  block_sizes_array                  48                              
shared pool  recovery domain                 29856                              
shared pool  channel sga anchor                280                              
shared pool  sim state object                   40                              
shared pool  SYSTEM PARAMETERS              288976                              
shared pool  sched job queue                  3616                              
shared pool  sim cache sizes                   640                              
shared pool  LGWR debug module memory         8192                              
shared pool  PARAMETER TABLE                  2048                              

POOL         NAME                            BYTES                              
------------ -------------------------- ----------                              
shared pool  bloom filter                     3104                              
shared pool  Log Archive Config Contex         360                              
shared pool  log file size history arr         168                              
shared pool  sched job slv                    5952                              
shared pool  rule set evalu                  29512                              
shared pool  process group array             33808                              
shared pool  sga dev dict                       56                              
shared pool  sim_knlasg                       1280                              
shared pool  db_files                       215832                              
shared pool  KTI-UNDO                       915512                              
shared pool  KQR X PO                        72832                              

POOL         NAME                            BYTES                              
------------ -------------------------- ----------                              
shared pool  plwda:PLW_STR_NEW_RVAL             24                              
shared pool  plwppwp:garbage handle             32                              
shared pool  block media rcv state obj        2592                              
shared pool  monitoring co                   12480                              
shared pool  krbmrsr                           456                              
shared pool  partitioned file latches        20480                              
shared pool  Prefetch history buffer         11328                              
shared pool  kkzias                            144                              
shared pool  KKJ SGA                           848                              
shared pool  knstsg                             48                              
shared pool  Client ID trace setting h         536                              

POOL         NAME                            BYTES                              
------------ -------------------------- ----------                              
shared pool  Service-level ID trace se        3744                              
shared pool  qm_init_sga:origroot               88                              
shared pool  policy hash table descrpt         280                              
shared pool  plwppwp:PLW_STR_NEW_LEN_V          16                              
shared pool  SCHEDULING POLICY VECTOR          104                              
shared pool  qmcInitSGA:qmsga_acl_prop          32                              
shared pool  Active Session History -         1528                              
shared pool  OS file lock                     4416                              
shared pool  returns from remote ops         49152                              
shared pool  db_block_hash_buckets         1474560                              
shared pool  java static objs                32128                              

POOL         NAME                            BYTES                              
------------ -------------------------- ----------                              
shared pool  temporary foreign ref            2848                              
shared pool  downed inst bit vector             40                              
shared pool  error message file name            64                              
shared pool  kscdnfyglobalflags                  8                              
shared pool  temporary table lock             3744                              
shared pool  KEWS sesstat values             64512                              
shared pool  kcbl state objects              12800                              
shared pool  xsoqojhift                       4128                              
shared pool  list                             4096                              
shared pool  ksir State Object                3360                              
shared pool  dbwriter coalesce bitmap           64                              

POOL         NAME                            BYTES                              
------------ -------------------------- ----------                              
shared pool  kscdnfyinitnext                    16                              
shared pool  kscdnfyinitprev                    16                              
shared pool  KTU latch cleanup                1248                              
shared pool  KJC snd proxy                    4160                              
shared pool  ksfv instance                    4080                              
shared pool  dbwr outstanding ios per           64                              
shared pool  dbwr suspend/resume ptr a          16                              
shared pool  ges regular msg buffers         45608                              
shared pool  Transportable DB Converte        4632                              
shared pool  KRBMROS ANCHOR                     96                              
shared pool  where to latch num map           7304                              

POOL         NAME                            BYTES                              
------------ -------------------------- ----------                              
shared pool  jsksncb: 3                       4048                              
shared pool  kfkid hrec                         24                              
shared pool  kfk lib path                        8                              
shared pool  KTPR HIST TB                     2808                              
shared pool  ksfv subheap                     4136                              
shared pool  ksv reaper                       4128                              
shared pool  free memory                 206711432                              
shared pool  trace buffer                   638976                              
shared pool  dsktab_kfgsg                    50440                              
shared pool  UNDO INFO HASH                   4416                              
shared pool  KGSKI scheduler heap 2 de         232                              

POOL         NAME                            BYTES                              
------------ -------------------------- ----------                              
shared pool  KESTB existence bitvec se         128                              
shared pool  branch so                         296                              
shared pool  KSXR pending consumption        20192                              
shared pool  trigger defini                   6736                              
shared pool  kolbsgi: KOLB's SGA initi           8                              
shared pool  kglsim size of pinned mem       16048                              
shared pool  kewr MMON Remote Flush Re       28672                              
shared pool  kwqmncal: allocate buffer        4048                              
shared pool  knlu_txn_init_btree:init           40                              
shared pool  PCursor                       9740392                              
shared pool  kglsim main lru count           76800                              

POOL         NAME                            BYTES                              
------------ -------------------------- ----------                              
shared pool  kebm run-once actions              16                              
shared pool  grptab_kfgsg                     2464                              
shared pool  ges enqueues                    43784                              
shared pool  kcbl seq io throughput          16000                              
shared pool  kebm slave descriptors           1456                              
shared pool  KEWS aggregation objs            4032                              
shared pool  kglsim free obj list              408                              
shared pool  LISTEN ADDRESS TABLE             2048                              
shared pool  sim kghx free lists                 8                              
shared pool  State object pools               3104                              
shared pool  plis struct                       136                              

POOL         NAME                            BYTES                              
------------ -------------------------- ----------                              
shared pool  PL/SQL DIANA                  1778576                              
shared pool  latch recovery alignment           56                              
shared pool  primem_kfmdsg                    1032                              
shared pool  sys event stats                199136                              
shared pool  parameter handle                48024                              
shared pool  LGWR post requested array           8                              
shared pool  post/wait queues                 6144                              
shared pool  sql area:PLSQL                 509128                              
shared pool  Parameter Table                 35880                              
shared pool  latch nowait fails or sle      116832                              
shared pool  Nettimeout Histogram            48800                              

POOL         NAME                            BYTES                              
------------ -------------------------- ----------                              
shared pool  pso tbs: ksunfy                 57200                              
shared pool  private strands               1717248                              
shared pool  dummy                           10624                              
shared pool  property service SO              3104                              
shared pool  prmtzdini tz region            408320                              
shared pool  KQR M PO                      3217104                              
shared pool  KQR L PO                      1200128                              
shared pool  KQR S SO                        41728                              
shared pool  KRSF SGA                           56                              
shared pool  plugin datafile array            3616                              
shared pool  plwspv:PLW_STR_NEW_VAL             32                              

POOL         NAME                            BYTES                              
------------ -------------------------- ----------                              
shared pool  lckhsh_kffsg                     4104                              
shared pool  RVWR post requested array           8                              
shared pool  lcktab_kffsg                     2592                              
shared pool  PARALLEL T RECO LATCH           15200                              
shared pool  multiblock re                    8224                              
shared pool  KGSKI sga                          80                              
shared pool  MTTR advisory                  116600                              
shared pool  modification                   411952                              
shared pool  public interfaces in ocr         2680                              
shared pool  SGA - SWRF RawMet Runtime        3280                              
shared pool  system default language h         568                              

POOL         NAME                            BYTES                              
------------ -------------------------- ----------                              
shared pool  KGX                            122984                              
shared pool  krcpx                             240                              
shared pool  CGS system incarn array         24864                              
shared pool  SCHEDULING POLICY TABLE           160                              
shared pool  namhsh_kfdsg                     4104                              
shared pool  qm_init_sga:rootname                8                              
shared pool  partitioned file hash buc       65536                              
shared pool  xscalc                           4000                              
shared pool  AQ Propagation Scheduling       16000                              
shared pool  sim segment num bufs             2560                              
shared pool  alter system errs: kspnfy      114688                              

POOL         NAME                            BYTES                              
------------ -------------------------- ----------                              
shared pool  qmuCreatePermSubHeap:subh         136                              
shared pool  session idle latches             1280                              
shared pool  SQL Workarea Histogram           1056                              
shared pool  qesmmaInitialize: ia_qesm         264                              
shared pool  qesmmaInitialize:                 112                              
shared pool  ksb process so list               584                              
shared pool  ksws service object              2752                              
shared pool  fixed allocation callback         856                              
shared pool  done Q child latches              896                              
shared pool  KCB private handles              1320                              
shared pool  flashback generation buff     3981120                              

POOL         NAME                            BYTES                              
------------ -------------------------- ----------                              
shared pool  xsoqsehift                       3104                              
shared pool  xsoqophift                       2848                              
shared pool  KTI pool states                    16                              
shared pool  KTC latch cleanup                 288                              
shared pool  KSFQ buffer pool                 3872                              
shared pool  kspload:comment                    24                              
shared pool  x$ksmfs table                      24                              
shared pool  ges res mastership bucket        4096                              
shared pool  krccr_hp_krccx                  48040                              
shared pool  dbwr message active flag            8                              
shared pool  dbwr suspend/resume array          16                              

POOL         NAME                            BYTES                              
------------ -------------------------- ----------                              
shared pool  ges resource hash table          5632                              
shared pool  jsksncb: 2                       7648                              
shared pool  ges ipc instance maps             384                              
shared pool  KTC latches                      1760                              
shared pool  KSI Indexes                       288                              
shared pool  kwqicaqe2kc1                     8208                              
shared pool  jsksncb: 6                       4176                              
shared pool  KGX rowlist                      1344                              
shared pool  KTPR SUBHEAP                      168                              
shared pool  KGH: NO ACCESS                8993024                              
shared pool  KTF MAPPINGS                    12288                              

POOL         NAME                            BYTES                              
------------ -------------------------- ----------                              
shared pool  event statistics per sess     1169280                              
shared pool  ges big msg buffers            824008                              
shared pool  UNDO STAT INFO                  59904                              
shared pool  branch                          46928                              
shared pool  KJXM msg statistics table        5568                              
shared pool  subheap                        119616                              
shared pool  row cache                     7511248                              
shared pool  type object de                 555040                              
shared pool  KSXR pending messages que      856352                              
shared pool  kgl lock hash table state       10640                              
shared pool  ksuloi: long op used list         128                              

POOL         NAME                            BYTES                              
------------ -------------------------- ----------                              
shared pool  ksuloi: child latches for        1280                              
shared pool  ksuloi: garbage collectio          32                              
shared pool  ksfd shared pool recovery          24                              
shared pool  ges resource                     5288                              
shared pool  kglsim free heap list             408                              
shared pool  processes                         880                              
shared pool  KSXR receive buffers          1036000                              
shared pool  kglsim alloc latches              136                              
shared pool  alert threshol                   4136                              
shared pool  LISTEN ADDRESS ENTRY              448                              
shared pool  qesbl old rows                   1120                              

POOL         NAME                            BYTES                              
------------ -------------------------- ----------                              
shared pool  log_checkpoint_timeout          12360                              
shared pool  PX subheap                     310136                              
shared pool  SERVICE NAMES TABLE              2048                              
shared pool  pspool_kfsg                        80                              
shared pool  sim segment hits                 5120                              
shared pool  procs: ksunfy                  222640                              
shared pool  PLS non-lib hp                  16928                              
shared pool  PG latch table                    640                              
shared pool  PLS cca hp desc                   352                              
shared pool  PX QC msg stats                  2288                              
shared pool  object stat dummy elem             48                              

POOL         NAME                            BYTES                              
------------ -------------------------- ----------                              
shared pool  object stat dummy stat            144                              
shared pool  OS proc request holder          11072                              
shared pool  media recovery state obje        8256                              
shared pool  constraints                     32808                              
shared pool  PX server msg stats              2288                              
shared pool  parameter value memory            496                              
shared pool  reserved entries for all         4096                              
shared pool  SGA param ownership table         192                              
shared pool  SGA - SWRF DrvMet Runtime        4960                              
shared pool  kks sga                            48                              
shared pool  change tracking recovery       262144                              

POOL         NAME                            BYTES                              
------------ -------------------------- ----------                              
shared pool  name-service entry               2592                              
shared pool  Array of cached attr              400                              
shared pool  spfile cleanup structure        16760                              
shared pool  os statistics                      48                              
shared pool  Policy Cache Heap descrpt         160                              
shared pool  obj htab chun                  786944                              
shared pool  Cleanup state objects             384                              
shared pool  slave class sga anchor             88                              
shared pool  resize operation history        28808                              
shared pool  simulator hash latch            20480                              
shared pool  name-service                    17248                              

POOL         NAME                            BYTES                              
------------ -------------------------- ----------                              
shared pool  time manager context               40                              
shared pool  file # to first dba, exte        2416                              
shared pool  flashback_marker_cache_si        9200                              
shared pool  KEWS statistic name              1760                              
shared pool  kgllk hash table               155648                              
shared pool  kscdnfyinitflags                    8                              
shared pool  ges enqueue multiple free         160                              
shared pool  ges lms process descripto        2760                              
shared pool  kxfpdp pointers                 28800                              
shared pool  KFG state obj                    4128                              
shared pool  kzsrs filename                    536                              

POOL         NAME                            BYTES                              
------------ -------------------------- ----------                              
shared pool  distributed_transactions-       12728                              
shared pool  KCK type array                    936                              
shared pool  KTI latches                       416                              
shared pool  KGSK scheduler                  49272                              
shared pool  KKJ WRK LAT                       480                              
shared pool  ges shared global area          23928                              
shared pool  kfkhsh_kfdsg                     4104                              
shared pool  jsksncb-latch                    2560                              
shared pool  gcs commit sga state           106728                              
shared pool  event statistics ptr arra        1008                              
shared pool  KGKP randnum                    40000                              

POOL         NAME                            BYTES                              
------------ -------------------------- ----------                              
large pool   krcc extent chunk             2076672                              
large pool   PX msg pool                   1076000                              
large pool   CTWR dba buffer                839680                              
large pool   ASM map operations hashta      393216                              
large pool   free memory                  37557472                              
java pool    free memory                   2709568                              
java pool    joxs heap                      471744                              
java pool    joxlod exec hp               13595904                              

690 rows selected.

SQL> select   pool,name,sum(bytes)
  2  from     v$sgastat
  3  where    pool in ('shared pool','java pool','large pool')
  4  group by rollup (pool,name);

POOL         NAME                       SUM(BYTES)                              
------------ -------------------------- ----------                              
java pool    joxs heap                      471744                              
java pool    free memory                   2709568                              
java pool    joxlod exec hp               13595904                              
java pool                                 16777216                              
large pool   PX msg pool                   1076000                              
large pool   free memory                  37557472                              
large pool   CTWR dba buffer                839680                              
large pool   krcc extent chunk             2076672                              
large pool   ASM map operations hashta      393216                              
large pool                                41943040                              
shared pool  KGX                            122984                              

POOL         NAME                       SUM(BYTES)                              
------------ -------------------------- ----------                              
shared pool  call                            69896                              
shared pool  list                             4096                              
shared pool  dummy                           10624                              
shared pool  kfmsg                            3608                              
shared pool  kksss                           12528                              
shared pool  knlsg                             120                              
shared pool  kohsg                               8                              
shared pool  krcpx                             240                              
shared pool  kzull                             640                              
shared pool  kzulu                             560                              
shared pool  AW SGA                             40                              

POOL         NAME                       SUM(BYTES)                              
------------ -------------------------- ----------                              
shared pool  branch                          46928                              
shared pool  kcrrny                          33760                              
shared pool  kfasga                           1048                              
shared pool  kfdsga                            128                              
shared pool  kffsga                            120                              
shared pool  kfgbsg                             40                              
shared pool  kfgsga                            104                              
shared pool  kfmdsg                            144                              
shared pool  kkzias                            144                              
shared pool  knstsg                             48                              
shared pool  kponfy                            672                              

POOL         NAME                       SUM(BYTES)                              
------------ -------------------------- ----------                              
shared pool  ksfqpa                          62432                              
shared pool  ksfqpn                        1188144                              
shared pool  xscalc                           4000                              
shared pool  CCursor                      13618208                              
shared pool  JSX SGA                           112                              
shared pool  KFK SGA                          1144                              
shared pool  KGLS SD                          2592                              
shared pool  KGLS SP                          4704                              
shared pool  KKJ SGA                           848                              
shared pool  KQR ENQ                        103200                              
shared pool  KSK SGA                         76592                              

POOL         NAME                       SUM(BYTES)                              
------------ -------------------------- ----------                              
shared pool  PCursor                       9740392                              
shared pool  enqueue                        293600                              
shared pool  kga sga                             8                              
shared pool  kks sga                            48                              
shared pool  krbmror                       4659200                              
shared pool  krbmrsr                           456                              
shared pool  krvxdka                           592                              
shared pool  ksfqpar                        483240                              
shared pool  subheap                        119616                              
shared pool  xdbconf                             8                              
shared pool  xssinfo                          5952                              

POOL         NAME                       SUM(BYTES)                              
------------ -------------------------- ----------                              
shared pool  ASM file                        19200                              
shared pool  DML lock                       143848                              
shared pool  KGKP sga                           32                              
shared pool  KGLS SGA                           24                              
shared pool  KGSK sga                         2480                              
shared pool  KQR L PO                      1200128                              
shared pool  KQR L SO                       151552                              
shared pool  KQR M PO                      3217104                              
shared pool  KQR M SO                      1900392                              
shared pool  KQR S SO                        41728                              
shared pool  KQR X PO                        72832                              

POOL         NAME                       SUM(BYTES)                              
------------ -------------------------- ----------                              
shared pool  KRSF SGA                           56                              
shared pool  KSFV SGA                          824                              
shared pool  KSIR SGA                          128                              
shared pool  KSXR SGA                        27848                              
shared pool  KTI-UNDO                       915512                              
shared pool  SEQ S.O.                        20160                              
shared pool  X$KSXPIA                         2680                              
shared pool  db_files                       215832                              
shared pool  krvxlctx                          248                              
shared pool  krvxmctx                           40                              
shared pool  messages                        22880                              

POOL         NAME                       SUM(BYTES)                              
------------ -------------------------- ----------                              
shared pool  pq_krcpx                          960                              
shared pool  sessions                       691496                              
shared pool  sql area                     25898520                              
shared pool  1:kngisga                       32088                              
shared pool  Alert log                         520                              
shared pool  KGLS heap                     4215328                              
shared pool  KGSKI sga                          80                              
shared pool  PLS chunk                         352                              
shared pool  UNDO INFO                          16                              
shared pool  X$SKGXPIA                        2680                              
shared pool  branch so                         296                              

POOL         NAME                       SUM(BYTES)                              
------------ -------------------------- ----------                              
shared pool  heap_kfsg                         136                              
shared pool  joxs heap                        8432                              
shared pool  kks stats                          40                              
shared pool  kks stbkt                     1572864                              
shared pool  plwpil:wa                        4264                              
shared pool  processes                         880                              
shared pool  qmn tasks                        4128                              
shared pool  resumable                        2720                              
shared pool  row cache                     7511248                              
shared pool  xslongops                        2592                              
shared pool  Heap0: KGL                    6866776                              

POOL         NAME                       SUM(BYTES)                              
------------ -------------------------- ----------                              
shared pool  KSN WaitID                        520                              
shared pool  PQ/BizCard                       1536                              
shared pool  PX subheap                     310136                              
shared pool  jsksncb: 2                       7648                              
shared pool  jsksncb: 3                       4048                              
shared pool  jsksncb: 4                       4080                              
shared pool  jsksncb: 6                       4176                              
shared pool  jsksncb: 7                     489472                              
shared pool  jsksncb: 8                       1024                              
shared pool  jsksncb: 9                      28992                              
shared pool  kfkid hash                       4104                              

POOL         NAME                       SUM(BYTES)                              
------------ -------------------------- ----------                              
shared pool  kfkid hrec                         24                              
shared pool  kglsim sga                      30456                              
shared pool  kksss-heap                      17120                              
shared pool  ksv reaper                       4128                              
shared pool  kzulsg SGA                       2080                              
shared pool  post stats                       1120                              
shared pool  repository                     692408                              
shared pool  sim_knlasg                       1280                              
shared pool  x$rule_set                      17608                              
shared pool  xsoqmehift                       2848                              
shared pool  xsoqojhift                       4128                              

POOL         NAME                       SUM(BYTES)                              
------------ -------------------------- ----------                              
shared pool  xsoqophift                       2848                              
shared pool  xsoqsehift                       3104                              
shared pool  ASH buffers                  13421776                              
shared pool  KGX rowlist                      1344                              
shared pool  KKJ WRK LAT                       480                              
shared pool  KSI Indexes                       288                              
shared pool  KTC latches                      1760                              
shared pool  KTI latches                       416                              
shared pool  KTU latches                      1320                              
shared pool  PQ/ResSched                      1040                              
shared pool  SHRINK STAT                      3000                              

POOL         NAME                       SUM(BYTES)                              
------------ -------------------------- ----------                              
shared pool  cinfo_kfnsg                      4104                              
shared pool  constraints                     32808                              
shared pool  fdhsh_kffsg                     16392                              
shared pool  fdrec_kffsg                        24                              
shared pool  free memory                 206669856                              
shared pool  idtab_kfksg                     45320                              
shared pool  joxs struct                       144                              
shared pool  kglsim heap                   3273984                              
shared pool  plis struct                       136                              
shared pool  pspool_kfsg                        80                              
shared pool  transaction                    295328                              

POOL         NAME                       SUM(BYTES)                              
------------ -------------------------- ----------                              
shared pool  txncallback                     28512                              
shared pool  Cursor Stats                  1767152                              
shared pool  KFG SO child                     5056                              
shared pool  KGKP randnum                    40000                              
shared pool  KTF MAPPINGS                    12288                              
shared pool  KTPR HIST TB                     2808                              
shared pool  KTPR SUBHEAP                      168                              
shared pool  MS alert log                    72704                              
shared pool  OS file lock                     4416                              
shared pool  PL/SQL DIANA                  1778576                              
shared pool  Wait History                    60480                              

POOL         NAME                       SUM(BYTES)                              
------------ -------------------------- ----------                              
shared pool  bloom filter                     3104                              
shared pool  dev2node map                     4096                              
shared pool  dgtab_kfmdsg                    13184                              
shared pool  dpslut_kfdsg                      512                              
shared pool  dsktab_kfgsg                    50440                              
shared pool  enqueue_hash                    13776                              
shared pool  ges enqueues                    43784                              
shared pool  grplut_kfgsg                      512                              
shared pool  grptab_kfgsg                     2464                              
shared pool  kfk lib path                        8                              
shared pool  kfkhsh_kfdsg                     4104                              

POOL         NAME                       SUM(BYTES)                              
------------ -------------------------- ----------                              
shared pool  kfkrec_kfdsg                       24                              
shared pool  koh dur heap                      352                              
shared pool  ksfv subheap                     4136                              
shared pool  ksleid alloc                      112                              
shared pool  ksv work msg                     4464                              
shared pool  kwqicaqe2kc1                     8208                              
shared pool  lckhsh_kffsg                     4104                              
shared pool  lckhsr_kffsg                       24                              
shared pool  lcktab_kffsg                     2592                              
shared pool  namhsh_kfdsg                     4104                              
shared pool  namhsh_kfgsg                      288                              

POOL         NAME                       SUM(BYTES)                              
------------ -------------------------- ----------                              
shared pool  namrec_kfdsg                       24                              
shared pool  procs_kfgbsg                      616                              
shared pool  scntab_krcpx                    11256                              
shared pool  sga dev dict                       56                              
shared pool  sga node map                       16                              
shared pool  trace buffer                   638976                              
shared pool  trace_knlasg                      504                              
shared pool  ENQUEUE STATS                   11928                              
shared pool  FileOpenBlock                 1085392                              
shared pool  KFG state obj                    4128                              
shared pool  KFM state obj                    3360                              

POOL         NAME                       SUM(BYTES)                              
------------ -------------------------- ----------                              
shared pool  KJC receiver                      264                              
shared pool  KJC snd proxy                    4160                              
shared pool  KKJ SHRD WRQS                     288                              
shared pool  KSPD key heap                    4072                              
shared pool  PL/SQL MPCODE                 1961000                              
shared pool  SWRF Alerted                     4160                              
shared pool  Saved job ids                    8000                              
shared pool  Sort Segment                    12368                              
shared pool  X$KSVII table                     512                              
shared pool  X$KSVIS table                     128                              
shared pool  X$KSVIT table                     512                              

POOL         NAME                       SUM(BYTES)                              
------------ -------------------------- ----------                              
shared pool  active checkp                    5664                              
shared pool  event classes                     128                              
shared pool  ges resource                     5288                              
shared pool  groups_kfgbsg                    4096                              
shared pool  jsksncb-latch                    2560                              
shared pool  kkj jobq  wor                    4128                              
shared pool  kkj jobq slav                    1280                              
shared pool  kks stats hds                    1024                              
shared pool  kks stats mem                      64                              
shared pool  kodosgi kodos                      32                              
shared pool  ksfv instance                    4080                              

POOL         NAME                       SUM(BYTES)                              
------------ -------------------------- ----------                              
shared pool  kso req alloc                    4136                              
shared pool  ksv direct ms                    2224                              
shared pool  kwqmncini-slv                     240                              
shared pool  kwqmncini-tbl                     288                              
shared pool  kwrsnfy: kwrs                    1624                              
shared pool  latch classes                     352                              
shared pool  library cache                13453880                              
shared pool  modification                   411952                              
shared pool  monitoring co                   12480                              
shared pool  multiblock re                    8224                              
shared pool  name-service                    17248                              

POOL         NAME                       SUM(BYTES)                              
------------ -------------------------- ----------                              
shared pool  obj htab chun                  786944                              
shared pool  obj stat memo                 2351592                              
shared pool  object level                   435120                              
shared pool  object queue                   459984                              
shared pool  os statistics                      48                              
shared pool  primem_kfmdsg                    1032                              
shared pool  prirec_kfmdsg                      24                              
shared pool  procs: ksunfy                  222640                              
shared pool  qtree_kwqbsgn                      40                              
shared pool  sched job slv                    5952                              
shared pool  sim trace buf                    5144                              

POOL         NAME                       SUM(BYTES)                              
------------ -------------------------- ----------                              
shared pool  sql area:KOKA                   64768                              
shared pool  state objects                    9160                              
shared pool  threshold ale                   12192                              
shared pool  work area tab                  270144                              
shared pool  x$ksmfs table                      24                              
shared pool  Banner Storage                   2048                              
shared pool  KCB Table Scan                     40                              
shared pool  KCK type array                    936                              
shared pool  KEWS fixed SGA                   4600                              
shared pool  KGH: NO ACCESS                8993024                              
shared pool  KGSK scheduler                  49272                              

POOL         NAME                       SUM(BYTES)                              
------------ -------------------------- ----------                              
shared pool  KGSKI schedule                  58184                              
shared pool  KKKI consumer                    4136                              
shared pool  KRBMROS ANCHOR                     96                              
shared pool  KSFD SGA I/O b                3977064                              
shared pool  KTU lat struct                   1760                              
shared pool  KTUR HIST INFO                   4840                              
shared pool  MTTR advisory                  116600                              
shared pool  PG latch table                    640                              
shared pool  PLS non-lib hp                  16928                              
shared pool  UNDO INFO HASH                   4416                              
shared pool  UNDO STAT INFO                  59904                              

POOL         NAME                       SUM(BYTES)                              
------------ -------------------------- ----------                              
shared pool  Undo Meta Data                    104                              
shared pool  X$KSFQP ANCHOR                     80                              
shared pool  XDB Schema Cac                7960504                              
shared pool  alert threshol                   4136                              
shared pool  broker globals                    160                              
shared pool  buffer handles                 154008                              
shared pool  channel handle                  31176                              
shared pool  dlo fib struct                  12832                              
shared pool  init_heap_kfsg                 578800                              
shared pool  joxlod exec hp                 974496                              
shared pool  kcrrorlerr.alo                     48                              

POOL         NAME                       SUM(BYTES)                              
------------ -------------------------- ----------                              
shared pool  kglsim latches                    136                              
shared pool  kodosgi kopfdo                    416                              
shared pool  krccr_hp_krccx                  48040                              
shared pool  kzsrs filename                    536                              
shared pool  mvobj part des                  69952                              
shared pool  osp allocation                  23480                              
shared pool  partitioning d                 328552                              
shared pool  plwshs:temphdl                     48                              
shared pool  qesbl old rows                   1120                              
shared pool  qmtb_init_data                   1712                              
shared pool  qtree_kwqbspse                     40                              

POOL         NAME                       SUM(BYTES)                              
------------ -------------------------- ----------                              
shared pool  recov_kgqbtctx                   4392                              
shared pool  rule set evalu                  29512                              
shared pool  sql area:PLSQL                 509128                              
shared pool  table definiti                   2536                              
shared pool  trigger defini                   6736                              
shared pool  trigger inform                   2232                              
shared pool  trigger source                  17560                              
shared pool  type object de                 555040                              
shared pool  KCB undo bitvec                  4096                              
shared pool  KTC cch latches                  1760                              
shared pool  KTI pool states                    16                              

POOL         NAME                       SUM(BYTES)                              
------------ -------------------------- ----------                              
shared pool  LRMPD SGA Table                167440                              
shared pool  PARAMETER ENTRY                    96                              
shared pool  PARAMETER TABLE                  2048                              
shared pool  PLS cca hp desc                   352                              
shared pool  PX QC deq stats                  1480                              
shared pool  PX QC msg stats                  2288                              
shared pool  PX subheap desc                   256                              
shared pool  Parameter Table                 35880                              
shared pool  event-class map                  3560                              
shared pool  kcbl statistics                  6144                              
shared pool  kghx free lists                 42448                              

POOL         NAME                       SUM(BYTES)                              
------------ -------------------------- ----------                              
shared pool  kks stats latch                   640                              
shared pool  kqlpaac:value-1                   320                              
shared pool  kscdnfyinithead                    16                              
shared pool  kscdnfyinitnext                    16                              
shared pool  kscdnfyinitprev                    16                              
shared pool  kspload:comment                    24                              
shared pool  ksv slave class                 14512                              
shared pool  kxfpdp pointers                 28800                              
shared pool  parallel kcbibr                    32                              
shared pool  private strands               1717248                              
shared pool  pso tbs: ksunfy                 57200                              

POOL         NAME                       SUM(BYTES)                              
------------ -------------------------- ----------                              
shared pool  recovery domain                 29856                              
shared pool  sched job queue                  3616                              
shared pool  sga listelement                  2048                              
shared pool  sim cache nbufs                   640                              
shared pool  sim cache sizes                   640                              
shared pool  sys event stats                199136                              
shared pool  Checkpoint queue               821248                              
shared pool  DISPATCHERS INFO                  240                              
shared pool  File Space Usage                11336                              
shared pool  KSFQ buffer pool                 3872                              
shared pool  Parameter Handle                 1656                              

POOL         NAME                       SUM(BYTES)                              
------------ -------------------------- ----------                              
shared pool  VIRTUAL CIRCUITS                 3736                              
shared pool  java static objs                32128                              
shared pool  kcrfa structures                 5280                              
shared pool  kebm slave reply                   88                              
shared pool  kgllk hash table               155648                              
shared pool  kpscad: kpscscon                 4768                              
shared pool  kscdnfyinitflags                    8                              
shared pool  ksim client list                  168                              
shared pool  ksmd unit test 1                 5184                              
shared pool  ksws RLB SGA ctx                   40                              
shared pool  osp pool handles                    8                              

POOL         NAME                       SUM(BYTES)                              
------------ -------------------------- ----------                              
shared pool  parameter blocks                11960                              
shared pool  parameter handle                48024                              
shared pool  post/wait queues                 6144                              
shared pool  qm_init_uga:qmsg                20632                              
shared pool  qmps connections                65280                              
shared pool  segmented arrays                12768                              
shared pool  sim lru segments                 5120                              
shared pool  sim segment hits                 5120                              
shared pool  sim state object                   40                              
shared pool  stat hash values                 1520                              
shared pool  KEWS External IDs                 768                              

POOL         NAME                       SUM(BYTES)                              
------------ -------------------------- ----------                              
shared pool  KTC latch cleanup                 288                              
shared pool  KTU latch cleanup                1248                              
shared pool  KUPP subheap desc                 232                              
shared pool  SYSTEM PARAMETERS              288976                              
shared pool  block_sizes_array                  48                              
shared pool  enqueue resources              108496                              
shared pool  ges process array              407040                              
shared pool  kebm test replies               28672                              
shared pool  kglsim hash table                8208                              
shared pool  kglsim latch area                2720                              
shared pool  kpssnfy: kpsssgct                  32                              

POOL         NAME                       SUM(BYTES)                              
------------ -------------------------- ----------                              
shared pool  ksfm state object                  32                              
shared pool  ksir State Object                3360                              
shared pool  ksxp shared state                  72                              
shared pool  param hash values                5984                              
shared pool  quiescing session                3872                              
shared pool  ASM map operations               3616                              
shared pool  ArchLog Dest Array               7656                              
shared pool  HTTP fixed headers                 72                              
shared pool  KSI resource types               2704                              
shared pool  PRESENTATION TABLE               2048                              
shared pool  PX msg pool struct               1088                              

POOL         NAME                       SUM(BYTES)                              
------------ -------------------------- ----------                              
shared pool  SERVICE NAME ENTRY                168                              
shared pool  State object pools               3104                              
shared pool  analytic workspace               3616                              
shared pool  archive_lag_target               9624                              
shared pool  channel sga anchor                280                              
shared pool  ges resource pools                248                              
shared pool  kcbl state objects              12800                              
shared pool  kebm slave message                152                              
shared pool  kscdnfyglobalflags                  8                              
shared pool  listener addresses                 40                              
shared pool  name-service entry               2592                              

POOL         NAME                       SUM(BYTES)                              
------------ -------------------------- ----------                              
shared pool  name-service table              15856                              
shared pool  qm_init_sga:oidctx                  8                              
shared pool  qm_init_sga:qmdpsg                 32                              
shared pool  trace events array              68000                              
shared pool  Auto tune undo info                96                              
shared pool  Core dump directory               520                              
shared pool  KCB private handles              1320                              
shared pool  KEWS sesstat values             64512                              
shared pool  KEWS statistic maps              2728                              
shared pool  KEWS statistic name              1760                              
shared pool  KEWS sysstat values               256                              

POOL         NAME                       SUM(BYTES)                              
------------ -------------------------- ----------                              
shared pool  KTI latch structure              2080                              
shared pool  PX server deq stats              1480                              
shared pool  PX server msg stats              2288                              
shared pool  SERVICE NAMES TABLE              2048                              
shared pool  SHARED SERVERS INFO               240                              
shared pool  User dump directory               520                              
shared pool  Wait event pointers               336                              
shared pool  ges big msg buffers            824008                              
shared pool  kglsim object batch           3848544                              
shared pool  kglsim pin list arr              1224                              
shared pool  kqlpWrntoStr:string               208                              

POOL         NAME                       SUM(BYTES)                              
------------ -------------------------- ----------                              
shared pool  ksb process so list               584                              
shared pool  ksws service events             37120                              
shared pool  ksws service object              2752                              
shared pool  ktlbk state objects             96048                              
shared pool  msg Q child latches               896                              
shared pool  network connections             62880                              
shared pool  prmtzdini tz region            408320                              
shared pool  process group array             33808                              
shared pool  property service SO              3104                              
shared pool  service names array                56                              
shared pool  sim kghx free lists                 8                              

POOL         NAME                       SUM(BYTES)                              
------------ -------------------------- ----------                              
shared pool  sort segment handle              3872                              
shared pool  trace buf hdr xtend             35088                              
shared pool  Array of cached attr              400                              
shared pool  KEWS sesstat seg tbl                8                              
shared pool  KSXR global channels             1288                              
shared pool  KSXR receive buffers          1036000                              
shared pool  LISTEN ADDRESS ENTRY              448                              
shared pool  LISTEN ADDRESS TABLE             2048                              
shared pool  Nettimeout Histogram            48800                              
shared pool  character set memory           354072                              
shared pool  character set object           243832                              

POOL         NAME                       SUM(BYTES)                              
------------ -------------------------- ----------                              
shared pool  done Q child latches              896                              
shared pool  gcs commit sga state           106728                              
shared pool  ges scan queue array              176                              
shared pool  kglsim alloc latches              136                              
shared pool  kglsim free obj list              408                              
shared pool  kglsim main lru size           151040                              
shared pool  kglsim recovery area             2904                              
shared pool  ksb cic process list              584                              
shared pool  kso req alloc heapds              280                              
shared pool  name-service request             2592                              
shared pool  parallel_max_servers            12160                              

POOL         NAME                       SUM(BYTES)                              
------------ -------------------------- ----------                              
shared pool  parameter text value             4704                              
shared pool  qm_init_sga:origroot               88                              
shared pool  qm_init_sga:rootname                8                              
shared pool  rules engine context              200                              
shared pool  sess Q child latches              896                              
shared pool  session idle latches             1280                              
shared pool  set_descriptor_array            43776                              
shared pool  sim segment num bufs             2560                              
shared pool  simulator hash latch            20480                              
shared pool  temporary table lock             3744                              
shared pool  time manager context               40                              

POOL         NAME                       SUM(BYTES)                              
------------ -------------------------- ----------                              
shared pool  Cleanup state objects             384                              
shared pool  KCB Table Scan Bitmap             248                              
shared pool  KCB Table Scan Buffer         3981120                              
shared pool  KEWS aggregation objs            4032                              
shared pool  KSQ event description            5864                              
shared pool  MTTR advisory context            1648                              
shared pool  PARALLEL T RECO LATCH           15200                              
shared pool  State object subpools            3968                              
shared pool  channel context areas           31304                              
shared pool  db_block_hash_buckets         1474560                              
shared pool  ges ipc instance maps             384                              

POOL         NAME                       SUM(BYTES)                              
------------ -------------------------- ----------                              
shared pool  hot latch diagnostics             160                              
shared pool  invalid low rba queue            2048                              
shared pool  kebm run-once actions              16                              
shared pool  kglsim free heap list             408                              
shared pool  kglsim main lru count           76800                              
shared pool  kspd run-time context              16                              
shared pool  kzekm heap descriptor             304                              
shared pool  latch hashvalue table            1576                              
shared pool  latchnum to latch map            3152                              
shared pool  parameter table block          347024                              
shared pool  plugin datafile array            3616                              

POOL         NAME                       SUM(BYTES)                              
------------ -------------------------- ----------                              
shared pool  row cache child latch            6560                              
shared pool  sim trace buf context             200                              
shared pool  temporary foreign ref            2848                              
shared pool  DBWR event stats array            192                              
shared pool  FileIdentificatonBlock         449664                              
shared pool  KESTB existence bitvec          16384                              
shared pool  KSXR large reply queue         168104                              
shared pool  OS proc request holder          11072                              
shared pool  SGA - SWRF Metric CHBs         395928                              
shared pool  SGA Param Source Table            192                              
shared pool  SGA structure for kelr           2336                              

POOL         NAME                       SUM(BYTES)                              
------------ -------------------------- ----------                              
shared pool  SQL Workarea Histogram           1056                              
shared pool  buffer_pool_desc_array           3384                              
shared pool  downed inst bit vector             40                              
shared pool  event descriptor table          49976                              
shared pool  gcs mastership buckets           6144                              
shared pool  ges process hash table          14080                              
shared pool  ges shared global area          23928                              
shared pool  kcbl seq io throughput          16000                              
shared pool  kebm slave descriptors           1456                              
shared pool  kelt translation table            312                              
shared pool  kglsim hash table bkts        4194304                              

POOL         NAME                       SUM(BYTES)                              
------------ -------------------------- ----------                              
shared pool  latch descriptor table           1576                              
shared pool  log_checkpoint_timeout          12360                              
shared pool  message pool freequeue         954768                              
shared pool  object stat dummy elem             48                              
shared pool  object stat dummy stat            144                              
shared pool  parameter value memory            496                              
shared pool  plwda:PLW_STR_NEW_RVAL             24                              
shared pool  plwppwp:garbage handle             32                              
shared pool  plwspv:PLW_STR_NEW_VAL             32                              
shared pool  quiesce system context            384                              
shared pool  simulator hash buckets          66560                              

POOL         NAME                       SUM(BYTES)                              
------------ -------------------------- ----------                              
shared pool  slave class sga anchor             88                              
shared pool  trigger condition node             72                              
shared pool  where to latch num map           7304                              
shared pool  ASM rollback operations          2592                              
shared pool  CGS system incarn array         24864                              
shared pool  Detached dump directory           520                              
shared pool  KEWS statistic metadata         12032                              
shared pool  Prefetch history buffer         11328                              
shared pool  SCHEDULING POLICY TABLE           160                              
shared pool  error message file name            64                              
shared pool  ges regular msg buffers         45608                              

POOL         NAME                       SUM(BYTES)                              
------------ -------------------------- ----------                              
shared pool  ges resource hash table          5632                              
shared pool  kglsim alloc latch area          2720                              
shared pool  kgsk subheap descriptor           136                              
shared pool  ksfv subheap descriptor           184                              
shared pool  log_simultaneous_copies          3200                              
shared pool  logout storm management           880                              
shared pool  memory transfer history         19208                              
shared pool  object level stat table           864                              
shared pool  pso child tracebuf ptrs           880                              
shared pool  returns from remote ops         49152                              
shared pool  ASM extent pointer array       191680                              

POOL         NAME                       SUM(BYTES)                              
------------ -------------------------- ----------                              
shared pool  Client ID trace settings         3872                              
shared pool  Closed Thread SCN Bitvec         8448                              
shared pool  KSXR pending reply queue       100280                              
shared pool  LGWR debug module memory         8192                              
shared pool  LGWR-network Server info        27648                              
shared pool  SCHEDULING POLICY VECTOR          104                              
shared pool  SGA - SWRF Metric Eidbuf        80696                              
shared pool  dbwriter coalesce bitmap           64                              
shared pool  dbwriter coalesce buffer      1049088                              
shared pool  file # translation table        33656                              
shared pool  ges reserved msg buffers       824008                              

POOL         NAME                       SUM(BYTES)                              
------------ -------------------------- ----------                              
shared pool  kelr other metrics table           40                              
shared pool  knlu_txn_init_btree:init           40                              
shared pool  latch recovery alignment           56                              
shared pool  partitioned file latches        20480                              
shared pool  public interfaces in ocr         2680                              
shared pool  reservation state object         2744                              
shared pool  resize operation history        28808                              
shared pool  returns from metrics req       763904                              
shared pool  spfile cleanup structure        16760                              
shared pool  AQ Propagation Scheduling       16000                              
shared pool  AWR Table Info (KEW layer         872                              

POOL         NAME                       SUM(BYTES)                              
------------ -------------------------- ----------                              
shared pool  Active Session History -         1528                              
shared pool  BRANCH TABLE SEGMENTED AR      152736                              
shared pool  Background process state           48                              
shared pool  Client ID trace setting h         536                              
shared pool  Global Context Heap descr         400                              
shared pool  KCB buffer wait statistic        3352                              
shared pool  KCB incremental ckpt entr         512                              
shared pool  KCB where statistics arra       25888                              
shared pool  KESTB existence bitvec se         128                              
shared pool  KGSKI scheduler heap 2 de         232                              
shared pool  KJCTS implicit batching s          80                              

POOL         NAME                       SUM(BYTES)                              
------------ -------------------------- ----------                              
shared pool  KJCTS process batching st          80                              
shared pool  KJXM msg statistics table        5568                              
shared pool  KQF optimizer stats table        4824                              
shared pool  KSXR pending consumption        20192                              
shared pool  KSXR pending messages que      856352                              
shared pool  KTCN: Hash Table Segmente        5184                              
shared pool  KTCN: Obj Invalidation Se        2336                              
shared pool  KTCN: Row Change Segmente       34496                              
shared pool  LGWR post requested array           8                              
shared pool  Label Cache Heap descrptr         160                              
shared pool  Log Archive Config Contex         360                              

POOL         NAME                       SUM(BYTES)                              
------------ -------------------------- ----------                              
shared pool  Managed Standby Proc Arra       24576                              
shared pool  Monitor Modification Hash         512                              
shared pool  Policy Cache Heap descrpt         160                              
shared pool  Pre-Warm Initialized Seti         512                              
shared pool  Prefetch client count per          32                              
shared pool  Prefetch history buffer a         320                              
shared pool  Processor group descripto         256                              
shared pool  RTA Boundary Info thread        12672                              
shared pool  RVWR post requested array           8                              
shared pool  SGA - AWR Metric RBSM str         504                              
shared pool  SGA - SWRF DrvMet Runtime        4960                              

POOL         NAME                       SUM(BYTES)                              
------------ -------------------------- ----------                              
shared pool  SGA - SWRF Metrics WCTime        1216                              
shared pool  SGA - SWRF Metrics ksuTim        1216                              
shared pool  SGA - SWRF RawMet Runtime        3280                              
shared pool  SGA - SWRF Time Model Bas          64                              
shared pool  SGA Obsolete Param Source          16                              
shared pool  SGA param ownership table         192                              
shared pool  SGA struct - SWRF Metrics        2096                              
shared pool  SGA structure for SWRF (K         240                              
shared pool  SQL Memory Manager Base W       13400                              
shared pool  Service-level ID trace se        3744                              
shared pool  Service-level trace setti         536                              

POOL         NAME                       SUM(BYTES)                              
------------ -------------------------- ----------                              
shared pool  TXN TABLE SEGMENTED ARRAY      126688                              
shared pool  Temporary Tables State Ob       30208                              
shared pool  Temporary storage for RTA          16                              
shared pool  Transportable DB Converte        4632                              
shared pool  UNDO INFO SEGMENTED ARRAY       25896                              
shared pool  alter system errs: kspnfy      114688                              
shared pool  block media rcv state obj        2592                              
shared pool  buffers waiting for write          24                              
shared pool  change notification obj m       16416                              
shared pool  change notification regis       16416                              
shared pool  change tracking recovery       262144                              

POOL         NAME                       SUM(BYTES)                              
------------ -------------------------- ----------                              
shared pool  change tracking state cha        3744                              
shared pool  client/application info l        1280                              
shared pool  cross-platform compliance        2120                              
shared pool  database NCHAR language h         568                              
shared pool  database creation languag         568                              
shared pool  dbwr actual working sets           64                              
shared pool  dbwr message active flag            8                              
shared pool  dbwr outstanding ios per           64                              
shared pool  dbwr suspend/resume array          16                              
shared pool  dbwr suspend/resume ptr a          16                              
shared pool  dbwr working sets kcbdbws          16                              

POOL         NAME                       SUM(BYTES)                              
------------ -------------------------- ----------                              
shared pool  dbwriter coalesce struct           48                              
shared pool  distributed_transactions-       12728                              
shared pool  enqueue_hash_chain_latche        1280                              
shared pool  event statistics per sess     1169280                              
shared pool  event statistics ptr arra        1008                              
shared pool  eventlist to post commits         192                              
shared pool  file # to first dba, exte        2416                              
shared pool  fixed allocation callback         856                              
shared pool  flashback generation buff     3981120                              
shared pool  flashback_marker_cache_si        9200                              
shared pool  generic process shared st         456                              

POOL         NAME                       SUM(BYTES)                              
------------ -------------------------- ----------                              
shared pool  ges deadlock xid freelist       11264                              
shared pool  ges deadlock xid hash tab       17800                              
shared pool  ges enqueue cur. usage pe           8                              
shared pool  ges enqueue max. usage pe           8                              
shared pool  ges enqueue multiple free         160                              
shared pool  ges lmd process descripto        2760                              
shared pool  ges lms process descripto        2760                              
shared pool  ges recovery domain table         176                              
shared pool  ges res mastership bucket        4096                              
shared pool  ges resource hash seq tab         128                              
shared pool  incr ckpt write count arr         168                              

POOL         NAME                       SUM(BYTES)                              
------------ -------------------------- ----------                              
shared pool  instance cnxn information        6048                              
shared pool  kea advisor definition ca         480                              
shared pool  kelr system metrics table         280                              
shared pool  kewr MMON Remote Flush Re       28672                              
shared pool  kgl lock hash table state       10640                              
shared pool  kglsim count of pinned he        8160                              
shared pool  kglsim size of pinned mem       16048                              
shared pool  kmgsb circular statistics      108800                              
shared pool  kolbsgi: KOLB's SGA initi           8                              
shared pool  kolfsgi: KOLF's SGA initi           8                              
shared pool  kpummst global in the SGA        1128                              

POOL         NAME                       SUM(BYTES)                              
------------ -------------------------- ----------                              
shared pool  ksb ci process list (each         704                              
shared pool  ksbtnfy: infrequent actio        1800                              
shared pool  ksfd shared pool recovery          24                              
shared pool  ksuloi: child latches for        1280                              
shared pool  ksuloi: garbage collectio          32                              
shared pool  ksuloi: long op free list         128                              
shared pool  ksuloi: long op statistic       86688                              
shared pool  ksuloi: long op used list         128                              
shared pool  ksunfy: is parent statist        3240                              
shared pool  ksunfy: nodes of hierarch         320                              
shared pool  ksunfy: system-global sta        3240                              

POOL         NAME                       SUM(BYTES)                              
------------ -------------------------- ----------                              
shared pool  kwqmncal: allocate buffer        4048                              
shared pool  latch nowait fails or sle      116832                              
shared pool  latch recovery structures         976                              
shared pool  log file size history arr         168                              
shared pool  max allowable # log files      337600                              
shared pool  media recovery state obje        8256                              
shared pool  message pool context area       11760                              
shared pool  object level stats hash t         512                              
shared pool  object queue hash buckets      525312                              
shared pool  object queue hash table d       15104                              
shared pool  object stat dummy statprv         144                              

POOL         NAME                       SUM(BYTES)                              
------------ -------------------------- ----------                              
shared pool  partitioned file hash buc       65536                              
shared pool  plwda:PLW_STR_NEW_LEN_VEC           8                              
shared pool  plwda:PLW_STR_NEW_VAL_VEC           8                              
shared pool  plwppwp:PLW_STR_NEW_LEN_V          16                              
shared pool  plwppwp:PLW_STR_NEW_VAL_V          32                              
shared pool  policy hash table descrpt         280                              
shared pool  process count for each CI         296                              
shared pool  ptr to sessions under idl          64                              
shared pool  qesmmaInitialize:                 112                              
shared pool  qesmmaInitialize: ia_qesm         264                              
shared pool  qesmmaInitialize: oa_qesm         112                              

POOL         NAME                       SUM(BYTES)                              
------------ -------------------------- ----------                              
shared pool  qesmmaInitialize: pa_qesm       11088                              
shared pool  qesmmaInitialize: ta_qesm         264                              
shared pool  qm_init_uga_helper: qmkm           16                              
shared pool  qmcInitSGA:qmsga_acl_prop          32                              
shared pool  qmuCreatePermSubHeap:subh         136                              
shared pool  redo allocation latch(es)        2400                              
shared pool  replication session stats       88704                              
shared pool  reserved entries for all         4096                              
shared pool  resize request state obje      368000                              
shared pool  rules engine aggregate st        1416                              
shared pool  simulator latch/bucket st       11264                              

POOL         NAME                       SUM(BYTES)                              
------------ -------------------------- ----------                              
shared pool  spfile callback table: ks         448                              
shared pool  sys event stats for Other      199136                              
shared pool  system default language h         568                              
shared pool  temp lob duration state o        3296                              
shared pool  trace buffer header array       35088                              
shared pool  writes stopped lock conte          24                              
shared pool  writes stopped lock state          24                              
shared pool                              398560680                              
                                         457280936                              

691 rows selected.

SQL> spool off;


Re: how we can match variable sga using v$sga and v$sgastat views [message #521857 is a reply to message #521852] Fri, 02 September 2011 07:47 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
The sums are about the same ones, so what is the problem?

By the way, don't you know "set trimout on trimspool on" command?
Aslo I didn't tell you to post 2000 lines, just the sums as you posted them in your first post.

Regards
Michel
Re: how we can match variable sga using v$sga and v$sgastat views [message #522010 is a reply to message #521857] Mon, 05 September 2011 07:45 Go to previous messageGo to next message
msol25
Messages: 396
Registered: June 2011
Senior Member
I am querrying v$sga and getting variable size : 211337216 bytes.when querrying
v$sgastat then getting

java Pool : 16777216
Large Pool : 41943040
Shared pool : 398560392

But as per my knowledge following condition should satisfy,but not getting


Code: [Select all] [Show/ hide] Variable sga = java pool + large pool + shared pool

select pool,name,sum(bytes)
from v$sgastat
where pool in ('shared pool','java pool','large pool')
group by pool,name;

Here variable size using v$sga : 211337216 bytes

and java pool + large pool + shared pool : 211302536 bytes.

but it should match?

please tell where 211337216 - 211302536 = 34680 bytes utilizing..?
Re: how we can match variable sga using v$sga and v$sgastat views [message #522013 is a reply to message #522010] Mon, 05 September 2011 08:14 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
but it should match?

No.
Why do you care about this?
Have you any problem?

Regards
Michel

[Updated on: Mon, 05 September 2011 08:15]

Report message to a moderator

Re: how we can match variable sga using v$sga and v$sgastat views [message #522321 is a reply to message #522013] Thu, 08 September 2011 07:28 Go to previous messageGo to next message
msol25
Messages: 396
Registered: June 2011
Senior Member
No Michel,

I have no problem but i m trying to find out which portion of SGA is consuming 33.86 bytes
Re: how we can match variable sga using v$sga and v$sgastat views [message #522324 is a reply to message #522321] Thu, 08 September 2011 08:05 Go to previous message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Different to compute, different things computed, different results.

Regards
Michel
Previous Topic: Stopping optimizer choosing concatenation
Next Topic: Performance issue
Goto Forum:
  


Current Time: Fri Nov 22 01:18:56 CST 2024