I had started running a package around 2 hours ago in SQL navigator (Release 5.0.0.607), then whenh i go and check in Toad, it shows that it is running (please see attachment), but then the "ROWS", "Bytes", "Cost", etc columns in the explain plan in toad is showing null, does this indicate that it is in a hung state ?

OK, then it is waiting for writes into that file to finish all the time.

You can do an

SELECT * FROM DBA_DATA_FILES WHERE file_id = 203;

to see WHICH of the database files it is.

If it's a file in the temporary tablespace, then the select that is causing the wait hasn't got enough RAM so it has to use disk space. Then either you need to make more RAM available to the database, or the select needs to be changed/tuned.

These people are a lot smarter than I. They have get more information about a process doing work that I can get.

That said, I have some simple queries I use to figure out if a job is hung. First I figure out the session my job is tied to (this can require some doing in itself). Once I know the session or user doing the work then I run variations of these queries below to find out: