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

Home -> Community -> Mailing Lists -> Oracle-L -> Skip_unusable_indexes in 10g

Skip_unusable_indexes in 10g

From: <gparc_at_free.fr>
Date: Mon, 17 Jul 2006 17:58:25 +0200
Message-ID: <1153151905.44bbb3a18e88d@imp7-g19.free.fr>

Hi listers,

FYI, skip_unusable_indexes is now a pfile/spfile parameter in 10g (not only alter session based as in 8i/9i) and defaults to ... TRUE.

I would prefer FALSE as a better default value.

HTH Regards

Gilles

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jul 17 2006 - 10:58:25 CDT

Original text of this message

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