TWiki
>
LHCb Web
>
LHCbOnline
>
Oracle
>
Rsrc_alloc
(2007-10-17,
RaduStoica
)
(raw view)
E
dit
A
ttach
P
DF
---+++ Views used for resource management: * User accesible: <verbatim> V$RSRC_SESSION_INFO V$RSRC_CONSUMER_GROUP V$SESSION </verbatim> * DBA: <verbatim> DBA_USERS DBA_RSRC_CONSUMER_GROUPS DBA_RSRC_CONSUMER_GROUPS_PRIVS DBA_RSRC_PLAN_DIRECTIVES --displays directives for existing plans </verbatim> ---++++ Create a consumer group and make it the default for a user <verbatim> BEGIN dbms_resource_manager.clear_pending_area(); dbms_resource_manager.create_pending_area(); dbms_resource_manager.create_consumer_group(consumer_group => 'some_group', comment => '', cpu_mth => 'ROUND-ROBIN'); dbms_resource_manager.submit_pending_area(); END; BEGIN dbms_resource_manager_privs.grant_switch_consumer_group( grantee_name => 'test', consumer_group => 'some_group', grant_option => FALSE ); END; BEGIN dbms_resource_manager.set_initial_consumer_group( user => 'test', consumer_group => 'some_group' ); END; </verbatim> ---++++ Create a plan and activate it: <verbatim> BEGIN dbms_resource_manager.clear_pending_area(); dbms_resource_manager.create_pending_area(); dbms_resource_manager.create_plan( 'TEST_PLAN', ''); dbms_resource_manager.create_plan_directive( plan => 'some plan', group_or_subplan => 'TEST_GRP', comment => '', cpu_p1 => NULL, cpu_p2 => NULL, cpu_p3 => NULL, cpu_p4 => 100, cpu_p5 => NULL, cpu_p6 => NULL, cpu_p7 => NULL, cpu_p8 => NULL, parallel_degree_limit_p1 => NULL, active_sess_pool_p1 => NULL, queueing_p1 => NULL, switch_group => 'some other low priority group', switch_time => 600, switch_estimate => false, max_est_exec_time => NULL, undo_pool => NULL, max_idle_time => NULL, max_idle_blocker_time => NULL, switch_time_in_call => NULL ); -- add as many as required resource plans dbms_resource_manager.submit_pending_area(); END; alter system set resource_manager_plan='some plan' scope=both; </verbatim> -- Main.RaduStoica - 17 Oct 2007
E
dit
|
A
ttach
|
Watch
|
P
rint version
|
H
istory
: r2
<
r1
|
B
acklinks
|
V
iew topic
|
WYSIWYG
|
M
ore topic actions
Topic revision: r2 - 2007-10-17
-
RaduStoica
Log In
LHCb
LHCb Web
LHCb Web Home
Changes
Index
Search
LHCb webs
LHCbComputing
LHCb FAQs
LHCbOnline
LHCbPhysics
LHCbVELO
LHCbST
LHCbOT
LHCbRICH
LHCbMuon
LHCbTrigger
LHCbDetectorAlignment
LHCbTechnicalCoordination
LHCbUpgrade
Public webs
Public webs
ABATBEA
ACPP
ADCgroup
AEGIS
AfricaMap
AgileInfrastructure
ALICE
AliceEbyE
AliceSPD
AliceSSD
AliceTOF
AliFemto
ALPHA
ArdaGrid
ASACUSA
AthenaFCalTBAna
Atlas
AtlasLBNL
AXIALPET
CAE
CALICE
CDS
CENF
CERNSearch
CLIC
Cloud
CloudServices
CMS
Controls
CTA
CvmFS
DB
DefaultWeb
DESgroup
DPHEP
DM-LHC
DSSGroup
EGEE
EgeePtf
ELFms
EMI
ETICS
FIOgroup
FlukaTeam
Frontier
Gaudi
GeneratorServices
GuidesInfo
HardwareLabs
HCC
HEPIX
ILCBDSColl
ILCTPC
IMWG
Inspire
IPv6
IT
ItCommTeam
ITCoord
ITdeptTechForum
ITDRP
ITGT
ITSDC
LAr
LCG
LCGAAWorkbook
Leade
LHCAccess
LHCAtHome
LHCb
LHCgas
LHCONE
LHCOPN
LinuxSupport
Main
Medipix
Messaging
MPGD
NA49
NA61
NA62
NTOF
Openlab
PDBService
Persistency
PESgroup
Plugins
PSAccess
PSBUpgrade
R2Eproject
RCTF
RD42
RFCond12
RFLowLevel
ROXIE
Sandbox
SocialActivities
SPI
SRMDev
SSM
Student
SuperComputing
Support
SwfCatalogue
TMVA
TOTEM
TWiki
UNOSAT
Virtualization
VOBox
WITCH
XTCA
Welcome Guest
Login
or
Register
Cern Search
TWiki Search
Google Search
LHCb
All webs
Copyright &© 2008-2021 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
or Ideas, requests, problems regarding TWiki? use
Discourse
or
Send feedback