Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: trending transaction by update,delete,select,insert on a periodic and cummulative
On Tue, 24 Aug 2004 20:44:00 -0400, "DK" <dakight_at_bellsouth.net>
wrote:
>My management is asking for some trending of various transactions by
>type(select,insert...) on a periodic basis to determine peaks and valleys in
>the daily usage. They'd also like to get a cumulative look at those same
>types. Any one with ideas as to how to do this?
>
>TIA
>
What information do they think to derive from it? How busy the database is? Does the number of inserts, update, deletes, selects tell you how busy the database is?
If you really want to:
check out the audit command
-- Sybrand Bakker, Senior Oracle DBAReceived on Wed Aug 25 2004 - 05:31:24 CDT