To echo everyone, running statistics should help. The default 9i optimizer mode is CHOOSE, which means use the old Rule Based Optimizer if statistics do not exist for involved tables/indexes, and use the newer Cost Based Optimizer if the statistics _do_ exist. See: http://www.oracle-base.com/articles/8i/CostBasedOptimizerAndDatabaseStat istics.php
________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Alex Salgado Sent: Wednesday, November 08, 2006 10:12 PM To: [email protected] Subject: Performance OracleDB ** 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___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
