<div>
<div class="content wysiwyg-content">
In SQL*Plus running on windows, I issued an ALTER INDEX index_name REBUILD ONLINE statement. &nbsp;This was about 8 hours ago; the table the index is on is very large.<br />
<br />
Right now, my SQL*PLUS window says (In the blue section at the very top of the window) 'Oracle SQL*Plus (Not Responding). &nbsp;I had opened SQL*PLUS while tunneling into work from home over a VPN. &nbsp;I think what happened is that the connection between SQL*PLUS and the oracle database timed out.<br />
<br />
Should I assume that the server process that was doing the index rebuild is dead? &nbsp;How do I find out? &nbsp;<br />
<br />
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? &nbsp;If so, how do I do that?<br />
<br />

</div>
</div>


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?



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) &#39;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?



Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.