RE: Insert Rate/Second
- From: "Bruce McCartney" <bruce.mccartney@xxxxxxxxxxxxxxxxx>
- To: <mkb125@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 25 Aug 2005 07:45:05 -0600
Mohammed,
Good question. I can't remember the specifics, other that it made it work
:)
I think it had something to do with a delay in stats appearing due to some
timeout in smon; I am on the road now and don't have access to run some
tests. I have used this script at many sites since 8.1.7 and felt the
numbers were consistent. Let me know if you think something is wrong...
Bruce McCartney
> >
>
> No...wait, Bruce's script and idea is accurate if you also
> include the conversion-to-seconds factor, it was me who
> screwed up. When the script runs, it issues a
> dbms_lock.sleep(30). If you multiply the INS_RATE by 30,
> you'll get a figure close to 7k rows/sec.
>
> In fact, changing sleep(30) to sleep(1) also gives a value
> close 7k rows/sec. Getting rid of it altogether, also works.
>
> So what was the idea behind the sleep?
>
> Thanks again.
>
> --
> mohammed
>
>
>
> ____________________________________________________
> Start your day with Yahoo! - make it your home page
> http://www.yahoo.com/r/hs
>
> --
> //www.freelists.org/webpage/oracle-l
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
