2 Replies Latest reply: Jul 1, 2013 1:54 AM by Hemant K Chitale RSS

    Keep Sequences in Shared Pool for RAC Environment

    VickySoni

      Hi,

       

             We have 2 node RAC setup for production environment. I want to pin cached sequences in my database. We are using following command for this purpose.

       

      EXEC DBMS_SHARED_POOL.KEEP('HR.MySeq','Q');

       

      Do I need to execute this command for each single node?