This script generate a list of your requests. You can restart one or more by copy / paste the “@req2 <request id>” in the right column of the list:
sql> @req
-----------------------------------------------------
copyright thomaslundqvist.dk 2009
requestor....: XXTLQ
req id exe NAME EXE
-------- -------- ----------------------------------------------------- --------------------
12841802 *(D) XXXX Picking Interface to XXX : , @req2 12841802
12841803 0(E) XXXX Picking Interface to XXX : , @req2 12841803
12841878 103 XXXX Picking Interface to XXX : , @req2 12841878
copy/paste the request to start or enter:
SQL> @req2 12841878
Restart Concurrent Request
-------------------------------------
copyright xls4oracle.com 2009
REQUESTOR.................: XXALF
PROGRAM_NAME..............: XX_REPORT
APPLICATION_SHORT_NAME....: XXXX
DESCRIPTION...............:
ARGUMENTS.................: 09-2009
begin fnd_global.apps_initialize(31145,54123,600,0); end;
Request 12841878
Elapsed: 00:00:01.00
SQL>
syntax: @req
syntax: @req2 <request_id>
Download: sql4oracle.zip