--------------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 <[EMAIL PROTECTED]> 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> <!--IncrdiXMLRemarkStart> <IncrdiX-Info> <X-FID>FLAVOR00-NONE-0000-0000-000000000000</X-FID> <X-FVER></X-FVER> <X-CNT>;</X-CNT> </IncrdiX-Info> <IncrdiXMLRemarkEnd--> </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:[EMAIL PROTECTED]">[EMAIL PROTECTED] 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&lang=3D9";>= <IMG alt=3D"" hspace=3D0 src=3D"cid:2CDEA47B-8D43-4829-B29E-06BA78567C64"= align=3Dbaseline border=3D0></A> <I>IncrediMail</I> - <B>Email has= finally evolved</B> - </FONT><A href=3D"http://www.incredimail.com/redir= =2Easp?ad_id=3D309&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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
