about "cursor: pin S wait on X" wait event.
Date: Tue, 26 Aug 2008 01:27:32 -0700 (PDT)
Recently "cursor:pin S wait on X" wait event troubles me. I have two DB Server for a website. Everynight, Server A pushnew data to Server B by one way. Because some security reason, Server B can not "pull" data from Server. So, I using following query to insert data to Server B:
insert into table_a_at_ServerB select * from table_on_server_a;
That is: I create a db link on Server A for Server B . I running this query on Server A without any problem by means of sqlplus scribe. But when I put these code on a perl program, system hunging on this query. I found system issues ""cursor: pin S wait on X" wait event for this query. Then, I put these code into a procedure, and running this procedure on sqlplus, system still hunging there.
Any come cross this problem? Can u help me?
Server A:Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit
OS:windows server 2003 64bit.
Server B:Oracle9i Enterprise Edition Release 22.214.171.124.0 OS:windows server 2000 32bit
Havel Received on Tue Aug 26 2008 - 03:27:32 CDT