v$sgastat

[PaulH]

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

[malay_biswal]

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

[PaulH]

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

[malay_biswal]

I think that should be buffer cache value.

[PAVB]

Log into sqlplus and do: show sga

You are gonna find your values represent: Fixed size, Database buffers and, Redo buffers.