AW: Profile or something to give higher priority
- From: "Lutz Hartmann" <lutz.hartmann@xxxxxxxxx>
- To: <Michael.Kline@xxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 21 May 2007 22:05:30 +0200
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] Im
Auftrag von Kline.Michael
Gesendet: Montag, 21. Mai 2007 21:24
An: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxx;Dan.Divinski@xxxxxxxxxxxx;Vivek.Gangal@SunT
rust.com;Marissa.Porrello@xxxxxxxxxxxx?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@xxxxxxxxxxxx> michael.kline@xxxxxxxxxxxx
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]
Other related posts:
- » AW: Profile or something to give higher priority
