| Variable size memory [message #400162] |
Sun, 26 April 2009 15:09  |
shrinika
Messages: 306
Registered: April 2008
|
Senior Member |
|
|
Hello, Here is my oracle version..
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod
PL/SQL Release 10.1.0.2.0 - Production
CORE 10.1.0.2.0 Production
TNS for 32-bit Windows: Version 10.1.0.2.0 - Production
NLSRTL Version 10.1.0.2.0 - Production
My variable size memory should be exactly same as Java pool, large pool, shared pool.
scott@orcl> show sga
Total System Global Area 171966464 bytes
Fixed Size 787988 bytes
Variable Size 145488364 bytes
Database Buffers 25165824 bytes
Redo Buffers 524288 bytes
scott@orcl> select
2 sum(bytes)
3 from
4 v$sgastat
5 where
6 pool in ('shared pool', 'java pool', 'large pool');
SUM(BYTES)
----------
143369796
The stream pool size should be part of SGA. But it is not showing in v$sgastat view....
In oracle9i, variable size was matching with the above query. Now it is not matching..
Am i missing any thing in my above query? Any help is highly appreicated...
[Updated on: Sun, 26 April 2009 16:40] Report message to a moderator |
|
|
|
|
|
|
|
| Re: Variable size memory [message #400794 is a reply to message #400162] |
Wed, 29 April 2009 11:07  |
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
|
Senior Member |
|
|
| Quote: |
The stream pool size should be part of SGA. But it is not showing in v$sgastat view....
|
wondering why its not showing stream_pool_size in v$sgastat. If you dnt have stream_pool_size set , it will will occupy space within shared pool ,if you have any streams component running.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
