If you were logged in you would be able to see more operations.
|
|
|
Product Version: |
10.1.0.2
|
Operating System: |
Generic
|
Error code:
ORA-4031 (may not be seen by end users).
Error code definition:
The CPU usage reaches 98% in KERNEL mode. strace utility on linux reports that the process spins on read() system call.
System calls:
An excerpt from strace -p <OSPID> output:
The file descriptor is 29(the first argument in read() system call). By linux lsof command, the descriptor#29 is 1081732 /oracle/product/10.1.0/bin/oracle. In other words, the process is reading Oracle executable.
strace -c -p <OSPID> output for 1 minute:
read() system call had been called 543,060 times per minute. That's why CPU utilization in KERNEL mode is high.
An excerpt from stack trace by OS debugger:
ksm_4031_dump() function of Oracle dumps ORA-4031 traces. The top of the stack includes read() system calls.
Problem interpretation:
The process gets ORA-4031 error, then tries to dump trace file for this error. But, while dumping the trace, it spins on read() system calls.
Workaround:
Set the following parameters in pfile/spfile:
Bug:
Ref: Oracle Note:3964602 DUMPING A CALL STACK TRACE IS SLOW.
|
Description
|
Error code:
ORA-4031 (may not be seen by end users).
Error code definition:
The CPU usage reaches 98% in KERNEL mode. strace utility on linux reports that the process spins on read() system call.
System calls:
An excerpt from strace -p <OSPID> output:
The file descriptor is 29(the first argument in read() system call). By linux lsof command, the descriptor#29 is 1081732 /oracle/product/10.1.0/bin/oracle. In other words, the process is reading Oracle executable.
strace -c -p <OSPID> output for 1 minute:
read() system call had been called 543,060 times per minute. That's why CPU utilization in KERNEL mode is high.
An excerpt from stack trace by OS debugger:
ksm_4031_dump() function of Oracle dumps ORA-4031 traces. The top of the stack includes read() system calls.
Problem interpretation:
The process gets ORA-4031 error, then tries to dump trace file for this error. But, while dumping the trace, it spins on read() system calls.
Workaround:
Set the following parameters in pfile/spfile:
Bug:
Ref: Oracle Note:3964602 DUMPING A CALL STACK TRACE IS SLOW. |
Show » |
There are no comments yet on this issue.
|
|