Hi Madhu,

Thanks for replying, I have the init parameter enqueue_paramter set to 5000, and the no. of tables in all schemas put together are 40. Most of the tables are partition tables and each table has about 45 partitions. About 15 tables have partitions.

Thanks for replying,