Re: Long query, ask for progress

"Andreas Mosmann" <mosmann_at_expires-31-01-2011.news-group.org> a écrit dans le message de news: 1296027840.2_at_user.newsoffice.de...
| Hi,
|
| I work on Oracle 11 and sometimes there are queries, that need hours to
| be performed.
| is there a way to find out the progress of a special query within
| another session?
|
| pseudo:
|
| AsynchronSession:=StartSessionAsynchron(VeryLongQuery);
| AnotherSession:=StartSynchronSession();
| While AsynchronSession.IsRunning do begin
| PrintResult(AnotherSession.StartQuery(QueryToFindOutProgress));
| Wait(60 sek);
| end;
|
| Thank you
| Andreas
|
| --
| wenn email, dann AndreasMosmann <bei> web <punkt> de

SQL> desc V$SESSION_LONGOPS

 Name                             Null?    Type
 -------------------------------- -------- ----------------------
 SID                                       NUMBER
 SERIAL#                                   NUMBER
 OPNAME                                    VARCHAR2(64)
 TARGET                                    VARCHAR2(64)
 TARGET_DESC                               VARCHAR2(32)
 SOFAR                                     NUMBER
 TOTALWORK                                 NUMBER
 UNITS                                     VARCHAR2(32)
 START_TIME                                DATE
 LAST_UPDATE_TIME                          DATE
 TIMESTAMP                                 DATE
 TIME_REMAINING                            NUMBER
 ELAPSED_SECONDS                           NUMBER
 CONTEXT                                   NUMBER
 MESSAGE                                   VARCHAR2(512)
 USERNAME                                  VARCHAR2(30)
 SQL_ADDRESS                               RAW(4)
 SQL_HASH_VALUE                            NUMBER
 SQL_ID                                    VARCHAR2(13)
 QCSID                                     NUMBER

Regards
Michel Received on Wed Jan 26 2011 - 10:36:06 CST