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

Home -> Community -> Mailing Lists -> Oracle-L -> More features no one needs but me...

More features no one needs but me...

From: Ethan Post <post.ethan_at_gmail.com>
Date: Mon, 25 Jun 2007 16:24:31 -0500
Message-ID: <357b48a90706251424l5de3c8dbt3ae2aaa565a186f3@mail.gmail.com>


I have implemented a debug API which appears to work quite well. One nice feature is that it will dump wait event info roughly every 30 seconds. However the feature could be considered "passive" in the sense that a call must be made to one of the existing PL/SQL packages or procedures which contains an entry point into the API for the data to get dumped. So it works pretty much like standard debug...the debug is occurring from within the session.

Well, wouldn't it be nice if I could simply tell a session, "hey, you call procedure x every 30 seconds". It would not matter where in the code path was, or even if the session was sitting idle, it would make a call to x every 30 seconds. This way I would be able to continue to do things like dump wait info on schedule but still in a passive sense.

As it stands if all of the processing is occurring on the client, or in the midtier I don't get the information I need until those components are also making calls to the API.

Just a thought. Can I have it in 10.2.0.4 Oracle?

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jun 25 2007 - 16:24:31 CDT

Original text of this message

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