RE: Lock table table_name in exclusive mode - Performance gain?

2002-08-12 Thread Rachel Carmichael
: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of [EMAIL PROTECTED] Sent: Saturday, August 10, 2002 12:38 PM To: Multiple recipients of list ORACLE-L Subject: Lock table table_name in exclusive mode - Performance gain? Anyone do any bench marking, know of any papers, or using

RE: Lock table table_name in exclusive mode - Performance gain?

2002-08-11 Thread Larry Elkins
] 214.954.1781 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of [EMAIL PROTECTED] Sent: Saturday, August 10, 2002 12:38 PM To: Multiple recipients of list ORACLE-L Subject: Lock table table_name in exclusive mode - Performance gain? Anyone do any bench

Lock table table_name in exclusive mode - Performance gain?

2002-08-10 Thread Brian_P_MacLean
Anyone do any bench marking, know of any papers, or using lock table table_name in exclusive mode to get a performance boost. I'm trying to figure out how to do 90,000,000 operations (add/change/delete) on the same table/partitions in a 4 hour period, and it looks like lighting will have to