Rich,
Was your sys schema accidentally analyzed? It may pay to drop stats on all
the sys objects using BOTH
(1) analyze
and (2) dbms_stats
HTH
Arup
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, February 19, 2003 11:03 AM
Hey all,
Thanks but there's no stats on those. As I said, the controlfile I/O is
what hits high, which would seem to indicate that v$datafile is the problem.
Thanks,
Rich
Rich JesseSystem/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA