| V$SGA size calculation [message #222568] |
Mon, 05 March 2007 07:52  |
gajini
Messages: 262
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  |
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 |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
