Search for Metalink note 1008866.6, it explains what init.ora parameters
affect the individual SGA areas.
"Dash, Saroj (CAP,CEF)" wrote:
>
> This is show sga of a instance.
>
> Question is :
> 1. I declared shared _pool_ size in init.ora 9MB.
>
> db_block_buffer =550
> block_size=4096
> log_buffer=32768
> all are defined in init.ora file.
>
> Please tell me how come Total system global area is 13028012 bytes.
>
> Where fixed value,database buffers and redo buffers values comes.
>
> Please explain me.
>
> Total system global area 13028012 bytes
> Fixed Size 47788 bytes
> Variable Size 10653696 bytes
> Database Buffers 2252800 bytes
> Redo Buffers 73728 bytes
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Dash, Saroj (CAP,CEF)
> INET: Saroj.Dash_at_gecapital.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Mon Nov 20 2000 - 11:37:08 CST
