Long query, ask for progress
From: Andreas Mosmann <mosmann_at_expires-31-01-2011.news-group.org>
Date: Wed, 26 Jan 2011 08:44:00 +0100
Message-ID: <1296027840.2_at_user.newsoffice.de>
Hi,
Date: Wed, 26 Jan 2011 08:44:00 +0100
Message-ID: <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> deReceived on Wed Jan 26 2011 - 01:44:00 CST