amin_adatia wrote:04021, 00000, "timeout occurred while waiting to lock object %s%s%s%s%s"
126.96.36.199.0 (Exadata X3)
I have a table with partitions on partition_date and data_type with 32 subpartitions on hash(Identifier)
I am trying to run multiple jobs which do
insert into <partitioned table>
select * from <queue_table>
I have different queue_tables per partition_date and each insert only works with one date data
I am getting row cache lock and library cache lock events and some jobs failed with
ORA-04021: timeout occurred while waiting to lock object
Do I have to insert <partitioned_table> partition (partition_name which is composite of all the subpartitions) ?