- 3,701,866 Users
- 2,239,504 Discussions
- 7,835,594 Comments
- 64 Community Feedback - NEW! (No Product Questions)
- 31 General Community Platform Concerns/Kudos/Feedback
- 32 Community Platform Bug Reports
- 41 How Do I? (Community Platform "How to" Questions)
- 10 Where is the...? (Community Platform Locations)
- 8 I'd Like to See... (Community Platform Ideas & Suggestions)
- 11.2K Community Feedback (No Product Questions) Archive
- 63 Personal Document & Blog Archive
- 2 Community Programs
- 2 Get-Togethers
- 46 Certification Community
- 4.7K Certification Community Discussions
- 31 Oracle Certified Master Profiles
- 25 Oracle Database 12c Administrator Certified Master Profiles
- 24 Visual Builder Cloud Service
Oracle High I/O
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.