RE: counting hits in an application

RE: counting hits in an application

 

  

I am personally not sure of another sure method. However, someone else
may have some ideas.

-----Original Message-----
From: Udi
[mailto:oracledba-ezmlmshield-x64753222.[Email address protected]
Sent: Tuesday, December 27, 2005 1:20 PM
To: LazyDBA Discussion
Subject: RE: counting hits in an application

That's an idea - but doesn't auditing involve inserting rows to the AUD$

table? is that substantially more efficient that just adding an INSERT
into your own code?

This is a very intensively used stored procedure that does read-only,
and
I was hoping to avoid executing DML altogether. Looking for a way to get

Oracle to track it internally through some use-count counter in the
buffer
where the stored procedure is cached, or something of that nature.

?????????????????

Thanks,

Udi

This message and any files or text attached to it are intended only for
the recipients named above, and contain information that may be
confidential or privileged. If you are not an intended recipient, you
must not read, copy, use, or disclose this communication. Please also
notify the sender by replying to this message, and then delete all
copies
of it from your system. Thank you.




"Patterson Joel "
<oracledba-ezmlmshield-x20783580.[Email address protected]
12/26/2005 06:33 AM

To: "LazyDBA Discussion" <[Email address protected]
cc:
Subject: RE: counting hits in an application


Oracle auditing?

-----Original Message-----
From: Udi
[mailto:oracledba-ezmlmshield-x4549695.[Email address protected]
Sent: Friday, December 23, 2005 6:02 PM
To: LazyDBA Discussion
Subject: counting hits in an application

What are the recommended options of counting how many times a stored
procedure is called from an application during a 24-hour period (other
than adding an INSERT statement into the stored procedure that will
record
the DATE/TIME) ???

Thanks,

Udi

This message and any files or text attached to it are intended only for
the recipients named above, and contain information that may be
confidential or privileged. If you are not an intended recipient, you
must not read, copy, use, or disclose this communication. Please also
notify the sender by replying to this message, and then delete all
copies
of it from your system. Thank you.


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html




--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:
http://www.lazydba.com/legal.html




--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html



Oracle LazyDBA home page