Go to the FreeLists Home Page Home Signup Help Login
 



[oracle-l] || [Date Prev] [08-2005 Date Index] [Date Next] || [Thread Prev] [08-2005 Thread Index] [Thread Next]

enqueue waits

  • From: raja rao <raja4list@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 2 Aug 2005 07:15:28 -0700 (PDT)
Hi All,
 
When i try to delete few rows (4 rows) from the table bom.cst_item_cost_details 
 (oracle apps 11.5.9), i observed that the session is waitng on enqueues. 
(The above table is too big, it has 20 million records in it.)
 
But could not get much info what is the child table on which it is serching.
 
Can someone throw somelight how to understand and find the root cause of these 
enqueus.
 
what even could help understand the root cause .
 
Thanks,
Raj

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 




[ Home | Signup | Help | Login | Archives | Lists ]

All trademarks and copyrights within the FreeLists archives are owned by their respective owners.
Everything else ©2007 Avenir Technologies, LLC.