Hi,
Thanks for the replies to this question. Looks like I need = 8i or trawl
through the v$sqlarea either by spending money or writing a simple bit of
pl/sql.
Thanks,
Steve Wilkes
npower
[EMAIL PROTECTED]
-Original Message-
Sent: 29 May 2001 14:03
To: Multiple recipients of list
Steve,
If you are going to pull code from v$sqlarea, you will also want
to use v$sqltext.
In that case, look up the paper at www.hotsos.com about joining
v$sqltext and v$sqlarea, as the hash_value is defined as a
different data type in each. This affects all releases prior to
8.0.5.
Also,
There is also one called The Big Picture - from Bit by Bit
www.bitbybit.co.uk - that scans all source, and SQL, and stores all
execution plans in a BDE database. It then scans through all the exectution
plans to determine whether an index is used or not.
It doesn't however tell you how many
Hi All,
A cheaper solution to this is to use an AFTER LOGON trigger to set
CREATE_STORED_OUTLINES to true. If the users have the CREATE ANY OUTLINE system
privilege, you'll be able to see which indexes are being used in the
DBA_OUTLINE_HINTS view.
@ Regards,
@ Steve Adams
@
That is clever Steve.
I'm gonna go play now. :)
Jared
On Tuesday 29 May 2001 07:00, Steve Adams wrote:
Hi All,
A cheaper solution to this is to use an AFTER LOGON trigger to set
CREATE_STORED_OUTLINES to true. If the users have the CREATE ANY OUTLINE
system privilege, you'll be able to
There is commercial software for determining this.
www.teleran.com
www.pinecone.com
Both rather spendy.
Jared
On Thursday 24 May 2001 06:10, Wilkes, Steve wrote:
Hi,
Does anyone know how to determine how many times an index has been used or
if it has been used at all? I have seen
