Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> doubt about sga query

doubt about sga query

From: jchiappa <jchiappaNOjcSPAM_at_bbvabrasil.com.br.invalid>
Date: 2000/08/01
Message-ID: <074cc050.80bebca1@usw-ex0101-005.remarq.com>#1/1

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 Tue Aug 01 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US