29-1:
	BEGIN
	  dbms_resource_manager.create_pending_area();
	  dbms_resource_manager.create_plan('DAY','OLTPƻ');
	END;
	/
29-2:
	BEGIN
	  dbms_resource_manager.create_consumer_group('GROUP1','1');
	  dbms_resource_manager.create_consumer_group('GROUP2','2');
	  dbms_resource_manager.create_consumer_group('GROUP3','3');
	END;
	/
29-3:
	BEGIN
	  dbms_resource_manager.create_plan_directive('DAY','SYS_GROUP','...',cpu_p1=>100,parallel_degree_limit_p1=>10);
	  dbms_resource_manager.create_plan_directive('DAY','GROUP1','...',cpu_p2=>60,active_sess_pool_p1=>2,queueing_p1=>600);
	  dbms_resource_manager.create_plan_directive('DAY','GROUP2','...',cpu_p2=>30,max_est_exec_time=>100,undo_pool=>100);
	  dbms_resource_manager.create_plan_directive('DAY','GROUP3','...',cpu_p2=>10,max_idle_time=>300);
	  dbms_resource_manager.create_plan_directive('DAY','OTHER_GROUPS','...',cpu_p3=>100);
	  dbms_resource_manager.validate_pending_area();
	  dbms_resource_manager.submit_pending_area();
	END;
	/
29-4:
	BEGIN
	  dbms_resource_manager_privs.grant_switch_consumer_group('SCOTT','GROUP1',FALSE);
	  dbms_resource_manager_privs.grant_switch_consumer_group('SCOTT','GROUP2',FALSE);
	  dbms_resource_manager_privs.grant_switch_consumer_group('SCOTT','GROUP3',FALSE);
	  dbms_resource_manager.set_initial_consumer_group('SCOTT','GROUP1');
	END;
	/
29-5:
	ALTER SYSTEM SET RESOURCE_MANAGER_PLAN=DAY;
29-6:
	SELECT sid,serial# FROM v$session WHERE username='SCOTT';
	exec dbms_resource_manager.switch_consumer_group_for_sess(142,63,'GROUP2')
29-7:
	BEGIN
	  FOR i IN 1..100000 LOOP
	    INSERT INTO temp VALUES(i);
	  END LOOP;
	END;
	/





