shared pool size

pga_aggregate_target               big integer 0
shared_pool_size                   big integer 0
sga_max_size                       big integer 10G
sga_target                         big integer 10G
memory_target                      big integer 0

Querying pgastat:

total PGA inuse                                                   513274880
bytes
total PGA allocated                                              1209803776
bytes
maximum PGA allocated                                            2128826368

the db uses manual work areas. querying sgainfo:

NAME                                  BYTES RES


-------------------------------- ---------- ---

Fixed SGA Size                      2216200 No
Redo Buffers                       16945152 No
Buffer Cache Size                3992977408 Yes
Shared Pool Size                 6576668672 Yes

1. what does shared_pool_size of 0 in this env mean? how did oracle get to current value when shared pool size is set to 0. 2) Does the view pgastat provide the right value while using manual work areas. In this case does it mean that 696528896b (total PGA allocated-total PGA inuse) of PGA is not in use? Does allocated here mean something similar to temp files where allocated does not necessarily mean being used actively?

I tried searching online but it is confusing.

Orlando.

--

http://www.freelists.org/webpage/oracle-l Received on Wed Mar 18 2015 - 01:04:10 CET