direct path read temp

[vnktummala]

I would tkprof the trace file and focus on Wait Events section of it - you may want to include SYS=N option.

Risking to be stating the obvious please include...
alter session set max_dump_file_size = unlimited;
alter session set timed_statistics = true;
alter session set sql_trace = true;
...before actual alter session set events blah blah blah

Trace may be hitting max_dump_file_size value so it appears not to be tracing - that's the reason of the first command.

Also check you have enough space on dump file directory.

Thanks for the reply Paul.

all the parameters are already taken care except sql_trace. I believe when we are explicitly generating 10046 / 10053 trace we don't need to set sql_trace=true. Please update if my understanding is wrong.

any way, I will set it for session and generate 10053 trace again.

Also, I have a quick question for you. Is all the parallel slaves does direct path read? or it happens only when parallelism is enabled on object instead of parallel hint?

Thanks,