Database hanging during insert - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14

Thread: Database hanging during insert

  1. #11
    Join Date
    Jan 2001
    Posts
    16
    Noboby else is using this data.

  2. #12
    Join Date
    Oct 2000
    Posts
    80
    I'm kinda out of ideas for you. You could kill the session and retry the job, but as they say insanity is doing the same thing over and over again and expecting a different result.
    John Doyle

  3. #13
    Join Date
    Mar 2000
    Location
    CA
    Posts
    317
    How do you know that, it is not doing anything. Open another SQL session and count the number of rows in that table. If it is still hanging, may be you need to kill the session. You will be able to see those rows if you are committing for x number of rows.
    Thanks
    Kishore Kumar

  4. #14
    Join Date
    Dec 2000
    Posts
    46
    Assuming that you are running archivelog mode:

    Check to see if your archive log directory is full. (df -k .)
    make sure you have enough space available to create additional files.

    The view v$log_history should tell you the frequency of log switch
    if you are generating too many log files it is possible that your archiver
    process is unable to keep up with the load. If you check the v$log
    and see all of them as active or current you should consider either
    increasing the size of your redo logs or create more redo groups.

    Hope it helps.


    Thanks

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