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
Messages: 261
Registered: January 2006
Senior Member

Find the output of the following query.

SQL> select * from v$sga;
-------------------- ----------
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?

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

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



[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: 10673
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
To see what constitutes the variable size
Previous Topic: Consistent gets clarification (merged)
Next Topic: MMON: "KEWRAFC: Flush slave failed, return Code: 5."
Goto Forum:

Current Time: Fri Jul 21 20:13:16 CDT 2017

Total time taken to generate the page: 0.14562 seconds