SQL*Net message from client - Event [message #231441] |
Tue, 17 April 2007 02:11 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Brayan
Messages: 315 Registered: June 2002
|
Senior Member |
|
|
Hi,
In my trace file there is a large wait event.
I need to findout what is this wait event. Can anybody help me to find what is this event.
Background:
We run certain job from application. Once the job is issued, no more the application from client side is required(We can shut the application also).
OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 131833 84.85 82.83 4 1886 0 0
Execute 221963 41.12 68.20 1790 187883 145386 75689
Fetch 153811 53.91 94.48 159204 1205403 0 1162237
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 507607 179.88 245.52 160998 1395172 145386 1237926
Misses in library cache during parse: 122235
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
SQL*Net message from client 703579 59.83 1919.68
SQL*Net message to client 703578 0.00 0.35
SQL*Net more data to client 349684 0.00 7.71
db file sequential read 158923 0.14 50.84
log file sync 63923 0.18 95.93
SQL*Net more data from client 11652 0.06 534.86
latch free 40 0.00 0.02
buffer busy waits 11 0.00 0.00
undo segment extension 43 0.00 0.00
db file scattered read 81 0.02 0.11
|
|
|
Re: SQL*Net message from client - Event [message #231443 is a reply to message #231441] |
Tue, 17 April 2007 02:14 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Brayan
Messages: 315 Registered: June 2002
|
Senior Member |
|
|
Hi,
Sorry for incomplete message,
I need to find what exactly is the fllowing wait event.
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
SQL*Net message from client 703579 59.83 1919.68
Regards,
Ronald.
|
|
|
|
|
|
|
|
Re: SQL*Net message from client - Event [message #231665 is a reply to message #231441] |
Wed, 18 April 2007 00:21 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Brayan
Messages: 315 Registered: June 2002
|
Senior Member |
|
|
Hi Michel,
Yes, I was looking at different opinions to isolate my problem.
I dont have much control over application, its a standard application from Oracle. I have already logged a case with metalink and they are investigating the same.
I have 2gbps connection from server to storage. 100mbps from client to server(This connection is not required once the job is issued from the client). The application node and the DB node is sitting in the Same Box(different OS users).
I can see that only CPU load goes upto 100% and Disk IO is neglegible.
Also, the Statspack shows no major issues. In 10046 event trace shows 2/3 of the time goes as wait event.
Your suggestions may help me to investigate the issue.
Regards,
Brayan.
|
|
|
Re: SQL*Net message from client - Event [message #231681 is a reply to message #231665] |
Wed, 18 April 2007 02:00 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68678 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
You have 100%CPU consumption, who is working? who consume this CPU?
And as I previously said, investigate the application: why Oracle is waiting for it to send work?
Regards
Michel
|
|
|