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

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 9i database index

Re: Oracle 9i database index

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Sat, 07 Jul 2007 12:09:38 +0200
Message-ID: <f6ntm3$uts$1@news4.zwoll1.ov.home.nl>


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

KL wrote:
> Are there anyway to tell/check if the database performance issue
> relates to an inefficient database index or not ?? We are running 9i.
> Many thanks. KL
>

:^
Yes, set the hidden parameter _USE_MAGIC_WAND to TRUE and also _GO_FASTER to TRUE.

You might set __DATA_CONSISTENCY to FALSE (double underscore!), but I'd be careful with that.

All this will only work after enabling the SILVER_BULLET option. /:^

Define "inefficient index"
- --
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)

iD8DBQFGj2ZiLw8L4IAs830RArruAJ97qEtbZa+zOwKTL4TQwADKIAQSMACeJF6c MtxQkxJ9uo33Pi6lObrpdz0=
=CjfN
-----END PGP SIGNATURE----- Received on Sat Jul 07 2007 - 05:09:38 CDT

Original text of this message

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