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 220.127.116.11.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