-
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
Santosh
-
What about Time element to trace at what time the user disabled the trigger!
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|