关于提高 emoss 系统数据库磁盘IO性能的建议

目前的现状:
tms2006的表空间 147240MB  已使用 114051 MB

索引数据和业务数据都存放于此表空间上。

使用的数据文件如下:
SQL>select * from v$datafile;
/dev/vgora/rlvora_4g_001 至 rlvora_4g_039


逻辑卷组  vgora 的信息如下:
tmsdb1[/]# vgdisplay -v vgora

LV Name                     /dev/vgora/lvora_4g_001
   LV Status                   available/syncd          
   LV Size (Mbytes)            4096           
   Current LE                  128      
   Allocated PE                128        
   Used PV                     1      

......
......
......
......
LV Name                     /dev/vgora/lvora_4g_149
LV Status                   available/syncd          
LV Size (Mbytes)            4096           
Current LE                  128      
Allocated PE                128        
Used PV                     1   

   --- Physical volumes ---
   PV Name                     /dev/dsk/c6t0d2
   PV Name                     /dev/dsk/c8t0d2  Alternate Link
   PV Name                     /dev/dsk/c10t0d2 Alternate Link
   PV Name                     /dev/dsk/c12t0d2 Alternate Link
   PV Status                   available               
   Total PE                    6399   
   Free PE                     0      
   Autoswitch                  On       

   PV Name                     /dev/dsk/c6t0d3
   PV Name                     /dev/dsk/c8t0d3  Alternate Link
   PV Name                     /dev/dsk/c10t0d3 Alternate Link
   PV Name                     /dev/dsk/c12t0d3 Alternate Link
   PV Status                   available               
   Total PE                    6399   
   Free PE                     0      
   Autoswitch                  On       

   PV Name                     /dev/dsk/c6t0d4
   PV Name                     /dev/dsk/c8t0d4  Alternate Link
   PV Name                     /dev/dsk/c10t0d4 Alternate Link
   PV Name                     /dev/dsk/c12t0d4 Alternate Link
   PV Status                   available               
   Total PE                    6399   
   Free PE                     125    
   Autoswitch                  On       


物理卷组
         /dev/dsk/c6t0d2
         /dev/dsk/c6t0d3
         /dev/dsk/c6t0d4
的信息如下:
tmsdb1[/]#pvdisplay -v /dev/dsk/c6t0d2 |more

--- Physical volumes ---
PV Name                     /dev/dsk/c6t0d2
PV Name                     /dev/dsk/c8t0d2     Alternate Link
PV Name                     /dev/dsk/c10t0d2    Alternate Link
PV Name                     /dev/dsk/c12t0d2    Alternate Link
VG Name                     /dev/vgora
PV Status                   available               
Allocatable                 yes         
VGDA                        2  
Cur LV                      50    
PE Size (Mbytes)            32             
Total PE                    6399   
Free PE                     0      
Allocated PE                6399       
Stale PE                    0      
IO Timeout (Seconds)        default            
Autoswitch                  On       

   --- Distribution of physical volume ---
   LV Name                 LE of LV  PE for LV
   /dev/vgora/lvora_4g_001 128       128      
   /dev/vgora/lvora_4g_002 128       128      
   /dev/vgora/lvora_4g_003 128       128   
   ......
   ......
   ......
   /dev/vgora/lvora_4g_048 128       128      
   /dev/vgora/lvora_4g_049 128       128      
   /dev/vgora/lvora_4g_050 127       127 

   --- Physical extents ---
   PE   Status   LV                      LE  
   0000 current  /dev/vgora/lvora_4g_001 0000
   0001 current  /dev/vgora/lvora_4g_001 0001
   ......
   ......
   ......
   6395 current  /dev/vgora/lvora_4g_050 0123
   6396 current  /dev/vgora/lvora_4g_050 0124
   6397 current  /dev/vgora/lvora_4g_050 0125
   6398 current  /dev/vgora/lvora_4g_050 0126

tmsdb1[/]#pvdisplay -v /dev/dsk/c6t0d3 |more
   --- Physical volumes ---
PV Name                     /dev/dsk/c6t0d3
PV Name                     /dev/dsk/c8t0d3     Alternate Link
PV Name                     /dev/dsk/c10t0d3    Alternate Link
PV Name                     /dev/dsk/c12t0d3    Alternate Link
VG Name                     /dev/vgora
PV Status                   available               
Allocatable                 yes         
VGDA                        2  
Cur LV                      51    
PE Size (Mbytes)            32             
Total PE                    6399   
Free PE                     0      
Allocated PE                6399       
Stale PE                    0      
IO Timeout (Seconds)        default            
Autoswitch                  On       

   --- Distribution of physical volume ---
   LV Name                 LE of LV  PE for LV
   /dev/vgora/lvora_4g_050 1         1        
   /dev/vgora/lvora_4g_051 128       128      
   /dev/vgora/lvora_4g_052 128       128      
   ......
   ......
   ......
   /dev/vgora/lvora_4g_098 128       128      
   /dev/vgora/lvora_4g_099 128       128      
   /dev/vgora/lvora_4g_100 126       126      

   --- Physical extents ---
   PE   Status   LV                      LE  
   0000 current  /dev/vgora/lvora_4g_050 0127
   0001 current  /dev/vgora/lvora_4g_051 0000
   0002 current  /dev/vgora/lvora_4g_051 0001
   ......
   ......
   ......
   6396 current  /dev/vgora/lvora_4g_100 0123
   6397 current  /dev/vgora/lvora_4g_100 0124
   6398 current  /dev/vgora/lvora_4g_100 0125
  
tmsdb1[/]#pvdisplay -v /dev/dsk/c6t0d4 |more
   --- Physical volumes ---
PV Name                     /dev/dsk/c6t0d4
PV Name                     /dev/dsk/c8t0d4     Alternate Link
PV Name                     /dev/dsk/c10t0d4    Alternate Link
PV Name                     /dev/dsk/c12t0d4    Alternate Link
VG Name                     /dev/vgora
PV Status                   available               
Allocatable                 yes         
VGDA                       

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值