I have got a query running INSERT Statement and it inserting 
4 millions rows and i running for last 6 hours
but i cant see any reference in v$session_longops


I can see the SID, sql details in v$session and v$sql views.


Can you somebody let me know how i can check the current
status of this query? 

ok,obviously you can not see.. right..

SQL is like this

INSERT INTO TAB1
(SELECT /*+ parallel( t 4) */ C1,C2,C3 FROM TEMP t WHERE
CODETYPE ='p'
)

Now above SQL takes more than 14 hours, its has 4 millions records to insert, now i think its something with the performance, if you have any good reason , please let me help me to solve this long running sql.

Target table has 2 non-unique indexes ( table has total 3 columns), no partitions, oracle 9.2.0.6 , sun solaris,unix OS

Also table has already millions of rows, so we are adding new data everyday into the target table, so we can not use CREATE TABLE ... AS SELECT..