TWiki> LHCb Web>LHCbOnline>Oracle>Rsrc_alloc (revision 1)EditAttachPDF

Views used for resource management:

  • User accesible:
V$RSRC_SESSION_INFO
V$RSRC_CONSUMER_GROUP
V$SESSION

  • DBA:
DBA_USERS
DBA_RSRC_CONSUMER_GROUPS
DBA_RSRC_CONSUMER_GROUPS_PRIVS

Create a consumer group and make it the default for a user

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;

Create a plan and make it default and active:

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 => 'SYSTEM_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
);
dbms_resource_manager.submit_pending_area();
END;

-- RaduStoica - 17 Oct 2007

Edit | Attach | Watch | Print version | History: r2 < r1 | Backlinks | Raw View | Raw edit | More topic actions...
Topic revision: r1 - 2007-10-17 - RaduStoica
 
    • Cern Search Icon Cern Search
    • TWiki Search Icon TWiki Search
    • Google Search Icon Google Search

    LHCb All webs login

This site is powered by the TWiki collaboration platform Powered by PerlCopyright & 2008-2019 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback