Sponsored Content
Top Forums UNIX for Advanced & Expert Users raid 0+1 +oracle getting slow data reads. Post 35937 by Optimus_P on Wednesday 14th of May 2003 12:53:23 PM
Old 05-14-2003
Code:
VMSTAT (db off)
---------------
procs     memory            page            disk          faults      cpu
 r b w   swap  free  si  so pi po fr de sr m1 m1 m1 m2   in   sy   cs us sy id
 0 0 0 2566232 1532960 0  0  0  0  0  0  0  0  0  0  0  709  233  435  0  0 100
 0 0 0 2566232 1532960 0  0  0  0  0  0  0  9  9  9  0  680  191  328  0  1 99
 0 0 0 2566232 1532960 0  0  0  0  0  0  0  0  0  0  0  722  244  472  0  0 100
 0 0 0 2566232 1532960 0  0  0  0  0  0  0  0  0  0  0  632  198  307  0  0 100
 0 0 0 2566232 1532960 0  0  0  0  0  0  0  0  0  0  0  719  256  448  0  0 100
 0 0 0 2566232 1532960 0  0  0  0  0  0  0  0  0  0  0  636  351  298  0  0 100
 0 0 0 2566328 1532912 0  0  0  0  0  0  0  0  0  0  0  710  449  447  0  0 99
 0 0 0 2566640 1533080 0  0  0  0  0  0  0  0  0  0  0  641  247  297  0  0 100
 0 0 0 2566640 1533080 0  0  0  0  0  0  0  0  0  0  0  702  282  414  0  1 99
 0 0 0 2566848 1533288 0  0  0  0  0  0  0  0  0  0  0  621  196  277  0  0 100
 0 0 0 2566848 1533288 0  0  0  0  0  0  0  0  0  0  0  708  233  422  0  0 100
 0 0 0 2566848 1533288 0  0  0  0  0  0  0  0  0  0  0  626  181  271  0  0 100
 0 0 0 2566848 1533288 0  0  0  0  0  0  0  0  0  0  0  705  244  437  0  0 100
 0 0 0 2566848 1533288 0  0  0  0  0  0  0  0  0  0  0  624  191  266  0  1 99
 0 0 0 2566848 1533288 0  0  0  0  0  0  0  0  0  0  0  709  227  422  0  0 100
 0 0 0 2566848 1533288 0  0  0  0  0  0  0  0  0  0  0  621  184  273  0  0 100
 0 0 0 2566848 1533288 0  0  0  0  0  0  0 11 11 11  0  766  249  467  0  1 99
 0 0 0 2566848 1533288 0  0  0  0  0  0  0  0  0  0  0  626  191  279  0  0 100
 0 0 0 2566848 1533288 0  0  0  0  0  0  0  0  0  0  0  718  261  442  0  0 100


