Oracle-L: Re: ** find whether table or index being accessed

From: Prem Khanna J <jprem_at_kssnet.co.jp>
Date: Tue, 18 Nov 2003 18:24:58 -0800
Message-ID: <F001.005D715B.20031118182458@fatcity.com>

--------------Boundary-00=_4PUK6RO0000000000000 Content-Type: Multipart/Alternative;
boundary="------------Boundary-00=_4PUK12S0000000000000"

--------------Boundary-00=_4PUK12S0000000000000 Content-Type: Text/Plain;
charset="shift_jis"
Content-Transfer-Encoding: quoted-printable

Joshi,=0D
=0D
i have got a script from metalink for monitoring indexes .=0D it works for 8.1.x too . =0D
just try the script that i have mailed to ur personal email address. =0D =0D
Regards,=0D
Jp.=0D
=0D

> A Joshi <ajoshi977_at_yahoo.com> wrote:=0D
>=0D
> Hi, Is there an easy way to find out if a table or an index is=0D
> being used. I mean short of going thru all code or keeping looking at=0D
> v$sqlarea. I mean even if code is covered there are always ad hoc SQL

queries=0D
> etc. Same for other objects like views etc. Is there a place where orac= le=0D
> stores objects accessed and any other related info. Thanks --------------Boundary-00=_4PUK12S0000000000000 Content-Type: Text/HTML;
charset="shift_jis"
Content-Transfer-Encoding: quoted-printable

<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Dshift_jis=
">
<META content=3D"IncrediMail 1.0" name=3DGENERATOR>

</HEAD>
<BODY style=3D"BACKGROUND-POSITION: 0px 0px; FONT-SIZE: 12pt; MARGIN: 5px=
10px 10px; FONT-FAMILY: Arial" bgColor=3D#ffffff background=3D"" scroll=3D= yes ORGYPOS=3D"0" X-FVER=3D"3.0">
<TABLE id=3DINCREDIMAINTABLE cellSpacing=3D0 cellPadding=3D2 width=3D"100=
%" border=3D0>
<TBODY>
<TR>
<TD id=3DINCREDITEXTREGION style=3D"FONT-SIZE: 12pt; CURSOR: auto; FONT-F=
AMILY: Arial" width=3D"100%">
<DIV>
<DIV>Joshi,</DIV>
<DIV> </DIV>
<DIV>i have got a script from metalink for monitoring indexes .</DIV>
<DIV>it works for 8.1.x too . </DIV>
<DIV>just try the script that i have mailed to ur personal email add=
ress. </DIV>
<DIV> </DIV>
<DIV>Regards,</DIV>
<DIV>Jp.</DIV>
<DIV> </DIV>
<DIV>> A Joshi <<A href=3D"mailto:ajoshi977_at_yahoo.com">ajoshi977_at_ya=
hoo.com</A>> wrote:</DIV></DIV>
<DIV>></DIV>
<DIV>> Hi, Is there an easy way to find out if a table or an index is<=
/DIV>
<DIV>> being used. I mean short of going thru all code or keeping look=
ing at</DIV>
<DIV>> v$sqlarea. I mean even if code is covered there are always ad h=
oc SQL queries</DIV>
<DIV>> etc. Same for other objects like views etc. Is there a place wh=
ere oracle</DIV>
<DIV>> stores objects accessed and any other related info. Thanks</DIV=
>
<DIV> </DIV></TD></TR>
<TR>
<TD id=3DINCREDIFOOTER width=3D"100%">
<TABLE cellSpacing=3D0 cellPadding=3D0 width=3D"100%">
<TBODY>
<TR>
<TD width=3D"100%"></TD>
<TD id=3DINCREDISOUND vAlign=3Dbottom align=3Dmiddle></TD>
<TD id=3DINCREDIANIM vAlign=3Dbottom align=3Dmiddle></TD></TR></TBODY></T=

ABLE></TD></TR></TBODY></TABLE><SPAN id=3DIncrediStamp><SPAN dir=3Dltr><F=
ONT face=3D"Arial, Helvetica, sans-serif" size=3D2>______________________=
______________________________<BR><FONT face=3D"Comic Sans MS" size=3D2><=
A href=3D"http://www.incredimail.com/redir.asp?ad_id=3D309&amp;lang=3D9">=


<IMG alt=3D"" hspace=3D0 src=3D"cid:2CDEA47B-8D43-4829-B29E-06BA78567C64"=

 align=3Dbaseline border=3D0></A>&nbsp; <I>IncrediMail</I> - <B>Email has=
 finally evolved</B> - </FONT><A href=3D"http://www.incredimail.com/redir=
=2Easp?ad_id=3D309&amp;lang=3D9"><FONT face=3D"Times New Roman" size=3D3>=

<B><U>Click Here</U></B></FONT></A></SPAN></SPAN></FONT></BODY></HTML>
--------------Boundary-00=_4PUK12S0000000000000--

--------------Boundary-00=_4PUK6RO0000000000000 Content-Type: image/gif;
name="IMSTP.gif"
Content-Transfer-Encoding: base64
Content-ID: <2CDEA47B-8D43-4829-B29E-06BA78567C64>

R0lGODlhFAAPALMIAP9gAM9gAM8vAM9gL/+QL5AvAGAvAP9gL////wAAAAAAAAAAAAAAAAAAAAAA

AAAAACH/C05FVFNDQVBFMi4wAwEAAAAh+QQJFAAIACwAAAAAFAAPAAAEVRDJSaudJuudrxlEKI6B URlCUYyjKpgYAKSgOBSCDEuGDKgrAtC3Q/R+hkPJEDgYCjpKr5A8WK9OaPFZwHoPqm3366VKyeRt E30tVVRscMHDqV/u+AgAIfkEBWQACAAsAAAAABQADwAABBIQyUmrvTjrzbv/YCiOZGmeaAQAIfkE CRQACAAsAgABABAADQAABEoQIUOrpXIOwrsPxiQUheeRAgUA49YNhbCqK1kS9grQhXGAhsDBUJgZ AL2Dcqkk7ogFpvRAokSn0p4PO6UIuUsQggSmFjKXdAgRAQAh+QQFCgAIACwAAAAAFAAPAAAEEhDJ Sau9OOvNu/9gKI5kaZ5oBAAh+QQJFAAIACwCAAEAEAANAAAEShAhQ6ulcg7Cuw/GJBSF55ECBQDj 1g2FsKorWRL2CtCFcYCGwMFQmBkAvYNyqSTuiAWm9ECiRKfSng87pQi5SxCCBKYWMpd0CBEBACH5 BAVkAAgALAAAAAAUAA8AAAQSEMlJq7046827/2AojmRpnmgEADs=

--------------Boundary-00=_4PUK6RO0000000000000--

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Prem Khanna J
  INET: jprem_at_kssnet.co.jp

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Tue Nov 18 2003 - 20:24:58 CST