Cursor's base query

1

Hello, I see "fetch xx from curxx" queries taking long to run - how do I identify the declared cursor query?

Using the pid when I am looking to svl_qlog or stl_query, I see the session has -

2019-06-18 16:08:53	2019-06-18 16:08:53 SELECT COUNT(*) FROM sometable LIMIT 1 OFFSET 0  
2019-06-18 16:08:58	2019-06-18 16:51:39	FETCH 200 FROM CUR0```  
  
The fetch query seems to be running for long, fetching lots of data but the count(*) could not be the query from where its pulling the data. So how do I identify the base query. Would the pid change for the fetch query, if so how to co-relate them?  
  
Edited by: nmakb on Jun 18, 2019 2:19 PM
  • By any chance, did you find a solution for it?

nmakb
preguntada hace 5 años170 visualizaciones
1 Respuesta
0
nmakb
respondido hace 5 años

No has iniciado sesión. Iniciar sesión para publicar una respuesta.

Una buena respuesta responde claramente a la pregunta, proporciona comentarios constructivos y fomenta el crecimiento profesional en la persona que hace la pregunta.

Pautas para responder preguntas