- What did you want to achieve by switching to direct I/O?
- Do you know what is direct I/O and what are the benefits?
- Are you talking about DBMS_STATS?
- Why would you expect DBMS_STATS to run faster with the direct I/O?
I'd expect it to run slower, because of the the prefetch which is
gone with the direct I/O.
--
Mladen Gogala
A & E TV Network
Ext. 1216
> -----Original Message-----
> From: Roger Xu [mailto:roger_xu_at_dp7uptx.com]
> Sent: Tuesday, October 19, 2004 3:16 PM
> To: Oracle-L_at_Freelists. Org (E-mail)
> Subject: Direct I/O, better performance?
>
>
> Hi,
>
> We are running Solaris 9 with UFS on Oracle 9.2.0.4.0.
> We switched to direct I/O and did not see a better
> performance as far as updating statistics concerned. Why?
>
> It used to take us 22 hours to update statistics for all
> tables, but now 31 hours.
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Oct 19 2004 - 16:05:31 CDT
