1.If any user disables a trigger, then as a DBA how could I trace such a user who had disabled the trigger!
2.How and what is the approach to define the Normal size,size increases for Indexes,types of Indexes on around 900+ tables.
Login as sys or system and execute the following query to find out all disabled trigger for all users
select trigger_name,table_owner,table_name,status from all_triggers where status = 'DISABLED'
What about Time element to trace at what time the user disabled the trigger!
Thanks for the reply!
1.What about Time element to trace at what time the user disabled the trigger!
How could I enable time element for this!
Click Here to Expand Forum to Full Width