Toad World® Forums

Identifying Row Chaining and Migration


#1

Hi,I am on Taod 9.7.2.5.

Is there a Toad Feature to identify if a running query is having “Row Migration
/ Chaining” issue.

Thanks,

Shiva


#2

Open the session browser and look for a ‘table fetch continued row’
wait event I think…


#3

Hi Jeff,

Open the session browser and look for a ‘table fetch continued row’ wait
event I think…
Correct.

Or, run the query in a session then select from V$MYSTATS (V$MY_STATS?)
and see what’s logged for that event.

Cheers,
Norm. [TeamT]

Actually, Team At Home, Ironing! :wink:


#4

Is Ironing@Home a prerequisite for Folding@Home.

http://folding.stanford.edu/

Michael


#5

Evening Michael,

Is Ironing@Home a prerequisite for Folding@Home.
http://folding.stanford.edu/

not that I’m aware of. Ironing at home is a prerequisite for putting
clothes into a suitcase ready to hand over to several burly gents at the
airport who will, with delight and relish, throw said suitcase around
all day so that when you arrive at your destination, your nicely ironed
clothes are, quite literally, a mess!

I think!

Folding@home is all about science - and modelling proteins and enzymes.
(I think!)

Cheers,
Norm. [TeamT]