怎么查看Oracle触发器是否失效?

Answer 1

select * from user_objects where object_name = trigger_name and status='INVALID'