Home » RDBMS Server » Performance Tuning » SQL*Net message from client - Event
SQL*Net message from client - Event [message #231441] Tue, 17 April 2007 02:11 Go to next message
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 messageGo to next message
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 #231448 is a reply to message #231443] Tue, 17 April 2007 02:21 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Oracle is waiting for your application to send it something (work, data...). For instance, when a client is taking a coffee.

Regards
Michel
Re: SQL*Net message from client - Event [message #231458 is a reply to message #231441] Tue, 17 April 2007 03:07 Go to previous messageGo to next message
Brayan
Messages: 315
Registered: June 2002
Senior Member
Hi Michel,

That is what I want to debug Embarassed ,

Actually Application runtime is 50 mins, in that around 30 mins is wait time. That is the reason I want to debug why that much wait time is taking.

Regards
Re: SQL*Net message from client - Event [message #231462 is a reply to message #231458] Tue, 17 April 2007 03:13 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Don't ask Oracle.
Ask application, network (but I doubt as "to client" SQL*Net events are low unless you have an asymetric configuration).
Oracle is just waiting to be fed.

Regards
Michel
Re: SQL*Net message from client - Event [message #231622 is a reply to message #231441] Tue, 17 April 2007 14:12 Go to previous messageGo to next message
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
Senior Member
Heh, I saw your post on asktom...
Re: SQL*Net message from client - Event [message #231656 is a reply to message #231622] Tue, 17 April 2007 23:09 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And you saw he told you the same thing. Wink

Regards
Michel
Re: SQL*Net message from client - Event [message #231665 is a reply to message #231441] Wed, 18 April 2007 00:21 Go to previous messageGo to next message
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
Michel Cadot
Messages: 64103
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
Previous Topic: SQL Tuning
Next Topic: if the data is already available in cache,will index be used if we query again?
Goto Forum:
  


Current Time: Sat Dec 03 16:02:28 CST 2016

Total time taken to generate the page: 0.05798 seconds