RE: CBO irregularity

  • From: "Naveen, Nahata (IE10)" <Naveen.Nahata@xxxxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 7 Jun 2004 23:39:02 -0700 

Thanx Cary and Satheesh,
 
Why wud the no. of blocks read be less than DB_FILE_MULTBLOCK_READ_COUNT?
 
Is it dependent on the I/O sub-system?
 
Regards
Naveen

 

True. The Oracle kernel also collects this information when you use
dbms_stats.gather_database_stats.

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 06-2004