Re: Performance OracleDB

[Frank Caruso]

** Check with your DBA and make sure STATISTICS are being generated. STATISTICS help the database figure out which table index to use. If the stats are out of date the database could choose the wrong index.
On that note, check the indexes on the tables you feel have slow performing queries. Are there indexes? Do they make sense? Can your queries be reformatted to include an available index?

On 11/9/06, Alex Salgado <[EMAIL PROTECTED]> wrote:

**

Hi List

 

I am having problems with my performance DB.

 

Does somebody have any advice or experience to improve the performance DB when Remedy execute queries ???

 

My environemnt is:

Oracle 9i R2 on Red Hat Linux Enterp. 3.

Remedy ARS 6.3

 

Does somebody know some parameters or something to I have to check ??

 

Thanks in advance !!

 

Alex

 

__20060125_______________________This posting was submitted with HTML in it___

--
Frank Caruso
Specific Integration, Inc.
Senior Remedy Engineer
www.specificintegration.com
703-376-1249 __20060125_______________________This posting was submitted with HTML in it___