db block gets [message #368353] |
Wed, 29 November 2000 12:13 |
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 |
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
|
|
|