E. Features Introduced in Ingres 9.2 : Supportability Enhancements : Ability to View Cursor Definition Text for an Executing Fetch
 
Share this page                  
Ability to View Cursor Definition Text for an Executing Fetch
When a cursor FETCH is executing for a user session, the text of the cursor as defined by DECLARE CURSOR is visible using iimonitor or the Interactive Performance Monitor (ipm). For example:
Query: open ~Q cursor for select a, b, c from t1 for readonly
This feature makes the query string being executed available; such information can be useful for performance tuning or problem resolution.