How to find out the function/ procedure modify detail information when database audit turned on.
15:12:12 SYS@ usgdwdbp>show parameter audit
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
audit_file_dest string /oracle/admin/usgdwdbp/adump
audit_sys_operations boolean TRUE
audit_syslog_level string
audit_trail string DB
15:12:19 SYS@ usgdwdbp>
One Function last modify time show "2010-NOV-30:09:11:23"
15:21:12 SYS@ usgdwdbp>select OBJECT_TYPE,TO_char(CREATED,'YYYY-MON-DD:HH24:MM:SS'),TO_char(LAST_DDL_TIME,'YYYY-MON-DD:HH24:MM:SS'),TIMESTAMP,STATUS from dba_objects where object_name='GETWAFERREJECT'
;
OBJECT_TYPE TO_CHAR(CREATED,'YYYY-MON-DD:HH24:MM:SS') TO_CHAR(LAST_DDL_TIME,'YYYY-MON-DD:HH24:MM:SS') TIMESTAMP STATUS
-------------------------------------- ---------------------------------------------------- ---------------------------------------------------- -------------------------------------- --------------
FUNCTION 2010-SEP-08:10:09:15