Database Administration (MOSC)

MOSC Banner

How to monitor Triggers

edited Jul 2, 2010 9:33PM in Database Administration (MOSC) 3 commentsAnswered
There is a business requirement to measure the average time max time and min time a trigger needs  to complete. Is there any

database table to do so . If not what is that I can do to capture the " Average time " , " Maximum time " , " Minimum time" for  each time

a particular trigger runs . The trigger runs 100000 times a day and each time it runs the output have to be captured.

Thanks

Somnath

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center