Oracle 10G on Solaris 10 June 06 - SUN

This is a discussion on Oracle 10G on Solaris 10 June 06 - SUN ; Can I ask if anyone of you here encounter the similar problem/scneario before? We have set a project for the Oracle Install. And, we assign this project to the user"oracle" in /etc/user_attr. The V890 we have has 16GB physical RAM, ...

+ Reply to Thread
Results 1 to 2 of 2

Thread: Oracle 10G on Solaris 10 June 06

  1. Oracle 10G on Solaris 10 June 06

    Can I ask if anyone of you here encounter the similar problem/scneario
    before?

    We have set a project for the Oracle Install. And, we assign this
    project to the user"oracle" in /etc/user_attr. The V890 we have has
    16GB physical RAM, and we assign 12GB for the shm-max.

    oracle
    projid : 100
    comment: ""
    users : (none)
    groups : (none)
    attribs: process.max-sem-nsems=(priv,1024,deny)
    project.max-sem-ids=(priv,1024,deny)
    project.max-shm-ids=(priv,1024,deny)
    project.max-shm-memory=(priv,12884901888,deny)

    Oracle starts up fine. It runs, but, our DBA and me (the sysadmin)
    worries about the memory usage of it. Whenever we run TOP, the
    available memory is very low. We wonder where those memory goes?! And,
    can anyone suggest where else i can look at to prove that the OS/
    System is ok? Any help - much appreicated

    top: version 3.5.1
    load averages: 0.14, 0.11, 0.09 13:01:29
    204 processes: 202 sleeping, 1 zombie, 1 on cpu

    Memory: 16G real, 829M free, 2888M swap in use, 32G swap free


    PID USERNAME LWP PRI NICE SIZE RES STATE TIME CPU COMMAND
    24016 oracle 1 59 0 1470M 1437M sleep 0:06 0.16% oracle
    18797 oracle 11 59 0 1478M 1442M sleep 0:37 0.13% oracle
    23315 oracle 1 59 0 543M 474M sleep 0:11 0.03% oracle
    5253 appworx 76 59 0 169M 60M sleep 13:40 0.03% java
    2667 oracle 1 59 0 1471M 1423M sleep 7:53 0.02% oracle
    24573 melvinw 1 49 0 2912K 1664K cpu/17 0:00 0.02% top
    10671 oracle 1 59 0 1475M 1441M sleep 0:06 0.02% oracle
    1130 netconne 14 59 0 9024K 4968K sleep 1:32 0.01% srsproxy
    2692 oracle 29 29 10 233M 81M sleep 6:12 0.01% java
    3398 oracle 24 29 10 218M 69M sleep 5:24 0.01% java
    2711 oracle 1 59 0 1473M 1424M sleep 4:02 0.01% oracle
    122 root 13 59 0 8352K 4072K sleep 3:50 0.01% picld
    2617 oracle 1 59 0 1471M 1414M sleep 3:38 0.01% oracle
    3223 oracle 1 59 0 543M 441M sleep 3:16 0.01% oracle
    2607 oracle 11 59 0 1473M 1407M sleep 3:02 0.01% oracle

    I ran vmstat, sar before. There is not much going on for si/so, and sr
    mostly stays at 0.

    VMStat
    kthr memory page disk faults
    cpu
    r b w swap free si so pi po fr de sr m0 m1 m3 m4 in sy cs
    us sy id
    0 0 0 33359288 878272 0 0 257 0 0 0 0 6 0 0 0 691 1787 1426
    0 1 99
    0 0 0 33359288 878256 0 0 2 0 0 0 0 0 0 0 0 702 1610 1183
    0 0 99
    0 0 0 33359288 878256 0 0 27 2 2 0 0 3 0 0 0 594 3188 1277
    1 1 98
    0 0 0 33359288 878248 0 0 24 6 6 0 0 0 0 2 0 667 2525 1428
    0 1 99
    0 0 0 33359088 878040 0 0 53 2 2 0 0 2 0 0 0 722 1856 1485
    1 1 99
    0 0 0 33359384 878304 0 0 18 0 0 0 0 2 0 0 0 709 1719 1288
    1 1 98
    0 0 0 33359416 878288 0 0 22 0 0 0 0 0 0 0 0 718 1446 1421
    0 1 99
    0 0 0 33359416 878232 0 0 126 0 0 0 0 2 0 0 0 756 1606 1303
    0 0 99
    0 0 0 33359416 878224 0 0 19 0 0 0 0 2 0 0 0 670 1662 1263
    0 1 99
    0 0 0 33358472 877128 0 0 46 2 2 0 0 5 0 1 0 686 4545 1424
    1 1 98
    0 0 0 33359416 878216 0 0 2 0 0 0 0 0 0 0 0 650 1278 1332
    0 0 99
    0 0 0 33359416 878216 0 0 32 0 0 0 0 4 0 0 0 578 2970 1224
    1 1 98
    0 0 0 33359184 877992 0 0 8 0 0 0 0 1 0 0 0 1011 4994 1779
    1 1 98
    0 0 0 33358904 877696 0 0 5 0 0 0 0 12 0 0 0 816 1807 1435
    0 1 99
    0 0 0 33358096 877144 0 0 22 0 0 0 0 2 0 0 0 687 1884 1269
    0 1 99
    0 0 0 33358904 877688 0 0 2 3 3 0 0 0 0 1 0 694 2633 1448
    0 1 99
    0 0 0 33358536 877320 0 0 61 2 2 0 0 2 0 0 0 1490 2799 2088
    1 1 98
    0 0 0 33357104 875848 0 0 14 0 0 0 0 2 0 0 0 704 1556 1440
    0 1 99
    0 0 0 33357032 875776 0 0 8 0 0 0 0 0 0 0 0 664 1410 1360
    0 0 99

    SAR
    SunOS xxxx 5.10 Generic_118833-24 sun4u 05/22/2007

    12:48:17 swpin/s bswin/s swpot/s bswot/s pswch/s
    12:48:22 0.00 0.0 0.00 0.0 1402
    12:48:27 0.00 0.0 0.00 0.0 1622
    12:48:32 0.00 0.0 0.00 0.0 1367
    12:48:37 0.00 0.0 0.00 0.0 1464
    12:48:42 0.00 0.0 0.00 0.0 1390

    Average 0.00 0.0 0.00 0.0 1449


  2. Re: Oracle 10G on Solaris 10 June 06

    On 22 May 2007, perry811 wrote:

    : Can I ask if anyone of you here encounter the similar problem/scneario
    : before?
    : We have set a project for the Oracle Install. And, we assign this
    : project to the user"oracle" in /etc/user_attr. The V890 we have has
    : 16GB physical RAM, and we assign 12GB for the shm-max.
    : oracle
    : projid : 100
    : comment: ""
    : users : (none)
    : groups : (none)
    : attribs: process.max-sem-nsems=(priv,1024,deny)
    : project.max-sem-ids=(priv,1024,deny)
    : project.max-shm-ids=(priv,1024,deny)
    : project.max-shm-memory=(priv,12884901888,deny)
    : Oracle starts up fine. It runs, but, our DBA and me (the sysadmin)
    : worries about the memory usage of it. Whenever we run TOP, the
    : available memory is very low. We wonder where those memory goes?! And,
    : can anyone suggest where else i can look at to prove that the OS/
    : System is ok? Any help - much appreicated
    :
    : top: version 3.5.1

    I wouldnt use "top" prstat is 'better' - but I wouldnt get rid of top
    either..

    Try: prstat -a -s size

    : load averages: 0.14, 0.11, 0.09 13:01:29
    : 204 processes: 202 sleeping, 1 zombie, 1 on cpu
    : Memory: 16G real, 829M free, 2888M swap in use, 32G swap free
    : PID USERNAME LWP PRI NICE SIZE RES STATE TIME CPU COMMAND
    : 24016 oracle 1 59 0 1470M 1437M sleep 0:06 0.16% oracle
    : 18797 oracle 11 59 0 1478M 1442M sleep 0:37 0.13% oracle
    : 23315 oracle 1 59 0 543M 474M sleep 0:11 0.03% oracle
    : 5253 appworx 76 59 0 169M 60M sleep 13:40 0.03% java
    : 2667 oracle 1 59 0 1471M 1423M sleep 7:53 0.02% oracle
    : 24573 melvinw 1 49 0 2912K 1664K cpu/17 0:00 0.02% top
    : 10671 oracle 1 59 0 1475M 1441M sleep 0:06 0.02% oracle
    : 1130 netconne 14 59 0 9024K 4968K sleep 1:32 0.01% srsproxy
    : 2692 oracle 29 29 10 233M 81M sleep 6:12 0.01% java
    : 3398 oracle 24 29 10 218M 69M sleep 5:24 0.01% java
    : 2711 oracle 1 59 0 1473M 1424M sleep 4:02 0.01% oracle
    : 122 root 13 59 0 8352K 4072K sleep 3:50 0.01% picld
    : 2617 oracle 1 59 0 1471M 1414M sleep 3:38 0.01% oracle
    : 3223 oracle 1 59 0 543M 441M sleep 3:16 0.01% oracle
    : 2607 oracle 11 59 0 1473M 1407M sleep 3:02 0.01% oracle
    : I ran vmstat, sar before. There is not much going on for si/so, and sr
    : mostly stays at 0.
    : VMStat
    : SAR
    : SunOS xxxx 5.10 Generic_118833-24 sun4u 05/22/2007

    The current kernel is: 125100-07 - 118833-24 is behind.
    Have you ever patched this machine?

    I think you told Oracle its OK to grab 12 GB of RAM. Other than that
    the system appears to be doing very little at the moment.



+ Reply to Thread