Forum Stats

  • 3,701,866 Users
  • 2,239,504 Discussions
  • 7,835,594 Comments

Discussions

Oracle High I/O

HabibHabib Posts: 253 Blue Ribbon

Hello

One a server of my client running Oracle 11g XE on Linux the load on the O/S goes very high. Sometimes over 100. Top doesn't show any process consuming much RAM or CPU.

Therefore I ran IOTop which shows Writes at 11 MB/s. I even saw 20 MB/s at one time.

However I am not able to find what's causing the high Writes.



I tried to find the details about the process from v$session, v$process, v$sql but most of the process show the sql:


SELECT COUNT(*) FROM VW_TCP_JOB WHERE ID=:B1


The above view has just 94 rows and runs in no time if the load on the database isn't high. However at the time when the load is high the above query keeps on running and doesn't show the result.

alert.log file is not showing anything unusual.

I have spent much time but couldn't find the reason. Therefore I request if someone can please help.


Regards,


Habib

Answers

  • User_UQSUXUser_UQSUX Posts: 2 Newbie

    hello, did you check reorg? There are several things to check.

    if that table running many DML query, i think must be HWM high..

    or,

    You need to check if the LOCK was caused by another query.

    you have just xe version, so you can make lock cechk procedure and register oracle job.

    Not enough, but I hope it helps.

Sign In or Register to comment.