RE: Perf. problem

From: David Sharples <dsharples_at_cerebrussolutions.com>
Date: Fri, 4 Jun 2004 11:45:51 +0100
Message-ID: <EA29A3FCC723674293FD6286D3F0513E77BE99@louis.cerebrus.com>

Statspack

Trace the query as well, find out what it is doing

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Computer Centre - NIIPL
Sent: 04 June 2004 10:51
To: ORALCE LIST
Subject: Perf. problem

Dear All,

Every month we are running one process related to our Material Management
Systems. Approximately, it will take two to four hours to complete. But this
month we are not able to run the process even after 9 hrs.

What could be the problem?

How to go about it?

Thanks in Advance,
Balu.
This mail is scaned by eScan Anti Virus Software

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Fri Jun 04 2004 - 05:52:21 CDT