Oracle10g-compilation of package very slow-TNS-12571

From: hitender chugh <chughhk_at_hotmail.com>
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 10.2.0.4 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.

thanks



Windows Live: Make it easier for your friends to see what you’re up to on Facebook. http://windowslive.com/Campaign/SocialNetworking?ocid=PID23285::T:WLMTAGL:ON:WL:en-US:SI_SB_facebook:082009
--
http://www.freelists.org/webpage/oracle-l
Received on Sun Aug 16 2009 - 22:24:29 CDT

Original text of this message