select s.sid, s.osuser, s.username, sw.event, sw.wait_time, sw.state from v$session_wait sw, v$session s where sw.sid = s.sid and sw.wait_time >= 0; select * from v$session_longops where time_remaining !=0;
965358 wrote:What do you mean by "can't insert a record"?
Hi I checked the v$session_longops and in in every siD this message is displayed
Table Scan: SYS.OBJ$: 24610 out of 24610 Blocks done
The problem is that i can even insert a record in any table even from any other session .
965358 wrote:you have a mystery & we have no clues.
The problem is In the new created table I am not able to insert records. The session keeps on executing forever.
Also I am using Plsql developer and in that if I see in tools-> session -> active session
for my session under event the message is 'statement suspended wait error to be cleared'
Edited by: 965358 on Dec 24, 2012 6:30 AM
965358 wrote:For future reference, that error would show up in the alert log. And you should always check the alert log when you have a mystery.
Yes i just checked the user_resumable and the there was an error stating
ORA-01653: unable to extend table.
Apart from this I really apologize if my question was not meaning full. The problem i that i was not getting the error message and even i was not able to understand what is really happening