This discussion is archived
2 Replies Latest reply: Jun 30, 2013 11:54 PM by Hemant K Chitale RSS

Keep Sequences in Shared Pool for RAC Environment

VickySoni Newbie
Currently Being Moderated

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?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points