This content has been marked as final. Show 6 replies
user9256814 wrote:additional clues will exist within alert_SID.ora file & subsequent trace file.
My database version is 126.96.36.199.0. I am loading the data using sqlldr. I am getting the error ORA-00060: deadlock detected while waiting for resource. once dead lock detected ,whether data will be rejected after commit point reached(Rows=100000). FYI information only sqllder is running on the database,it is getting completed withing 5-10min. please help me whether any other lock happening on this due to sqllder.
sqlldr userid=orcl/orcle control=".$controlfile." log=".$logfile.".log data=".$datafile." bad=".$badfile." discard=".$discardfile." Bindsize=19000000 Rows=100000 Readsize=20000000 Errors=1000000";
Thanks in advance
while go thru alert log i found below error. But i do not find any error related to ORA-00060.
ORA-12012: error on auto execute of job 101
ORA-12801: error signaled in parallel query server P003, instance rdl10808dat05:yuk01r5 (5)
ORA-04020: deadlock detected while trying to lock object $BUILD$.745aaa3bc2d78510
ORA-06512: at "SYS.DBMS_STATS", line 18566
ORA-06512: at "SYS.DBMS_STATS", line 19051
ORA-06512: at "SYS.DBMS_STATS", line 19132
ORA-06512: at "SYS.DBMS_STATS", line 19088
ORA-06512: at line 1
Do you have a bitmap index on any of the table(s) you are loading in to?
There should be a trace file for the deadlock created somewhere in the filesystem with more details.
There are BITMAP index is created on this table.
any thing BITMAP index causing dead lock error...But only one sqllder running to load the data..
Self deadlock is possible with bitmap indexes.....