-
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
-
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
-
thanks for reply
oracle version is 8.1.5.0.0 and there is no batch job is running.
regards
gurpreet sethi
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|