Home » RDBMS Server » Performance Tuning » Table locking problem
Table locking problem [message #65399] Wed, 08 September 2004 03:10
Messages: 1
Registered: September 2004
Junior Member

I am having a master table in my application. During normal working hours/half-peak hours, i am able to insert/update/delete any records.

But during peak hours, if i am trying to modify, it is taking hell amount of time and when i see v$locked objects, it shows some other master tables are locked against that session which are no way related to that master table.

I have checked the coding also, but i have not found any tables other than this master table in the coding.

Can any one help me to find the reasons for this?
Previous Topic: Usage of 4GTon Win2k
Next Topic: Index
Goto Forum:

Current Time: Wed Feb 21 18:35:40 CST 2024