RE: Perforamance problem on an Application running on top of Oracle 9

From: Goulet, Richard <Richard.Goulet_at_parexel.com>
Date: Wed, 24 Nov 2010 10:40:03 -0500
Message-ID: <6B0D50B70F12BD41B5A67F14F5AA887F0C271849_at_us-bos-mx022.na.pxl.int>

First question as always, operating system and version???

Dick Goulet
Senior Oracle DBA

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of patrick obrien Sent: Tuesday, November 23, 2010 11:55 AM To: oracle-l_at_freelists.org
Subject: Perforamance problem on an Application running on top of Oracle 9

Good Day DBA's,

Our shop owns a check printing application running on top of Oracle 9.2.0.1.0.

This application is very slow during one particular process.

While this process is running so slow, what view/table can I look at to see what table this process is using?

And, any other thoughts on how I can troubleshoot an oracle 92010 database with performance problems.

thank you very much,
Patrick O*

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Nov 24 2010 - 09:40:03 CST

This message: [ Message body ]
Next message: Amaral, Rui: "RE: Laptop for Lots of VMs"
Previous message: Michael McMullen: "RE: Oracle 10g Client for Linux"
In reply to: patrick obrien: "Perforamance problem on an Application running on top of Oracle 9"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message