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