Xref: alice comp.databases.oracle.server:39621
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!newsfeed.cwix.com!206.63.63.70!nwnews.wa.com!brokaw.wa.com!not-for-mail
From: Dan Morgan <dmorgan@exesolutions.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: Q: Indexes
Date: Tue, 02 Feb 1999 15:48:17 -0800
Organization: EXE
Lines: 8
Message-ID: <36B78EC1.A31F0704@exesolutions.com>
References: <78ilij$dcj4@news-sol.swissonline.ch>
Reply-To: dmorgan@exesolutions.com
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Mailer: Mozilla 4.5 [en] (WinNT; I)
X-Accept-Language: en
To: JFG <jfguyard@swissonline.ch>

> Having no special experience with Oracle 8 on Windows NT, is there any
> particular possibility to check which indexes a transaction is using?

Use Explain Plan. You will find it documented in your manual. Your DBA
will have to set it up for you by running a SQL script as SYS.

Daniel A. Morgan