RE: Perf. problem

  • From: "David Sharples" <dsharples@xxxxxxxxxxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 4 Jun 2004 11:45:51 +0100

Statspack

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

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: