Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 9i database index
-----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