desc v$session_longops : dbms_application_info « System Packages « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. System Packages
3. dbms_application_info

SQL>
SQL> declare
  2      l_nohint number default dbms_application_info.set_session_longops_nohint;
  3      l_rindex number default l_nohint;
  4      l_slno   number;
  5  begin
  6      for i in 1 .. 25
  7      loop
  8          dbms_lock.sleep(2);
  9          dbms_application_info.set_session_longops
 10          ( rindex =>  l_rindex,
 11            slno   =>  l_slno,
 12            op_name => 'my long running operation',
 13            target  =>  9999,
 14            target_desc => 'my target',
 15            context     => 0,
 16            sofar       => i,
 17            totalwork   => 25,
 18            units       => 'loops'
 19          );
 20      end loop;
 21  end;
 22  /

PL/SQL procedure successfully completed.