| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Performance PROBLEM
Seema,
First, it could be index access causing your performance problem. It may be that a full table scan is more efficient. Second, caching tables may not be of great benefit. I/O is still I/O, memory is not all that much faster than disk.
Finally, 10046. Turn on 10046 level 8 tracing, run the query/queries, identify where it is spending time. Figure out how to reduce the time spent.
Check out www.hotsos.com, www.petefinnagin.com for info on 10046.
Daniel
Seema Singh wrote:
>
> 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
> -----------------------------------------------------------------
-- 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:41:59 CDT
 |
 |