Database Tuning (MOSC)

MOSC Banner

Very high WRITETIM

edited Dec 12, 2011 8:50AM in Database Tuning (MOSC) 2 comments
We had restarted our 10204 database yesterday after moving the data files to different mount point. This was done to fix the slow I/O. The user complained again that the inserts are slow. When I did some analysis I found this.

uname -av
SunOS bupscubdb2 5.10 Generic_127128-11 i86pc i386 i86pc

SQL> select * from v$filestat2 where file# in (39,43,30,15,50,24) order by file#;FILE# PHYRDS PHYWRTS PHYBLKRD PHYBLKWRT SINGLEBLKRDS READTIM WRITETIM SINGLEBLKRDTIM AVGIOTIM LSTIOTIM MINIOTIM MAXIORTM MAXIOWTM---------- ---------- ---------- ---------- ---------- ------------ ---------- ---------- -------------- ---------- ---------- ---------- ---------- ----------15 21580 1553 77743 1589 16742 27947 593 12195 0 1 0 497 6324 44410 103670 44477 501890 44324 18453 1542479800 4679 0 0 0 535 154245303930 21647 2722 79057 2798 16727 33915 1677 12506 0 1 0 701 6639 22533 1547 76258 1571 17106 29447 1016 13027 0 0 0 513 6343 17567 1442 70821 1480 12267 28832 1181 9876 0 0 0 513 6650 22960 1569 75815 1604 17396 25566 1208 12036 0 4 0 665 636 rows selected.SQL> select max(WRITETIM) from v$filestat;MAX(WRITETIM)-------------1542479821SQL> select file#,WRITETIM from (select WRITETIM, file# from v$filestat order by WRITETIM desc ) where rownum < 10;FILE# WRITETIM---------- ----------24

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center