Re: doubt about sga query

From: Yong <yhuang_at_indigopool.com>
Date: 2000/08/02
Message-ID: <8m9uei$mq3$1@news.sinet.slb.com>#1/1

jchiappa,

Your query is misleading. Why not select * from v$sgastat? Then you know the first log_buffer is the real log buffer size of your instance. The second is simply the shared pool memory allocated to the handle to the log_buffer in SGA. You may also wonder why there's an entry for db_block_buffers in shared pool. Same thing. That's the memory for the handles to all db_block_buffers.

Please correct me if my understanding is wrong.

Yong Huang

jchiappa <jchiappaNOjcSPAM_at_bbvabrasil.com.br.invalid> wrote in message news:074cc050.80bebca1_at_usw-ex0101-005.remarq.com...
> 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
>
Received on Wed Aug 02 2000 - 00:00:00 CDT