AW: Profile or something to give higher priority

Hi Michael,

You could use consumer group switching with DBMS_RESOURCE_MANAGER for this. Here is an example, just that it is for the opposite way, switching to a lower group if a statement runs longer than 600 sec.:  

If a user logs on as member of the DSS_GROUP he will have 100% CP on level 1.

DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE
(PLAN => 'Day_Plan',

   GROUP_OR_SUBPLAN => 'DSS_GROUP',    CPU_P1 => 100, CPU_P2 => 0,    SWITCH_GROUP => 'LONGRUN_GROUP',                SWITCH_TIME_IN_CALL => 600);   . after 600 sec. he will be automatically switched into LONGRUN_GROUP.  

DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE
(PLAN => 'Day_Plan',

   GROUP_OR_SUBPLAN => 'LONGRUN_GROUP',    CPU_P1 => 0, CPU_P2 => 100);   .after finishing the top call the user will get switched back into the initial group in 10g,
in 9i not!!!  

Is this something you were dreaming of?

Hope it helps,

=;-)

Lutz Hartmann      

Von: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] Im Auftrag von Kline.Michael
Gesendet: Montag, 21. Mai 2007 21:24
An: oracle-l_at_freelists.org
Betreff: Profile or something to give higher priority  

Is there a way to assign a profile to a user of large batch jobs and maybe allow that to capture a higher priority to let a certain job or jobs to "slam through" even if it hurts some other users(a little).    

Michael Kline How
<mailto:Milo.Dalton_at_SunTrust.com;Dan.Divinski_at_SunTrust.com;Vivek.Gangal_at_SunT rust.com;Marissa.Porrello_at_SunTrust.com?subject=Michael%20Kline's%20Performan ce> am I doing?

Database Administration
SunTrust Banks, Inc.
Mail Code TOC-7505

1030 Wilmer Avenue
Richmond, Va. 23227
Tel: 804.261.9446 Net: 643.9446

BlackBerry: 804.517.7443

Cell: 804.744.1545
 <mailto:michael.kline_at_suntrust.com> michael.kline_at_suntrust.com  

Seeing beyond Money(sm)         

LEGAL DISCLAIMER
The information transmitted is intended solely for the individual or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you have received this email in error please contact the sender and delete the material from any computer.  

SunTrust and Seeing beyond money are federally registered service marks of SunTrust Banks, Inc.
[ST:XCL]

--
http://www.freelists.org/webpage/oracle-l