Satheesh,
Thanks for the help. I am facing performance problem. This is a MIS
database and mostly there is no manual intervention. The loading of the data
is done using Cognos Decision Stream.
Thanks
Ravi Boppudi
-----Original Message-----
From: Satheesh
[mailto:oracledba-ezmlmshield-x44506793.[Email address protected]
Sent: 16 July 2004 11:36
To: LazyDBA Discussion
Subject: RE: Wait events
These are ideal event. Are you facing performance issue? If not then your
safe. If you face any you might have to look into your network and also code
if it putting lot of load on network. But your top event is ".. from client"
that is server is especting users input. Even if the user open a screen and
not doing anything the time for this even will get increased.
Thanks and Regards,
Satheesh Babu.S
Bangalore.
-----Original Message-----
From: Boppudi Ravi [mailto:oracledba-ezmlmshield-x77022188.[Email address
protected]
Sent: Friday, July 16, 2004 3:33 PM
To: LazyDBA Discussion
Subject: Wait events
Hello Gurus,
Event Total Waits
Timeouts Time Waited Time Waited in Hrs
SQL*Net message from client 34294395 0
46621313 129.5
SQL*Net message to client 34294378 0
6998 0.0
SQL*Net more data to client 7000469 0
60597 0.2
rdbms ipc message 3584851 2789030
103983809
288.8
These are my wait events. I feel the the network between my application
server and Database is very slow. Is this the case ? Or am I interpreting
wrongly ?
What is rdbms ipc message ?
Can anyone pl share their understanding of above numbers? Thanks Ravi
Boppudi.
************************************************************************
**********
This email and any files transmitted with it are confidential, and may be
subject to legal privilege, and are intended solely for the use of the
individual or entity to whom they are addressed.
If you have received this email in error or think you may have done so, you
may not peruse, use, disseminate, distribute or copy this message. Please
notify the sender immediately and delete the original e-mail from your
system.
Computer viruses can be transmitted by e-mail. Recipients should check this
e-mail for the presence of viruses. The Capita Group and its subsidiaries
accept no liability for any damage caused by any virus transmitted by this
e-mail.
************************************************************************
***********
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
This email has been scanned for all viruses by the MessageLabs SkyScan
service.
Oracle LazyDBA home page