OraFAQ Forum: Server Administration » can't change the parameters resource_manager

Home » RDBMS Server » Server Administration » can't change the parameters resource_manager_plan (11.2.0.1.0)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

can't change the parameters resource_manager_plan [message #515372]

Mon, 11 July 2011 03:24

andy huang
Messages: 498
Registered: July 2011

Senior Member

Dear all,
I can not change the parameters RESOURCE_MANAGER_PLAN, at first, I set the parameters to DAYTIME,but when I restart my db,the parameters hold old values named MAXCAP_PLAN. Why?

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 32-bit Windows: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production

SQL> ALTER SYSTEM SET RESOURCE_MANAGER_PLAN = 'DAYTIME' scope=both;

System altered.

SQL> show parameters RESOURCE_MANAGER_PLAN;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
resource_manager_plan string DAYTIME
SQL> startup force
ORACLE instance started.

Total System Global Area 535662592 bytes
Fixed Size 1375792 bytes
Variable Size 415236560 bytes
Database Buffers 113246208 bytes
Redo Buffers 5804032 bytes
database mounted
database opened
SQL> show parameters RESOURCE_MANAGER_PLAN;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
resource_manager_plan string MAXCAP_PLAN

Report message to a moderator

Re: can't change the parameters resource_manager_plan [message #515373 is a reply to message #515372]

Mon, 11 July 2011 03:26

Michel Cadot
Messages: 68647
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Do NOT use "startup force", clean shut down.

Regards
Michel

Report message to a moderator

Re: can't change the parameters resource_manager_plan [message #515374 is a reply to message #515373]

Mon, 11 July 2011 03:37

andy huang
Messages: 498
Registered: July 2011

Senior Member

Hi,
The promble is appear also, when i shutdown and start the db, why?

SQL> show parameters resource_manager_plan;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
resource_manager_plan string MAXCAP_PLAN
SQL> show parameters resource_manager_plan;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
resource_manager_plan string MAXCAP_PLAN

SQL> ALTER SYSTEM SET RESOURCE_MANAGER_PLAN = 'DAYTIME' scope=both;
System altered.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 535662592 bytes
Fixed Size 1375792 bytes
Variable Size 415236560 bytes
Database Buffers 113246208 bytes
Redo Buffers 5804032 bytes
database mounted
database opened
SQL> show parameters resource_manager_plan;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
resource_manager_plan string MAXCAP_PLAN
SQL>

Report message to a moderator

Re: can't change the parameters resource_manager_plan [message #515376 is a reply to message #515374]

Mon, 11 July 2011 03:45

andy huang
Messages: 498
Registered: July 2011

Senior Member

Hi,
There are two values about parameters resource_manager_plan,How can I do if i want to use *DAYTIME*?

SQL> Column Sid format a10;
SQL> Column Name format a30;
SQL> Column Value format a30;
SQL> Select Sid,Name,Value From V$SPPARAMETER a
  2  Where a.name ='resource_manager_plan';
 
SID        NAME                           VALUE
---------- ------------------------------ ------------------------------
ORCL       resource_manager_plan          MAXCAP_PLAN
*          resource_manager_plan          DAYTIME

Report message to a moderator

Re: can't change the parameters resource_manager_plan [message #515378 is a reply to message #515376]

Mon, 11 July 2011 03:58

Michel Cadot
Messages: 68647
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

ALTER SYSTEM RESET RESOURCE_MANAGER_PLAN SCOPE=SPFILE SID='ORCL';
SHUTDOWN IMMEDIATE
STARTUP

CREATE PFILE=xxx FROM SPFILE;
Arrêt instance
modification du PFILE avec vi/notepad
STARTUP NOMOUNT PFILE=xxx;
CREATE SPFILE FROM PFILE=xxx;
SHUTDOWN
STARTUP

Regards
Michel

Report message to a moderator

Re: can't change the parameters resource_manager_plan [message #515379 is a reply to message #515378]

Mon, 11 July 2011 04:16

andy huang
Messages: 498
Registered: July 2011

Senior Member

Thanks!
The problem has solved specify sid='ORCL'!

Report message to a moderator

Previous Topic:	Kill many session
Next Topic:	rebuild index and recreate them

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Apr 28 03:09:02 CDT 2024