Re: need query to tell inserts per hour

Hello!

I think, you may analyze your (archived ) redo log files, using Oracle logminer.

Yaroslav.

<angry_garden_salad_at_yahoo.com> ÓÏÏÂÝÉÌ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ:zt457.22985$Kf3.307289_at_www.newsranger.com...
> 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 - 08:11:28 CDT