A远程执行sql脚本,其中一段内容如下:drop table tmp_rpt_monthoperate purge;
create table tmp_rpt_monthoperate nologging
as
select * from rpt_monthoperate@report
where 1=0;然后主机停止,不继续往下执行,我看日志报错如下:create table tmp_rpt_monthoperate nologging
*
ERROR at line 1:
ORA-44203: timeout waiting for lock on cursor超时,请问这个一般是由于远程数据库什么原因引起的我在A机进入sqlplus 是可以执行
select * from rpt_monthoperate@report
where 1=0;
create table tmp_rpt_monthoperate nologging
as
select * from rpt_monthoperate@report
where 1=0;然后主机停止,不继续往下执行,我看日志报错如下:create table tmp_rpt_monthoperate nologging
*
ERROR at line 1:
ORA-44203: timeout waiting for lock on cursor超时,请问这个一般是由于远程数据库什么原因引起的我在A机进入sqlplus 是可以执行
select * from rpt_monthoperate@report
where 1=0;
44203, 0000, "timeout waiting for lock on cursor"
// *Document : Yes
// *Cause : A timeout occured while waiting for a cursor to be compiled.
// This is usually caused by the SQL parse requiring access to
// system resources which are locked by concurrently executing
// sessions.
// *Action : Investigate possible causes of resource contention. If
// neccessary, contact support for additional information
// on how to diagnose this problem.
/////////////////////////////////////////////////////////////////////////////
// Reserving 44301 - 44400 for DBMS_SERVICES errors
/////////////////////////////////////////////////////////////////////////////