SQLPLUS hangs on connecting to database
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: SQLPLUS hangs on connecting to database

  1. #1
    Join Date
    Apr 2006
    Posts
    2

    SQLPLUS hangs on connecting to database

    A colleague was deleting million plus rows from a table , when others tried connecting to the Oracle database their sessions seemed to hang. Just trying to find a cause for this as I believe this shouldn't have happened. The deletion didnt use the nolog option and the archived redo logs were full , but go no errors in the alert file. The Undo tablespace reached its maximum and was unable to grow any further. Would any of these stop people connecting ? The cpu utilisation on the server was very low. The solution ended up killing oracle and restarting the server, but just trying to find a root cause. in the Listener.log, everything looked normal and was still accepting connections,and another user was doing a full table scan select on the table that was having rows deleted. But still no reason for users not being able to connect, even as sysdba locally

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    if the archive log directoy was full, yes people wouldnt be able to connect.

    Also you can't nolog a delete

  3. #3
    Join Date
    Apr 2006
    Posts
    2
    the archive log directory wasnt full, but very busy as you could imagine, the undo tablespace was full, is it more likely to be the undo or the archived log that caused the problem, if its the undo is it worth using undo limits in the resource plan?

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    undo usage wouldnt stop a user from logging in.

    only thing that would be is archive log dest full or server too busy to process the request

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width