Check for objects created/modified under SYS or SYSTEM Schema in 24 Hours


SELECT owner || '.' || object_name object_name, object_type, 
 to_char(last_ddl_time,'MM-DD-YYYY HH24:MI:SS') last_ddl_time 
FROM dba_objects 
WHERE last_ddl_time > (sysdate - 1) 
AND owner in ('SYS', 'SYSTEM') 
ORDER BY owner, object_type;

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: