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

Home -> Community -> Mailing Lists -> Oracle-L -> Table Replicated,index not used-BitOld

Table Replicated,index not used-BitOld

From: GovindanK <gkatteri_at_fastmail.fm>
Date: Wed, 7 Sep 2005 19:19:12 UT
Message-Id: <1126120752.7883.242387885@webmail.messagingengine.com>

Hello Team

I need your help on this. We were on 9.2.0.1 on solaris and had two instances running on two separate machines; One was production (PRD) and the other for administration/accounting related (SHD). We have table replicated from PRD to SHD; The number of distinct keys in both were the same and so is the number of rows ; The query on prd returns results in few seconds while on the shd instance it took long time without any hints ; with hint it processes faster. The clustering factor was high

[1]http://www.geocities.com/dba_assist/oracle-l/prd.html

[2]http://www.geocities.com/dba_assist/oracle-l/shd.html

First i rebuilt the index ; There was no improvement in the statistics. Dropped , Recreated, Analyzed .. No improvement. We later migrated to 9.2.0.6 and now both the instances are taking same(=more) time and doing FTS. If the optimizer could use the index on the first occassion in PRD+9201 why it does not do it now?

Any suggestions would be appreciated.

TIA GovindanK

References

  1. http://www.geocities.com/dba_assist/oracle-l/prd.html
  2. http://www.geocities.com/dba_assist/oracle-l/shd.html
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Sep 07 2005 - 14:21:14 CDT

Original text of this message

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