VMSTAT (db on)
------
procs     memory            page            disk          faults      cpu
 r b w   swap  free  si  so pi po fr de sr m1 m1 m1 m2   in   sy   cs us sy id
 0 0 0 2230728 1293048 0  0 1013 0 0  0  0  2  2  4  0 1725 8502 1838 12  4 84

 procs     memory            page            disk          faults      cpu
 r b w   swap  free  si  so pi po fr de sr m1 m1 m1 m2   in   sy   cs us sy id
 0 0 0 1968392 1002600 0  0 60  0  0  0  0  0  0  0  0 1630 11978 1870 14 4 82
 0 1 0 1968392 1002784 0  0 64  0  0  0  0 17 17 17  0 1610 8593 1924 10  5 84
 0 1 0 1968392 1003176 0  0 44  0  0  0  0  0  0  0  0 1501 7437 1724 25  2 72
 0 1 0 1969616 1004624 0  0 52  0  0  0  0  0  0  0  0 1480 7190 1768 12  3 85
 0 1 0 1969616 1004560 0  0 52  0  0  0  0  0  0  0  0 1477 7879 1747  9  3 88
 0 1 0 1969616 1004440 0  0 40  0  0  0  0  0  0  0  0 1490 10292 1812 13 3 84
 0 0 0 1969368 1004136 0  0 64  0  0  0  0  0  0  0  0 1374 9334 1655 10  4 85
 0 1 0 1969392 1004104 0  0 48  0  0  0  0  0  0  0  0 1467 7607 1795  8  3 89
 0 0 0 1969392 1003848 0  0 60  0  0  0  0  0  0  0  0 1408 7123 1688  8  3 89
 0 0 0 1969600 1003936 0  0 112 0  0  0  0  0  0  0  0 1478 7420 1795 10  3 86
 0 1 0 1969600 1003880 0  0 96  0  0  0  0  0  0  0  0 1384 8641 1583 21  3 76
 0 1 0 1969600 1003808 0  0 88  0  0  0  0  0  0  0  0 1450 11136 1747 12 5 83
 0 0 0 1969600 1003736 0  0 92  0  0  0  0  0  0  0  0 1318 6942 1526  8  2 90
 0 1 0 1969600 1003592 0  0 64  0  0  0  0  0  0  0  0 1521 7547 1864  8  3 89
 0 1 0 1969600 1003496 0  0 96  0  0  0  0  0  0  0  0 1398 7539 1670  9  3 87
 0 1 0 1969856 1003552 0  0 60  4  0  0  0  0  0  0  0 1392 5949 1702  7  3 90
 0 0 0 1970120 1003544 0  0 96  0  0  0  0 12 12 12  0 1439 11012 1663 14 5 81
 0 2 0 1970120 1003424 0  0 76  0  0  0  0  0  0  0  0 1447 7258 1752  8  2 90
 0 1 0 1970120 1003200 0  0 136 0  0  0  0  0  0  0  0 1420 7491 1669  8  4 88
 procs     memory            page            disk          faults      cpu
 r b w   swap  free  si  so pi po fr de sr m1 m1 m1 m2   in   sy   cs us sy id
 0 1 0 1970120 1004048 0  0 1200 0 0  0  0  0  0  0  0 1587 7442 1897  9  2 89
 0 0 0 1970072 1004744 0  0 136 0  0  0  0  0  0  0  0 1532 7453 1798 28  5 67
 0 1 0 1970072 1004560 0  0 132 0  0  0  0  0  0  0  0 1549 12202 1903 16 4 80
 0 2 0 1970704 1004888 0  0 140 0  0  0  0  0  0  0  0 1568 7905 1931  8  2 90
 0 2 0 1970704 1004768 0  0 112 0  0  0  0  0  0  0  0 1433 6897 1746  7  2 92
 0 1 0 1970704 1004712 0  0 120 0  0  0  0  0  0  0  0 1354 6887 1568  8  3 89
 0 1 0 1970704 1004864 0  0 1504 0 0  0  0  0  0  0  0 1428 7389 1649 16  3 81
 0 2 0 1970704 1006592 0  0 272 0  0  0  0  0  0  0  0 1330 9447 1518 13  4 83
 0 2 0 1970384 1006152 0  0 232 0  0  0  0  0  0  0  0 1467 8473 1801 10  3 88
 0 0 0 1970072 1005936 0  0 124 0  0  0  0  0  0  0  0 1395 7050 1648  8  3 89
 0 1 0 1970072 1005720 0  0 108 0  0  0  0  0  0  0  0 1555 7466 1947  8  3 89
 0 0 0 1970072 1005528 0  0 148 0  0  0  0  0  0  0  0 1510 8143 1843  9  3 88
 0 1 0 1970704 1005856 0  0 140 0  0  0  0 12 12 12  0 1608 7829 1982  8  5 87
 0 0 0 1970704 1005744 0  0 212 0  0  0  0  0  0  0  0 1918 12833 2175 17 5 78
 0 0 0 1970664 1005712 0  0 172 0  0  0  0  0  0  0  0 2500 11230 2846 8  5 86
 0 1 0 1970664 1005576 0  0 236 0  0  0  0  0  0  0  0 2474 11241 2787 11 4 85
 0 1 0 1970664 1005472 0  0 176 0  0  0  0  0  0  0  0 2052 9557 2367  9  3 87
 0 0 0 1970456 1005120 0  0 204 0  0  0  0  0  0  0  0 1353 6934 1616  7  4 88
 0 0 0 1970240 1004808 0  0 220 0  0  0  0  0  0  0  0 1500 11362 1804 14 4 82



