DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Locks Problem

  1. #1
    Join Date
    Apr 2001
    Location
    Ludhiana (Punjab) India
    Posts
    36

    Question Locks Problem

    Hello Oracle Gurus

    In my database i have 650 tables in one user and 3 different units are accesing same tables but for there own data which is identified by primary key like : for unit one each table is having a unique : uc1 and for unit two : uc2 and for unit three uc3. so in all 3 units people use to make Quotations,Purchase Orders, Gate Enteries,Material Receipt Notes, Invoices, Challans, Material Issues. The Problem i am facing is when people use to make purchase order in any unit then relavent gate entry ,materialreceiptnote and other tables gets locked and resulted in dead lock and cpu times goes 100% an ultimately i have to shut down the server and restart it. when i see the lock it shows exclusive locks on item master table and other tables. My tunning of database is perfect cache hit ratio and others are 99%. so please suggest what should i do.

    regards

    Gurpreet Sethi

  2. #2
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    Check for unindexed foreign keys..

    If there is dead lock look at the correspindiung alert log and trace file this would give you some start..what version of oracle are you running by the way..

    Also have alook at the SQL statemenet..

    Are there any batch jobs running ?

    regards
    Hrishy

  3. #3
    Join Date
    Apr 2001
    Location
    Ludhiana (Punjab) India
    Posts
    36

    Lightbulb thanks for reply

    oracle version is 8.1.5.0.0 and there is no batch job is running.

    regards

    gurpreet sethi

  4. #4
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    a)How about unindexed foreign keys.

    b)How about the sql statements that was running at that point of time.

    c)Whats there in the alert and trace files.

    regards
    Hrishy

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