课程第60/61/62次（2017-10-13星期五，2017-10-15星期天上下午）

botang

1. select  s.TERMINAL  from v_$session s
   
2. where  s.CLIENT_INFO like '%XXXX%';
   
3. 
   
4. select  s.sid , s.CLIENT_INFO  from v_$session  s
   
5.   where s.PROGRAM  like '%rman%' and s.TERMINAL='pts/2';
   
6.   
   
7.   select  * from v$session_longops
   
8.    where sid in (68,71)
   
9.     and sofar <> totalwork;

复制代码

1. RMAN> run {
   
2. 2> set command id to 'XXXX';
   
3. 3> allocate channel c1 device type sbt ;
   
4. 4> allocate channel c2 device type sbt;
   
5. 5> backup tag 'CCC'  duration 00:06  minimize load    incremental level 0 ( datafile 1 channel c1 ) ( datafile 2,3,4,5,6,7 channel c2 )    ;
   
6. 6> }
   
7. 
   
8. executing command: SET COMMAND ID
   
9. 
   
10. released channel: ORA_SBT_TAPE_1
    
11. released channel: ORA_SBT_TAPE_2
    
12. allocated channel: c1
    
13. channel c1: SID=71 device type=SBT_TAPE
    
14. channel c1: Oracle Secure Backup
    
15. 
    
16. allocated channel: c2
    
17. channel c2: SID=68 device type=SBT_TAPE
    
18. channel c2: Oracle Secure Backup
    
19. 
    
20. Starting backup at 13-OCT-17
    
21. channel c2: starting incremental level 0 datafile backup set
    
22. channel c2: specifying datafile(s) in backup set
    
23. input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.265.957299129
    
24. input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.957299129
    
25. input datafile file number=00005 name=+DATA/orcl/datafile/example.256.957299129
    
26. input datafile file number=00004 name=+DATA/orcl/datafile/users.258.957299129
    
27. input datafile file number=00006 name=+DATA/orcl/datafile/tbsocp05_test2.268.957300945
    
28. input datafile file number=00007 name=+DATA/orcl/datafile/tbsocp05_test3.270.957300951
    
29. channel c2: starting piece 1 at 13-OCT-17
    
30. channel c1: starting incremental level 0 datafile backup set
    
31. channel c1: specifying datafile(s) in backup set
    
32. input datafile file number=00001 name=+DATA/orcl/datafile/system.259.957299129
    
33. channel c1: starting piece 1 at 13-OCT-17
    
34. 
    
35. 
    
36. 
    

复制代码

1. select  * from v$hm_check;
   
2. 
   
3. select  * from v$hm_check_param;
   
4. 
   
5. 
   
6. begin
   
7.    dbms_hm.run_check(check_name=>'Data Block Integrity Check',
   
8.       run_name => 'MYCHECK1',
   
9.     input_params => 'BLC_DF_NUM=5;BLC_BL_NUM=175');
   
10.    end;
    
11.    
    
12.    select  * from v$hm_run;
    
13.    
    
14.    select dbms_hm.get_run_report(run_name => 'MYCHECK1')  from dual;
    
15.    

复制代码

1. RMAN> backup  check logical   validate datafile 1 section size 100M ;

复制代码

1. select  * from v$diag_info;
   
2. 
   
3. 
   
4. select  * from dba_directories;
   
5. 
   
6. declare  
   
7. v_1 boolean;
   
8. begin
   
9.    v_1 := dbms_sqldiag.export_sql_testcase_dir_by_inc(
   
10.      incident_id => 39803,
    
11.      directory => 'DIR1');
    
12.      if v_1 = true
    
13.      then
    
14.         dbms_output.put_line('OK');
    
15.       end if;
    
16.   end;
    
17.   
    
18.   grant all on directory dir1  to scott;
    
19.      

复制代码

1. select object_id from dba_objects
   
2. where object_name='DEPARTMENTS'
   
3. and owner='HR';
   
4. 
   
5. select  * from tab$ where obj#=73928;
   
6. 
   
7. update tab$ set cols=1001  where obj#=73928;
   
8. 
   
9. --40990
   
10.   select  * from dba_sql_plan_baselines;
    
11. ---
    
12. select  sql_hash_value , sql_id  from v_$session s
    
13.   where s.TERMINAL='pts/2';
    
14. 
    
15. select  s.SQL_FULLTEXT, s.SQL_ID,s.HASH_VALUE,s.OLD_HASH_VALUE
    
16.   from v_$sql s  where sql_id='807ffkm1bmprg';
    
17.   
    
18. select  s.SQL_FULLTEXT, s.SQL_ID,s.HASH_VALUE,s.OLD_HASH_VALUE
    
19.   from v_$sqlarea  s  where sql_id='807ffkm1bmprg';
    
20.   
    
21. select  *
    
22. from v_$sql_plan sp   
    
23. where sp.SQL_ID='807ffkm1bmprg';
    
24. 
    

复制代码