Re: need query to tell inserts per hour

Look at turning on Auditing for the tables that you are interested in tracking inserts for.

You can read about how to implement auditing in Chapter 24 of Oracle 8i
Administrators Guide. It does take extra resources as it writes audit information to a system table (sys.aud$).

HTH
MJW "Yaroslav Perventsev" <p_yaroslav_at_cnt.ru> wrote in message news:<9j41k8$iah$1_at_news247.cnt.ru>...
> 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 - 15:52:03 CDT