Hi,
I have an applicaiton that executes DDL stetemnts, on the same Database in parallel threads.
I take care that one table is used by may. one threads in the moment....nevertheless is that column, index, or constraints...one table can be touched by one thread in the memont.
The problem is that, from time to time, I am getting ORA-00060: Deadlock detected while waiting for resource....even 2 , or more, threads are working on 2 tables that are not anyhow interconnected.
For example on thread executes : alter table T1 add primary key ( col1 )
while teh second thread executes alter table T2 add primary key ( col2 )
Also, it happens not so often....I am able to exeucte 3 K parallel statements, but then , from time to time , I get this error
My question is:
are DDL statements allowed on the same DB or there are some limittation ( I explained that I took care about parallel table access ) ?
At the end...what are the safe rules that DDL can go in parallel threads ...or not recommended at all ?
my Oracle version is 11.2.0.1.0 and I am using C# as client