4 Replies Latest reply: Nov 23, 2012 6:34 PM by Aman.... RSS

    resource_manager_plan parameter

    871977
      Hi all,


      SQL> show parameter resource_manager_plan

      NAME TYPE VALUE
      ---------------------- ------- ------------------------------------------
      resource_manager_plan string SCHEDULER[0x2843]: DEFAULT_MAINTENANCE_PLAN

      What does [0x2843] mean?

      Thank you!
      Dan.
        • 1. Re: resource_manager_plan parameter
          Aman....
          Well, it's not there for me.
          SQL> conn / as sysdba
          Connected.
          SQL> select * from V$version;
          
          BANNER
          --------------------------------------------------------------------------------
          Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
          PL/SQL Release 11.2.0.1.0 - Production
          CORE    11.2.0.1.0      Production
          TNS for Linux: Version 11.2.0.1.0 - Production
          NLSRTL Version 11.2.0.1.0 - Production
          
          SQL> show parameter resource_manager
          
          NAME                                 TYPE        VALUE
          ------------------------------------ ----------- ------------------------------
          resource_manager_cpu_allocation      integer     2
          resource_manager_plan                string
          SQL> 
          What does [0x2843] mean?
          It looks like a hexadecimal value anyways.

          Aman....
          • 2. Re: resource_manager_plan parameter
            871977
            Thanks Aman...

            It's on Oracle database 11.1
            • 3. Re: resource_manager_plan parameter
              Osama_Mustafa
              http://bikubik.com/en/number-10307-0x002843.html
              • 4. Re: resource_manager_plan parameter
                Aman....
                I still think it shouldn't be an issue as the default resource plan is for the automated maintenance tasks that are available since 11.1 itself. Is it a persistent output from the show parameter command?

                Aman....