Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> doubt about sga query
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