Re: Performance PROBLEM
- From: "Juan Cachito Reyes Pacheco" <jreyes@xxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 26 Apr 2004 16:10:40 -0400
Hi Seema
I have a paper
http://www.geocities.com/juancarlosreyesp/101basictunningonOracle9i.pdf
Where I added the process to generate a statpacks reports
and actually adding the basics about how to analyze it.
Download it and check it,
once you generate it send it to www.oraperf.com they will give you the first
opinion, and
you can send me maybe I can find something.
if you have any problems you can emailme directly
:)
Juan Carlos Reyes Pacheco
OCP
Database 9.2 Standard Edition
----- Original Message -----
From: "Seema Singh" <oracledbam@xxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Monday, April 26, 2004 3:28 PM
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:
