RE: Perforamance problem on an Application running on top of Oracle 9
- From: patrick obrien <po04541@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx, RichardGoulet <Richard.Goulet@xxxxxxxxxxx>
- Date: Wed, 24 Nov 2010 08:32:02 -0800 (PST)
Richard,
The O/S is Windows 2003
I loaded up statspack and the report only suggested I increase my
pga_aggregate_target.
Nothing else stood out and admittedly, I'm not educated enough to read this
report and determine where there might be a problem. I have to google for more
help on reading a stats pack report.
--- On Wed, 11/24/10, Goulet, Richard <Richard.Goulet@xxxxxxxxxxx> wrote:
From: Goulet, Richard <Richard.Goulet@xxxxxxxxxxx>
Subject: RE: Perforamance problem on an Application running on top of Oracle 9
To: po04541@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
Date: Wednesday, November 24, 2010, 7:40 AM
First question as always, operating system and
version???
Dick
Goulet
Senior Oracle DBA
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of patrick
obrien
Sent: Tuesday, November 23, 2010 11:55 AM
To:
oracle-l@xxxxxxxxxxxxx
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*
Other related posts:
