Home » SQL & PL/SQL » SQL & PL/SQL » How do I see if procedure or view is actually used/executed/accessed
How do I see if procedure or view is actually used/executed/accessed [message #8413] Tue, 19 August 2003 07:58 Go to next message
Sid
Messages: 38
Registered: May 1999
Member
Hi,

I am running Oracle 8i and need to find out if a procedure or view in the DB is actually used/executed/accessed. is it possible to view this somewhere?
Re: How do I see if procedure or view is actually used/executed/accessed [message #8420 is a reply to message #8413] Tue, 19 August 2003 14:59 Go to previous messageGo to next message
Munish
Messages: 21
Registered: November 2001
Junior Member
select TO_CHAR(LAST_DDL_TIME,'mon-dd-yyyy hh:mi:ss')
from all_objects
where object_name = 'test_sec'
AND OWNER = 'test'

TO_CHAR(LAST_DDL_TIM
--------------------
aug-19-2003 04:33:46

hope this helps
Re: How do I see if procedure or view is actually used/executed/accessed [message #8432 is a reply to message #8420] Wed, 20 August 2003 07:42 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
correct me if am wrong.
i was under assumption that dba_object.last_ddl_time will show only the last ddl ( if the there is a change in the definition of object or recompilation).
and not the timestamp when it was accessed or executed.
Previous Topic: Doubt reg. Long datatype in a table
Next Topic: Printing an ER Diagram
Goto Forum:
  


Current Time: Fri Mar 29 10:34:19 CDT 2024