Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Incredible ! Oracle HELP PLEASE !

Re: Incredible ! Oracle HELP PLEASE !

From: Christian GILBERT <externe.gilbert_at_francetelecom.com>
Date: Thu, 27 Jun 2002 15:06:35 GMT
Message-ID: <1105_1025190395@10.193.118.17>


Sur Thu, 27 Jun 2002 12:55:01 +0200, "Oscar" <oscar_ll_at_jofre.com> a écrit:
> what does it means ? How can I used. With NOCACHE still with problems.

> pin the sequence using DBMS_SHARED_POOL.KEEP

connect sys (or internal)

SQL>exec dbms_shared_pool.keep('owner.sequence','Q');

For more infos, please refer to the Oracle documentation : Supplied PL/SQL packages reference

Christian GILBERT
SNPI DTO/SGBD Oracle
01 55 88 41 21 Received on Thu Jun 27 2002 - 10:06:35 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US