RE: Performance PROBLEM
- From: "Justin Cave (DDBC)" <jcave@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 26 Apr 2004 13:47:44 -0600
Is the database size really 5 Mb?? Meaning that the SGA is 50 times
larger than the database? I'm going to assume that you meant 5 Gb, at
least.
Is it possible that the application is locking some rows? That could
easily cause a slowdown. =20
If you trace a session that is having problems, you can see whether the
problems are related to a full table scan that could be rectified by
adding an index. I would be surprised if caching tables or pinning
procedures were the solution here, given such a large SGA and such a
small database (5 Gb).
Justin Cave
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Seema Singh
Sent: Monday, April 26, 2004 1:28 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Performance PROBLEM
Hi,
We are experiencing performance issues with one Sun database box.
Oracle version=3D8.1.7.0 ,Memory=3D1.5gb SGA size=3D270mb, 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!=20
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:
