RE: "Throttling" a session's IO

Now , *that* is thinking "beyond the box".

1. Something in Oracle (10046)
2. Something else -- the script / job identifying it's own tracefilename
3. Something on FileSystem (the trace file)
4. A named pipe
5. A sleep interval
6. A programming language other then the Bourne shell !

All very doable. But would be difficult to explain ! It is easier to say "I rewrote the SQL query and reduced the scope of the date-range in the query"
then to say a. b. c. d. e. f when explaining the solution to User Management. !

Hemant

At 12:02 AM Wednesday, Tanel Poder wrote:
>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 start a script which periodically reads bunch of rows from tracefile
>pipe and just discards them.

Hemant K Chitale
http://web.singnet.com.sg/~hkchital
and
http://hemantscribbles.blogspot.com
and
http://hemantoracledba.blogspot.com

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