Can somebody explain the missing values in the query below that add
up to about 96M
$ grep pool spfilepbh1020.ora
SQL> select pool, bytes from v$sgastat;
shared pool 11704
shared pool 3704
shared pool 807488
shared pool 1928
large pool 8388608
java pool 33554432
And how did you calculate the missing values?
why don't u execute this query instead?
select pool,sum(bytes)/(1024*1024) from v$sgastat group by pool
I think your missing the point to my question, I want to know what "pool"
these numbers are associated with.
As you see I say select pool, bytes from v$sgastat; the first 3 numbers come
back without a "pool". I want to know if this is an indication if anything is wrong
I think that should be buffer cache value.
Log into sqlplus and do: show sga
You are gonna find your values represent: Fixed size, Database buffers and, Redo buffers.
Pablo (Paul) Berzukov
Author of Understanding Database Administration
available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Click Here to Expand Forum to Full Width