Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Performance PROBLEM

Performance PROBLEM

From: Seema Singh <oracledbam_at_hotmail.com>
Date: Mon, 26 Apr 2004 15:28:23 -0400
Message-ID: <BAY10-F90qrfaAXRBwb0002d77c@hotmail.com>


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_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
Received on Mon Apr 26 2004 - 14:25:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US