sql - Using dbms_application_info.set_module before running a long query in Oracle -

i trying figure out how set module name in v$session before running long query can track progress. possible? not quite work. how change will?

begin dbms_session.set_identifier(client_id=>'abc'); dbms_application_info.set_client_info(client_info=>'abc test'); -- dbms_application_info.set_module(module_name=>'some name', action_name=>'some action'); -- select * tablename ..... -- dbms_application_info.set_module(module_name=>'',action_name=>''); end; 

it must this:

begin dbms_application_info.set_module('my procedure', 'starting');  dbms_application_info.set_action('running'); select * tablename .....  dbms_application_info.set_module(null, null); end; 

while query executing can select (at session of course) v$session