第25次：2015-03-24

botang

2015-03-24-a.sql：

1. select  * from v$asm_diskgroup;
   
2. 
   
3. select * from v$asm_alias  where group_number=3;
   
4. 
   
5. select  * from v$asm_attribute;
   
6. 
   
7. select  * from v$asm_template;
   
8. 
   
9. select  * from v$asm_client;
   
10. 
    
11. select  * from v$asm_file;
    
12. 
    
13. select   a.name ,   f.group_number ,  f.redundancy  , f.striped        from
    
14.    v$asm_file  f,  v$asm_alias  a  
    
15.    where f.file_number=a.file_number  and  f.group_number=a.group_number
    
16.     and  ( a.name  like 'MYTBS%'  or a.name like 'SYSTEM%'    or a.name   like 'TBS%')  ;
    
17.    
    
18.    
    

复制代码

2015-03-24-b.sql：

1. select  * from v$asm_file where group_number=3;
   
2. 
   
3. select  * from v$asm_alias where file_number in ( 256, 257)  and  group_number=3;
   
4. 
   
5. select * from v$asm_client where  group_number=3;
   
6. 
   
7. select  * from v$asm_disk;
   
8. 
   
9. select  * from v$asm_diskgroup;
   
10. 
    
11. select  * from v$asm_file where file_number in (269,270,272) and group_number=1;
    
12. 
    
13. 
    
14. select  * from v$asm_alias ;
    
15. 
    
16. 
    
17. select  * from v$asm_file where file_number in (273) and group_number=1;
    
18. 
    
19. select  * from v$asm_file where file_number in (299) and group_number=2;
    

复制代码