Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Datafile write reasons from X$KCFIO
Hi !!
I am trying to figure out the write reasons for each datafile from X$tabs. X$KCFIO gives only the number of blocks, time for reads and writes. I am interested in finding the reasons for writes. I am trying to join X$KCFIO with X$KCBBES but no luck,,
The database is 8.1.5 on NT/ Solaris if that matters.
--
Best Regards,
K Gopalakrishnan,
Bangalore, INDIA.