Path: text.usenetserver.com!out02a.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!postnews.google.com!news4.google.com!feeder1-2.proxad.net!proxad.net!feeder1-1.proxad.net!feeder.news-service.com!news2.euro.net!multikabel.net!feed20.multikabel.net!newshub2.home.nl!newshub1.home.nl!home.nl!not-for-mail From: Frank van Bortel Newsgroups: comp.databases.oracle.server Subject: Re: Oracle 9i database index Date: Sat, 07 Jul 2007 12:09:38 +0200 Organization: @Home Benelux Lines: 32 Message-ID: References: <1183802120.791711.176830@e16g2000pri.googlegroups.com> Reply-To: frank.van.bortel@gmail.com NNTP-Posting-Host: cc28855-a.hnglo1.ov.home.nl Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Trace: news4.zwoll1.ov.home.nl 1183808003 31676 82.75.117.80 (7 Jul 2007 11:33:23 GMT) X-Complaints-To: usenet@corp.home.nl NNTP-Posting-Date: Sat, 7 Jul 2007 11:33:23 +0000 (UTC) User-Agent: Thunderbird 1.5 (Windows/20051201) In-Reply-To: <1183802120.791711.176830@e16g2000pri.googlegroups.com> X-Enigmail-Version: 0.94.1.2 Xref: usenetserver.com comp.databases.oracle.server:430723 X-Received-Date: Sat, 07 Jul 2007 06:09:37 EDT (text.usenetserver.com) -----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-----