Home » RDBMS Server » Server Utilities » db block gets
db block gets [message #368353] Wed, 29 November 2000 12:13 Go to next message
Vernon Ching
Messages: 1
Registered: November 2000
Junior Member
With autotrace on i get stats on 'db block gets' and 'consistent gets'. What do these numbers mean ?

thank you
Re: db block gets [message #368392 is a reply to message #368353] Tue, 12 December 2000 16:23 Go to previous message
sriram
Messages: 58
Registered: September 2000
Member
db block gets - No of database buffers read from DBBC,
Consistent Gets - No of reads from Rollback Segs
Physical Reads - No of Disk Reads

u can calculate hit ratio from this
Previous Topic: bvcsrinu@usa.net
Next Topic: imp80
Goto Forum:
  


Current Time: Thu Mar 28 21:15:01 CDT 2024