又是数据库服务器IO高引起的问题

         昨天整个系统慢,weblogic日志有大量stuck,数据库服务器IO负载高。取了数据库报告后发现了问题。

负载很高,平常DB Time最多1000.

Host NamePlatformCPUsCoresSocketsMemory (GB)
XXXXXXAIX-Based Systems (64-bit)12832 123.50

 Snap IdSnap TimeSessionsCursors/SessionInstances
Begin Snap:894001-12月-15 13:59:291263114.22
End Snap:894301-12月-15 16:19:14164896.02
Elapsed: 139.75 (mins)   
DB Time: 30,337.56 (mins)   

TOP等待事件都是IO

Top 10 Foreground Events by Total Wait Time

    EventWaitsTotal Wait Time (sec)Wait Avg(ms)% DB timeWait Class
    db file sequential read19,395,915512.6K2628.2User I/O
    read by other session9,753,486385.8K4021.2User I/O
    direct path read temp4,205,461310.7K7417.1User I/O
    direct path read1,886,691133.4K717.3User I/O
    DB CPU 86.1K 4.7 
    direct path write temp840,18261.9K743.4User I/O
    gc buffer busy acquire3,103,56858.2K193.2Cluster
    db file scattered read1,721,38155.1K323.0User I/O
    db file parallel read859,95533.5K391.8User I/O

    表XX_PURCHASE_CONTRACT_ITEM_MV物理读非常高,284623132*8/1024/1024=2171.5G的数据,在磁盘上读了这么多数据,当然,这个数字需要*2, 因为是RAC的数据库。

    Segments by Physical Reads

    • Total Physical Reads: 620,000,121
    • Captured Segments account for 52.3% of Total
    OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
    XXXXXWwwXX_PURCHASE_CONTRACT_ITEM_MV TABLE284,623,13245.91
    XXXXXWwwXX_PURCHASE_ITEMP0308TABLE PARTITION7,707,5431.24
    XXXXXWwwXX_PURCHASE_ITEMP0314TABLE PARTITION6,211,6671.00
    XXXXXWwwXX_PURCHASE_ITEMP0313TABLE PARTITION5,502,5120.89
    XXXXXWwwXX_PURCHASE_ITEMP0318TABLE PARTITION3,820,8040.62


    评论
    添加红包

    请填写红包祝福语或标题

    红包个数最小为10个

    红包金额最低5元

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

    抵扣说明:

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

    余额充值