I wanted to see the below information when one of the PLSQL procedure is running in the database.

1. Which SQL code is currenlty running?
2. How much percentage is completed for the current SQL code? Let us say, curretly, the one particular table is scanning. We need to know how much percentage is completed?
3. How many sessions are running in the database? ( I think, this can be found through v$session). But i wanted to see what code is running in each session?

I understand that we can see all these through TOAD. Let us say, we do not use TOAD. Where can i find the script to find all the above information?