Home » RDBMS Server » Server Administration » explain db_block_reads and consistent reads
explain db_block_reads and consistent reads [message #56101] Thu, 06 March 2003 01:36
Subir
Messages: 13
Registered: November 2002
Junior Member
Hi,

If we set auto trace on and executing a query, then we get db_block_gets and consistent_reads along with other
outputs. can anyone explain the meaning of db_block_reads and consistent_reads.

Thanks in adv.

Regds,
Subir

Report message to a moderator

Previous Topic: Where can I get the HSOLESQL?
Next Topic: ORA-01092: ORACLE instance terminated. Disconnection forced
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 07:52:12 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.