Database Administration (MOSC)

MOSC Banner

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center