how to check script progress from sql

select sid,username,PROGRAM from v$session where username='&USER_NAME' and PROGRAM like '%sql%';

---enter the username

select sid,message from v$session_longops where sid = '&sid' order by start_time;
--- enter the sid