Home » RDBMS Server » Server Administration » V$SGA size calculation
V$SGA size calculation [message #222568] Mon, 05 March 2007 07:52 Go to next message
gajini
Messages: 259
Registered: January 2006
Senior Member
Hi,

Find the output of the following query.

SQL> select * from v$sga;
NAME VALUE
-------------------- ----------
Fixed Size 744408
Variable Size 922746880
Database Buffers 2013265920
Redo Buffers 3420160

1. Could anyone explain me,what are the oracle memory components comes under "Fixed/Variable/Database Buffers/Redo Buffers" size calculation?

2. Does the sum of these 4 values give the total size of SGA?

Thanks...
Re: V$SGA size calculation [message #222573 is a reply to message #222568] Mon, 05 March 2007 08:06 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
Are you check to total for 4 components.
lets check

SQL> show sga

Total System Global Area 209715200 bytes
Fixed Size 788168 bytes
Variable Size 145488184 bytes
Database Buffers 62914560 bytes
Redo Buffers 524288 bytes

788168+145488184+62914560+524288=209715200

regards
Taj

[Updated on: Mon, 05 March 2007 08:07]

Report message to a moderator

Re: V$SGA size calculation [message #222580 is a reply to message #222568] Mon, 05 March 2007 09:15 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
To see what constitutes the variable size
http://www.orafaq.com/forum/m/218728/42800/?srch=Variable+Size#msg_218728
Previous Topic: Consistent gets clarification (merged)
Next Topic: MMON: "KEWRAFC: Flush slave failed, return Code: 5."
Goto Forum:
  


Current Time: Fri Dec 09 08:03:45 CST 2016

Total time taken to generate the page: 0.09387 seconds