about "cursor: pin S wait on X" wait event.

From: Havel Zhang <havel.zhang_at_gmail.com>
Date: Tue, 26 Aug 2008 01:27:32 -0700 (PDT)
Message-ID: <e4bcfd4e-13b5-4135-be1c-9fc4e4682241@26g2000hsk.googlegroups.com>


hi all:

      Recently "cursor:pin S wait on X" wait event troubles me.
      I have two DB Server for a website. Everynight, Server A push
new 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?

Details:
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 9.2.0.1.0 OS:windows server 2000 32bit

thank you!

Havel Received on Tue Aug 26 2008 - 03:27:32 CDT

Original text of this message