-
v$sgastat
Can somebody explain the missing values in the query below that add
up to about 96M
FYI
$ grep pool spfilepbh1020.ora
*.java_pool_size=31457280
*.large_pool_size=8388608
*.shared_pool_size=153431142
SQL> select pool, bytes from v$sgastat;
POOL BYTES
------------ ----------
1978176
92274688
6406144
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|