DeepDulcet
asked on
oracle, 10g, Trying to rebuild index: SQL*Plus in not responding state
In SQL*Plus running on windows, I issued an ALTER INDEX index_name REBUILD ONLINE statement. This was about 8 hours ago; the table the index is on is very large.
Right now, my SQL*PLUS window says (In the blue section at the very top of the window) 'Oracle SQL*Plus (Not Responding). I had opened SQL*PLUS while tunneling into work from home over a VPN. I think what happened is that the connection between SQL*PLUS and the oracle database timed out.
Should I assume that the server process that was doing the index rebuild is dead? How do I find out?
Assuming the server process is dead or has been killed, and I try to issue the alter index statement again, should I try to make that run as a background process? If so, how do I do that?
Right now, my SQL*PLUS window says (In the blue section at the very top of the window) 'Oracle SQL*Plus (Not Responding). I had opened SQL*PLUS while tunneling into work from home over a VPN. I think what happened is that the connection between SQL*PLUS and the oracle database timed out.
Should I assume that the server process that was doing the index rebuild is dead? How do I find out?
Assuming the server process is dead or has been killed, and I try to issue the alter index statement again, should I try to make that run as a background process? If so, how do I do that?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.