Go to my website, page on MYTHS and
download the script that generates millions
of logical I/Os on one block. Run one concurrent
copy per CPU so all cpus are busy thrashing the
same block, and see what happens.
--
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Next Seminar - UK, April 3rd - 5th
http://www.jlcomp.demon.co.uk/seminar.html
Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
Author of:
Practical Oracle 8i: Building Efficient Databases
Yong Huang wrote in message ...
>But I can't see a number higher than 100 no matter what I do in the
>database or through my Portal site which is notorious for library
>cache latch contention (my _spin_count is 2000). ps -cL tells me the
>foregroup and background oracle processes are at TS class priority
>ranging from 8 to 46. dispadmin -c TS -g tells me that their time
>quantum ranges between 40 to 200 ms.
Received on Thu Mar 28 2002 - 00:52:30 CST
