Re: Remote package access

From: Sybrand Bakker <sybrandb_at_hccnet.nl>
Date: Fri, 17 Dec 2004 06:44:56 +0100
Message-ID: <jfs4s01rdalb84hsef0gbftugmif548mr3@4ax.com>

On 16 Dec 2004 19:30:35 -0800, jiayng_at_yahoo.com (KelisaLee) wrote:

>Is the error caused by the database shared memory size?

Yes in the remote database
>Do you have any idea what is wrong?

Shared pool too small or fragmented

Any suggestion?

Increase the shared pool. Pin the package in the remote database, so it doesn't need to be validated on every call, by using dbms_shared_pool.keep('<owner>.<package>')

Thanks.

--
Sybrand Bakker, Senior Oracle DBA

Received on Thu Dec 16 2004 - 23:44:56 CST