Re: need query to tell inserts per hour

From: Stephen Bell <stephen.bell_at_cgi.ca>
Date: Wed, 18 Jul 2001 08:16:50 -0400
Message-ID: <3B557E31.1879A094@cgi.ca>

Hi,

I hope someone else can post a better solution, but all I can think of is an insert trigger on each of the tables you want to monitor or use Oracle's auditing capability.

angry_garden_salad_at_yahoo.com wrote:

> Hi,
> I'm running oracle 8.1.6 on solaris 7 and I'd like to know how many inserts I'm
> doing per hour. I could query all the tables every hour but that would be ugly.
> ( lots of tables ) Is there some table I can query that will tell me how many
> inserts that have been done since startup? If so, I could just query this table
> and do the math. Thanks in advance...
Received on Wed Jul 18 2001 - 07:16:50 CDT