Commit Problem
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Commit Problem

  1. #1
    Join Date
    Mar 2011
    Posts
    2

    Commit Problem

    Hi for everyone,
    we have oracle ERP in our company it's based on Oracle 8i database installed on windows 2003 server enterprise edition and designed by developer 6i ,sometimes the users complain because when they come to saving the data it's hanging ,and what I do I kill some session after that the user can save there data but this problem is occur again and again on the last days and there is enough space on the hard disk and the table space ,please what it should be the reason and what is the best solution for this problem.
    thanks and good wishes for all

  2. #2
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    when it hanged next time, trace the session and find what it is doing.

    Thanks,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

  3. #3
    Join Date
    Mar 2011
    Posts
    2
    thank you Vijay Tummala for your fast reply,the problem is not with one user but with more than one user and they using different models one in sales the other in production but with in the same ERP and they hanging all in the same time.
    and thanks again

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    well see what their sessions are waiting on, by tracing the session and find the cause of the problem

  5. #5
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Quote Originally Posted by ronald75 View Post
    we have oracle ERP in our company it's based on Oracle 8i database installed on windows 2003 server enterprise edition and designed by developer 6i ,sometimes the users complain because when they come to saving the data it's hanging ,and what I do I kill some session after that the user can save there data but this problem is occur again and again on the last days and there is enough space on the hard disk and the table space ,please what it should be the reason and what is the best solution for this problem.
    Have you bother in checking for blocking locks at the time of the event?
    How do you identify which sessions to kill?
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

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