Monday, March 16, 2009

Apache Slow performance with NFS mount

Recently we have a slow performance with our web site after we redirect our OC4J Application logs to the NFS mount, which is using servlet to logs the application log.

Metalink :

Log Directories In NFS Mounted Device Environment Causes Performance Problem With Apache , Note: 180522.1

Bad performance of Apache when filesystem is NFS mounted, Note : 467315.1

Monday, March 09, 2009

Import DataPump : Error after importing PLS-00103 - compilation error

If you encounter error PLS-00103 while using import data pump to import data pump data into a new database with Oracle 10g but dont have problem if using the import and export utility . (imp/exp) .

Then most probably you encounter the bug in oracle 10g. If the source package/procedure... is wrapped and uses mulitbyte character set when using the import data pump, it add extra line behind the wrap.

To workaround this , 1)use the imp/exp tools. 2) manually edit the source code to removed the extra lines. 3) Find and get the bug fixed patch in the metalink.

Impdp Returns ORA-39082 When Importing Wrapped Procedures
Metalink Note :- 460267.1