Re: Insert statement hangs

2002-04-03 Thread Jeremiah Wilton
v$session_wait -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Wed, 3 Apr 2002, [EMAIL PROTECTED] wrote: > I am trying to insert a record thru sql*plus into a table. I am the only > one accessing database. It just hangs and never inserts. What I can I > look at to help determine why t

Re: Insert statement hangs

2002-04-03 Thread Big Planet
Rick , check logfiles May be ur database is running in archivelog and archive destinations are full . There are many other possible reasons ..look into alertSID.log for them . -Bigp - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, Apr

RE: Insert statement hangs

2002-04-03 Thread Seefelt, Beth
If you have the Diagnostics Pack, try looking at your session in Top Sessions. Beth -Original Message- Sent: Wednesday, April 03, 2002 1:06 PM To: Multiple recipients of list ORACLE-L Hi DBAs, I am trying to insert a record thru sql*plus into a table. I am the only one accessing data