Oracle10g-compilation of package very slow-TNS-12571

From: hitender chugh <>
Date: Sun, 16 Aug 2009 23:24:29 -0400
Message-ID: <COL124-W328AA5936EC5A23864851EBD010_at_phx.gbl>

Installed 10g on a new Itanium HP-UX 11.23 OS server and installed patch too . Sometimes Database package compilation takes very long time like 2-20 mins. Sometimes it completes successfully other times gives TNS-12571 error and comes out. Tried with Oracle9i and 10g clients but same issue. Compilation of package/s works fine on Oracle9i HP_UX PA-RISC sever, takes only few seconds. It seems like everything is hanging. Shows no active sessions also or any locking issues during the time it is compiling. Tried with sqlnet.expire_time=4 on client and server no success. Tried setting plsql_optimize_level from 2,1 and 0 no success in that too. Tried with alter session set events '10946 trace name errorstack level 65536' still no success. Please advise.


Windows Live: Make it easier for your friends to see what you’re up to on Facebook.
Received on Sun Aug 16 2009 - 22:24:29 CDT

Original text of this message