RE: More features no one needs but me...

  • From: "Kerber, Andrew W." <Andrew.Kerber@xxxxxxx>
  • To: post.ethan@xxxxxxxxx, "oracle-l" <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 26 Jun 2007 07:31:50 -0500

Couldn't you write a stored procedure to read v$session and set it up in
the scheduler?  Might be interesting to try...

 

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Ethan Post
Sent: Monday, June 25, 2007 4:25 PM
To: oracle-l
Subject: More features no one needs but me...

 

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?

- Ethan


------------------------------------------------------------------------------
NOTICE:  This electronic mail message and any attached files are confidential.  
The information is exclusively for the use of the individual or entity intended 
as the recipient.  If you are not the intended recipient, any use, copying, 
printing, reviewing, retention, disclosure, distribution or forwarding of the 
message or any attached file is not authorized and is strictly prohibited.  If 
you have received this electronic mail message in error, please advise the 
sender by reply electronic mail immediately and permanently delete the original 
transmission, any attachments and any copies of this message from your computer 
system. Thank you.

==============================================================================

Other related posts: