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
>
> --
> http://www.freelists.org/webpage/oracle-l
>
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Aug 25 2005 - 08:47:15 CDT
