Query with "direct path read" and "asynch descriptor resize" waits
Hi,
I have a query that shows the wait event "direct path read" for 1 hour and 14 minutes and after remains 15 minutes with "asynch descriptor resize" wait event.
Last wait event of the query is "direct path read" for 15 minutes aprox.
It finishes at the end and shows 0 rows but I am concerned if it can be a problem with the Disk I/O or some kernell parameter.
Can you help me?
Thanks for your time.
Here the query:
select 'C'||(rownum*2-1)||'/'||substr(p_id_nodo,1,8)||'/'||substr(dfo_eid,1,8) nom_link,
'C'||(rownum*2)||'/'||substr(p_id_nodo,1,8)||'/'