-
SGA Size
SQL> sho sga
Total System Global Area 135338868 bytes
Fixed Size 453492 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
SQL>
What is this Fixed Size and What is Variable Size...?
-
fixed size is like a bootstrap area
variable size = sum(bytes) v$sgastat
-
Fixed Size and Variable Size, are they part of Shared Pool Size.. Or in other way what parameter in INIT.ORA makes up Fixed Size and Variable Size.
-
variable is made up from shared pool size and the other parameters listed in v$sgastat
fixed is well, fixed
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|