Admin 2. 13장 Managing Resources
Resourecs => 경합시 우선권 부여. -hr oltp consumer groups 으로 만들기. BEGIN dbms_resource_manager.clear_pending_area(); dbms_resource_manager.create_pending_area(); dbms_resource_manager.create_consumer_group(consumer_group => 'oltp', comment => '', cpu_mth => 'ROUND-ROBIN'); dbms_resource_manager.submit_pending_area(); BEGIN dbms_resource_manager_privs.grant_switch_consumer_group('HR', 'oltp', false); END;..
DataBase/Oracle
2012. 10. 18. 17:40