Re: How to detect unused objects

From: Marc <E.Mail_at_address.com>
Date: 2000/05/26
Message-ID: <8gllcj$brs$1@vkhdsu24.hda.hydro.com>#1/1

Maybe you can use the audit-statement and wait for a month...

Marc

jakobw_at_my-deja.com wrote in message <8glake$n7r$1_at_nnrp1.deja.com>...
>Hi,
>
>Problem: I want to detect dead code/unused objects in a database
>(8.1.5 for AIX 4.3)
>
>One idea was:
>
>ALTER SYSTEM FLUSH SHARED_POOL;
>
>Waiting some time...
>
>then:
>
>SELECT * FROM v$db_object_cache WHERE name = 'OBJECT_SAMPLE';
>
>If 'OBJECT_SAMPLE' is returned by the select, I know that it is used.
>But my problem is to detect unused objects e.g. procedures not used for
>1
>month...
>
>Any Ideas?
>
>thx
>
>Jakob
>
>
>
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Fri May 26 2000 - 00:00:00 CDT