课程第12次

secoug

活跃回话池：

1. ORA-07454: queue timeout, 5 second(s), exceeded

复制代码

1. SQL> conn / as sysdba
   
2. Connected.
   
3. SQL> @?/sqlplus/admin/plustrce.sql
   
4. SQL>
   
5. SQL> drop role plustrace;
   
6. drop role plustrace
   
7.           *
   
8. ERROR at line 1:
   
9. ORA-01919: role 'PLUSTRACE' does not exist
   
10. 
    
11. 
    
12. SQL> create role plustrace;
    
13. 
    
14. Role created.
    
15. 
    
16. SQL>
    
17. SQL> grant select on v_$sesstat to plustrace;
    
18. 
    
19. Grant succeeded.
    
20. 
    
21. SQL> grant select on v_$statname to plustrace;
    
22. 
    
23. Grant succeeded.
    
24. 
    
25. SQL> grant select on v_$mystat to plustrace;
    
26. 
    
27. Grant succeeded.
    
28. 
    
29. SQL> grant plustrace to dba with admin option;
    
30. 
    
31. Grant succeeded.
    
32. 
    
33. SQL>
    
34. SQL> set echo off
    
35. SQL>

复制代码

1. select s.sid, s."SERIAL#", s."USERNAME",s."TERMINAL",s."RESOURCE_CONSUMER_GROUP", s."STATUS"
   
2.   from v$session s
   
3.   where s."RESOURCE_CONSUMER_GROUP"='GROUP1';
   
4.   
   
5. alter system set resource_manager_plan=plan2;
   
6. 
   
7. select  * from v$rsrc_plan;
   
8. 
   
9. 
   
10. select s.sid, s."SERIAL#", s."USERNAME",s."TERMINAL",s."RESOURCE_CONSUMER_GROUP", s."STATUS"
    
11.   from v$session s
    
12.   where s."TERMINAL"='pts/3';
    
13.   

复制代码

1. alter user sh identified by oracle_4U account unlock;
   
2.   
   
3. select  * from dba_rsrc_plan_directives p where p.plan='PLAN2';
   
4. 
   
5. 
   
6. BEGIN
   
7. dbms_resource_manager.clear_pending_area();
   
8. dbms_resource_manager.create_pending_area();
   
9. dbms_resource_manager.set_consumer_group_mapping(
   
10.     dbms_resource_manager.client_machine,
    
11.     '192.168.0.42',
    
12.     'GROUP2'
    
13. );
    
14. dbms_resource_manager.submit_pending_area();
    
15. END;
    
16. 
    
17. 
    
18. BEGIN
    
19. dbms_resource_manager.clear_pending_area();
    
20. dbms_resource_manager.create_pending_area();
    
21. dbms_resource_manager.set_consumer_group_mapping_pri(
    
22.     EXPLICIT => 1,  CLIENT_MACHINE => 2,
    
23.     SERVICE_MODULE_ACTION => 3,
    
24.     SERVICE_MODULE => 4,
    
25.     MODULE_NAME_ACTION => 5,
    
26.     MODULE_NAME => 6,
    
27.     SERVICE_NAME => 7,
    
28.     ORACLE_USER => 8,
    
29.     CLIENT_PROGRAM => 9,
    
30.     CLIENT_OS_USER => 10
    
31. );
    
32. dbms_resource_manager.submit_pending_area();
    
33. END;
    
34. 
    
35. select  * from dba_rsrc_group_mappings;
    
36. 
    
37. select  * from dba_rsrc_mapping_priority;
    
38. 
    
39. 
    
40. select s.sid, s."SERIAL#", s."USERNAME",s."TERMINAL",s."RESOURCE_CONSUMER_GROUP", s."STATUS",s."MACHINE",s."OSUSER",s."PROGRAM"
    
41.   from v$session s
    
42.   where s."USERNAME"='SYS';

复制代码