IOSTAT (-Cxnz)
-------------
 r/s    w/s   kr/s   kw/s wait actv wsvc_t asvc_t  %w  %b device
   11.5  142.0  632.0  911.7  0.0  1.2    0.0    7.7   0 106 c1
   10.5  142.0  476.0  911.8  0.0  1.2    0.0    7.7   0 106 c2
   15.0  142.0 1108.0  911.7  0.0  1.4    0.0    9.1   0  97 d100
    7.5  142.0  632.0  911.7  0.0  1.2    0.0    7.8   0  86 d101
    7.5  142.0  476.0  911.7  0.0  1.2    0.0    7.7   0  85 d102
    3.0   32.5  220.0  260.0  0.0  0.3    0.0    7.3   0  23 c1t1d0
    2.5   60.0  120.0  278.2  0.0  0.5    0.0    7.9   0  45 c1t2d0
    3.0   29.0  196.0  209.5  0.0  0.2    0.0    7.6   0  21 c1t8d0
    3.0   20.5   96.0  164.0  0.0  0.2    0.0    8.0   0  17 c1t9d0
    2.0   32.5   88.0  260.0  0.0  0.2    0.0    7.1   0  21 c2t1d0
    2.5   60.0  112.0  278.3  0.0  0.5    0.0    8.1   0  47 c2t2d0
    3.5   29.0   56.0  209.5  0.0  0.3    0.0    7.7   0  22 c2t8d0
    2.5   20.5  220.0  164.0  0.0  0.2    0.0    7.5   0  17 c2t9d0
                    extended device statistics
    r/s    w/s   kr/s   kw/s wait actv wsvc_t asvc_t  %w  %b device
   13.5  146.0  752.1  902.3  0.0  1.3    0.0    8.0   0 115 c1
   13.0  142.0  580.1  900.3  0.0  1.2    0.0    7.5   0 106 c2
   16.5  141.0 1332.1  899.8  0.0  1.4    0.2    9.0   3  97 d100
    8.0  141.0  752.1  899.8  0.0  1.2    0.0    7.8   0  86 d101
    8.5  141.0  580.1  899.8  0.0  1.1    0.0    7.5   0  84 d102
    0.0    1.0    0.0    0.5  0.0  0.0    0.0    7.5   0   1 c1t0d0
    4.0   32.0  216.0  241.0  0.0  0.3    0.0    8.1   0  26 c1t1d0
    3.0   25.5  200.0  189.0  0.0  0.3    0.0    8.9   0  23 c1t2d0
    3.0   60.5  204.0  255.8  0.0  0.5    0.0    7.7   0  44 c1t8d0
    3.5   27.0  132.0  216.0  0.0  0.2    0.0    7.8   0  21 c1t9d0
    0.0    1.0    0.0    0.5  0.0  0.0    0.0    6.6   0   1 c2t0d0
    3.0   30.0   56.0  240.0  0.0  0.2    0.0    6.4   0  20 c2t1d0
    4.0   23.5  176.0  188.0  0.0  0.2    0.0    8.3   0  20 c2t2d0
    3.0   60.5  160.0  255.8  0.0  0.5    0.0    8.0   0  46 c2t8d0
    3.0   27.0  188.0  216.0  0.0  0.2    0.0    6.9   0  19 c2t9d0
                    extended device statistics
    r/s    w/s   kr/s   kw/s wait actv wsvc_t asvc_t  %w  %b device
    8.5  147.5  428.0  898.7  0.0  1.2    0.0    7.5   0 107 c1
    6.5  146.0  288.0  901.7  0.0  1.0    0.0    6.9   0  97 c2
    0.0    0.5    0.0    4.0  0.0  0.0    0.0   15.1   0   1 d30
    0.0    0.5    0.0    4.0  0.0  0.0    0.0   10.4   0   1 d31
    0.0    0.5    0.0    4.0  0.0  0.0    0.0   15.1   0   1 d32
   10.5  145.0  716.0  893.7  0.0  1.3    0.1    8.3   2  95 d100
    5.5  145.0  428.0  893.7  0.0  1.1    0.0    7.3   0  85 d101
    5.0  145.5  288.0  897.7  0.0  1.0    0.0    6.9   0  81 d102
    0.0    0.5    0.0    4.0  0.0  0.0    0.0   15.0   0   1 c1t0d0
    2.0   23.0  104.0  176.5  0.0  0.2    0.0    7.6   0  17 c1t1d0
    1.5   35.5  108.0  276.5  0.0  0.3    0.0    7.1   0  25 c1t2d0
    2.0   62.0   60.0  229.7  0.0  0.5    0.0    7.6   0  45 c1t8d0
    3.0   26.5  156.0  212.0  0.0  0.2    0.0    7.5   0  20 c1t9d0
    0.0    0.5    0.0    4.0  0.0  0.0    0.0   10.4   0   1 c2t0d0
    1.5   22.0  116.0  176.0  0.0  0.2    0.0    6.6   0  14 c2t1d0
    1.5   34.5   16.0  276.0  0.0  0.2    0.0    6.4   0  21 c2t2d0
    1.5   62.5   72.0  233.7  0.0  0.4    0.0    6.9   0  42 c2t8d0
    2.0   26.5   84.0  212.0  0.0  0.2    0.0    7.6   0  19 c2t9d0
                    extended device statistics
    r/s    w/s   kr/s   kw/s wait actv wsvc_t asvc_t  %w  %b device
    6.5  140.0  372.0  872.9  0.0  1.1    0.0    7.5   0  99 c1
    7.5  138.0  656.0  864.4  0.0  1.1    0.0    7.4   0  98 c2
   13.5  138.5 1027.9  868.5  0.0  1.4    0.1    8.9   2  97 d100
    6.5  139.0  372.0  872.5  0.0  1.1    0.0    7.4   0  84 d101
    7.0  138.0  656.0  864.5  0.0  1.1    0.0    7.4   0  82 d102
    3.5   26.0  152.0  204.2  0.0  0.2    0.0    6.8   0  18 c1t1d0
    0.5   20.5   64.0  160.2  0.0  0.1    0.0    6.7   0  14 c1t2d0
    1.5   62.5   76.0  260.5  0.0  0.5    0.0    7.6   0  46 c1t8d0
    1.0   31.0   80.0  248.0  0.0  0.3    0.0    8.4   0  22 c1t9d0
    1.5   25.5   72.0  204.0  0.0  0.2    0.0    6.1   0  16 c2t1d0
    2.0   20.0  252.0  160.0  0.0  0.2    0.0    7.2   0  15 c2t2d0
    2.5   61.5  200.0  252.5  0.0  0.5    0.0    7.7   0  45 c2t8d0
    1.5   31.0  132.0  248.0  0.0  0.3    0.0    7.9   0  22 c2t9d0

 

7 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Howto capture data from rs232port andpull data into oracle database-9i automatically

Hi, i willbe very much grateful to u if u help me out.. if i simply connect pbx machine to printer by serial port RS232 then we find this view: But i want to capture this data into database automatically when the pbx is running.The table in database will contain similar to this view inthe... (1 Reply)
Discussion started by: boss
1 Replies

2. Shell Programming and Scripting

Get data from 3 differrnt oracle DB & then compare data

Hi All, I have a requirement to write a shell script for the following... we have 3 different database.... lets say A, B, C From these 3 DBs, i need to get data.. all have 3 different table...a,b, c A.a => Emp_code, count(*) B.b => emp_code, count(*) C.c => emp_code, copunt(*) Once get this... (4 Replies)
Discussion started by: Amit.Sagpariya
4 Replies

3. Red Hat

Recover RAID data

Hello, Given a scenario, I have 2 HDD which were used on the server with software RAID. Now, the original server crashed and I have attached these 2 HDD to the new server. Any possible chances to recover the data from any of this HDD ? I want to mount /dev/sdb3 on some folder.. Output of... (3 Replies)
Discussion started by: chinmay
3 Replies

4. AIX

ORACLE Database running slow on AIX ( nmon / topas )

Hello, How can I know if ORACLE Database is running slow due to Memory or due to processing power ? I have only Oracle Database running on a P4 with 4GB RAM. Could anyone suggest any tools which can help me determine exactly if it is memory issue or processor issue. (43 Replies)
Discussion started by: filosophizer
43 Replies

5. AIX

SCSI PCI - X RAID Controller card RAID 5 AIX Disks disappeared

Hello, I have a scsi pci x raid controller card on which I had created a disk array of 3 disks when I type lspv ; I used to see 3 physical disks ( two local disks and one raid 5 disk ) suddenly the raid 5 disk array disappeared ; so the hardware engineer thought the problem was with SCSI... (0 Replies)
Discussion started by: filosophizer
0 Replies

6. UNIX for Dummies Questions & Answers

Difference between buffered disk reads and cached reads?

I was analyzing the Disk read using hdparm utility. This is what i got as a result. # hdparm -t /dev/sda /dev/sda: Timing buffered disk reads: 108 MB in 3.04 seconds = 35.51 MB/sec # hdparm -T /dev/sda /dev/sda: Timing cached reads: 3496 MB in 1.99 seconds = 1756.56 MB/sec... (1 Reply)
Discussion started by: pinga123
1 Replies

7. Red Hat

RAID Configuration for IBM Serveraid-7k SCSI RAID Controller

Hello, I want to delete a RAID configuration an old server has. Since i haven't the chance to work with the specific raid controller in the past can you please help me how to perform the configuraiton? I downloaded IBM ServeRAID Support CD but i wasn't able to configure the video card so i... (0 Replies)
Discussion started by: @dagio
0 Replies
All times are GMT -4. The time now is 06:18 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy