This discussion is archived
4 Replies Latest reply: Nov 23, 2012 4:34 PM by Aman.... RSS

resource_manager_plan parameter

871977 Newbie
Currently Being Moderated
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.... Oracle ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    Thanks Aman...

    It's on Oracle database 11.1
  • 3. Re: resource_manager_plan parameter
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    http://bikubik.com/en/number-10307-0x002843.html
  • 4. Re: resource_manager_plan parameter
    Aman.... Oracle ACE
    Currently Being Moderated
    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....

Legend

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