Home » RDBMS Server » Server Administration » Variable size memory (oracle10g)
Variable size memory [message #400162] Sun, 26 April 2009 15:09 Go to next message
shrinika
Messages: 266
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 #400163 is a reply to message #400162] Sun, 26 April 2009 16:57 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Depends on your configuration.
Variable size is "all the rest" that are not specifically said.
Since you are in 10g, you may want to consider streams_pool_size

[Updated on: Sun, 26 April 2009 16:58]

Report message to a moderator

Re: Variable size memory [message #400357 is a reply to message #400163] Mon, 27 April 2009 15:52 Go to previous messageGo to next message
shrinika
Messages: 266
Registered: April 2008
Senior Member
Thanks Mahesh....
Re: Variable size memory [message #400794 is a reply to message #400162] Wed, 29 April 2009 11:07 Go to previous message
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.
Previous Topic: To increase the Shared_Pool Size
Next Topic: Transaction Hange
Goto Forum:
  


Current Time: Thu Dec 08 20:10:47 CST 2016

Total time taken to generate the page: 0.16404 seconds