RE: Performance PROBLEM
- From: DENNIS WILLIAMS <DWILLIAMS@xxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 26 Apr 2004 14:34:26 -0500
Seema
I think you first need to establish why the application is running slow.
Only after you understand why the application is slow can you map a strategy
for improving the performance. You could run a 10046 trace as described in
Cary Millsap's book. You could examine the v$ tables. You could run a
STATSPACK report. Have you ever done any of these methods?
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams@xxxxxxxxxxxxx
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Seema Singh
Sent: Monday, April 26, 2004 2:28 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Performance PROBLEM
Hi,
We are experiencing performance issues with one Sun database box.
Oracle version=8.1.7.0 ,Memory=1.5gb SGA size=270mb,
Database size 5MB.
One of application is looking slow.This is third party application.We don't
authorised to tune their query.Only We can do create indexes,cahe couple of
tables,pin procedure etc.
Can someone please suggest what can do other create indexes,cahe couple of
tables,pin procedure in that schema.Any suggestions are welcome.
Thanks
-Seema
_________________________________________________________________
FREE pop-up blocking with the new MSN Toolbar - get it now!
http://toolbar.msn.com/go/onm00200415ave/direct/01/
----------------------------------------------------------------
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:
