Timestamp differences between audit table and dba_object
Hi Team,
I have situation where i am looking at when procedure change has been implemented in our Oracle 12.1.0.2 (OEL7) by executing:
select object_name,last_ddl_time
from dba_objects where object_name='TEST_PROC'
And I get that last_ddl_time was at 9/1/2021 10:20:05 AM
When i check our audit table dba_audit_object I get different result from column timestamp as 9/1/2021 11:20:05 AM
As you can see it is an hour difference between those results.
Any ideas why this occurs?
Thank you