Oracle 10 on Solaris 10 06-2006 - SUN

This is a discussion on Oracle 10 on Solaris 10 06-2006 - SUN ; Can I ask if anyone of you here encounter the similar problem/scenario 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 10 on Solaris 10 06-2006

  1. Oracle 10 on Solaris 10 06-2006

    Can I ask if anyone of you here encounter the similar problem/scenario
    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 10 on Solaris 10 06-2006

    perry811 wrote:
    > Can I ask if anyone of you here encounter the similar problem/scenario
    > 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


    Don't use top, use prstat.

    No free memory is A Goog Thing(tm). It indicates that the machine is in use and
    have loaded a lot in memory. Read up on some good books like Richard McDougall and
    Jim Mauro's "Solaris Internasls, 2nd ed."
    Look for DTrace scripts to see what your machine is up to. There are a lot on the
    net, specifically the DTrace Toolkit. Also have a look at
    http://www.solarisinternals.com/wiki...erformance_FAQ

+ Reply to Thread