RE: "Throttling" a session's IO

Interesting....clever idea, Tanel!

-Mark

--
Mark J. Bobak
Senior Oracle Architect
ProQuest/CSA

"There are 10 types of people in the world:  Those who understand
binary, and those who don't."

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Tanel Poder
Sent: Tuesday, April 03, 2007 12:02 PM
To: hkchital_at_singnet.com.sg; jkstill_at_gmail.com; Smith.Steven_at_dol.gov;
oracle-l_at_freelists.org
Subject: RE: "Throttling" a session's IO

Hemant,



> How do you control a session's IO rate ?


Create a pipe instead of the while which would be created if you enabled
tracing.
Then enable 10046 trace with waits in your session and start the job.

Then start a script which periodically reads bunch of rows from
tracefile pipe and just discards them. 
This script should keep the file descriptor open, you need to use perl
or compiled code for it as a plain shell read loop would probably be too
slow.

This means more CPU usage, but you can throttle the physical IO with
short sleeps between pipe reads...

Tanel.

--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l