Show output in real time
- Thread starter X3mE
- Start date
No, this is not possible. The dbms_output buffer is local to the session, so it can only be accessed after the session has finished the query or script.
ScottMattes
Member³
Having gone through this some years back, I settled on using DBMS_APPLICATION_INFO and some queries to see what was going on in real time.
Look at Oracle R11 DBMS_APPLICATION_INFO for more information.
Look at Oracle R11 DBMS_APPLICATION_INFO for more information.
Good one Scott. I don't know the requirements, but if this works, I wanted to point out that the sessions screen in PL/SQL Developer shows the Module and Action that is set with dbms_application_info.set_action. I use this to display the major sections on long running programs so I know where it's at.
Additionally, you can open the wrench in the sessions screen and add a Details SQL that is set with dbms_application_info.set_session_longops. This way, it will show how many records have been processed. For example, if you know you have a thousand employees, you can know it's worked on 12 so far and know it has a ways to go. Here is the SQL to use:
SELECT opname
,sofar
,totalwork
,units
,elapsed_seconds
,time_remaining
FROM v$session_longops
WHERE sid = :SID
The timer button is also nice for keeping an eye on the status.
Additionally, you can open the wrench in the sessions screen and add a Details SQL that is set with dbms_application_info.set_session_longops. This way, it will show how many records have been processed. For example, if you know you have a thousand employees, you can know it's worked on 12 so far and know it has a ways to go. Here is the SQL to use:
SELECT opname
,sofar
,totalwork
,units
,elapsed_seconds
,time_remaining
FROM v$session_longops
WHERE sid = :SID
The timer button is also nice for keeping an eye on the status.
Similar threads
- Discussion