Re: doubt about sga query

Hello Chiappa,

The log buffer consists internally of blocks. The log block size is platform dependent, but you can get a list of the common sizes in my web tip on "Why Raw Logfiles". For each block of the log buffer a header is needed in the variable area of the shared pool. The second entry in V$SGASTAT represents those headers. However, this will not be seen on all platforms, because what is shown in V$SGASTAT, and what gets bundled into 'miscellaneous' is quite variable.

Regards,
Steve Adams

http://www.ixora.com.au/
http://www.oreilly.com/catalog/orinternals/
http://www.christianity.net.au/

On Tue, 01 Aug 2000 17:36:49 -0700, jchiappa <jchiappaNOjcSPAM_at_bbvabrasil.com.br.invalid> wrote:

>give the following query :
>
> select name, bytes from v$sgastat where name in
>('db_block_buffers',
> 2* 'log_buffer','dictionary cache', 'sql area','library cache',
> 'free memory'
>)
>sys_at_prod::SQL>/
>
>
>NAME BYTES
>-------------------------- ----------
>free memory 193472
>db_block_buffers 90112000
>log_buffer 20971520
>log_buffer 327680
>dictionary cache 2400712
>library cache 52439088
>sql area 71420140
>
>
>Why 2 lines labelled log buffer ? Some hint/tip ?
>
>[]s
> Chiappa
>
>
>-----------------------------------------------------------
>
>Got questions? Get answers over the phone at Keen.com.
>Up to 100 minutes free!
>http://www.keen.com
>

Regards,
Steve Adams

http://www.ixora.com.au/
http://www.oreilly.com/catalog/orinternals/
http://www.christianity.net.au/