Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Can you tell how often a package is called?

Can you tell how often a package is called?

From: Chuck B <chuck_jen49_at_yahoo.com>
Date: 23 Dec 2002 06:34:46 -0800
Message-ID: <b1245bc4.0212230634.11fe714a@posting.google.com>


I am trying to monitor the usage of a system critical package and would like to know if it is possible with any of the dba or V$ views to tell how often it's called. What I'm looking for is some way to tell the last time it was executed and then tie this back to v$session to see who did it.

Has anyone done anything similar to this?

Thanks,
Chuck Received on Mon Dec 23 2002 - 08:34:46 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US