SQL Performance (MOSC)

MOSC Banner

Query with "direct path read" and "asynch descriptor resize" waits

edited Dec 3, 2014 12:30PM in SQL Performance (MOSC) 1 commentAnswered

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)||'/'

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center