View disabled Triggers!Urgent!

Hi all!

Queries:

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.

Regards,

Amit.

Hi Amit,

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'

Regards

HI!

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!

Regards,

Amitstora.