Solaris 10

11-08-2012

Registered User

72, 0

Join Date: Jan 2008

Last Activity: 6 December 2017, 4:07 AM EST

Location: I live in Pretoria, South Africa

Posts: 72

Thanks Given: 20

Thanked 0 Times in 0 Posts

Solaris 10

Hi Guys,

I am running Oracle 11g database on solaris 10 and one of the recommendations is to set kernel parameters using project--(something new to me).

Now I want to see if my semaphores are configure correctly and are used properly.

How do I see the behavior of my kernel parameters, more especially the semaphores?

Please Help!!!!

Thanks in advance...

Phuti

View Public Profile for Phuti

Find all posts by Phuti

11-08-2012

Registered User

5,725, 311

Join Date: Jul 2006

Last Activity: 17 February 2019, 10:46 AM EST

Location: Berlin, Germany

Posts: 5,725

Thanks Given: 75

Thanked 311 Times in 297 Posts

have you checked the solaris documentation? you can find it at Oracle Documentation

This User Gave Thanks to DukeNuke2 For This Post:

DukeNuke2

View Public Profile for DukeNuke2

Visit DukeNuke2's homepage!

Find all posts by DukeNuke2

11-08-2012

Registered User

65, 14

Join Date: Nov 2012

Last Activity: 13 January 2014, 7:20 AM EST

Location: Warsaw, Poland

Posts: 65

Thanks Given: 0

Thanked 14 Times in 13 Posts

Configuration of kernel parameters for current project can be displayed with this command:

Code:

root@testserver # prctl $$

If you want display parameters for project used by oracle you should login as oracle and then use above command or you can use something like this:

Code:

root@testserver # prctl -i process 5830

where 5830 must be replaced by a PID of some oracle process running on your server.
If you want to display information about one parameter you can use:

Code:

root@testserver # prctl -n process.max-sem-nsems -i process 5830

Information about semaphores usage can be displayed with:

Code:

root@testserver # ipcs -b

This User Gave Thanks to GP81 For This Post:

GP81

View Public Profile for GP81

Find all posts by GP81

11-13-2012

Registered User

72, 0

Join Date: Jan 2008

Last Activity: 6 December 2017, 4:07 AM EST

Location: I live in Pretoria, South Africa

Posts: 72

Thanks Given: 20

Thanked 0 Times in 0 Posts

Thanks for the replies...

How do I change the default project for the user?

I have the below attributes for one of my projects (that is projectc group.ctron):

Code:

NAME    PRIVILEGE       VALUE    FLAG   ACTION                       RECIPIENT
project.max-contracts
        privileged      10.0K       -   deny                                 -
        system          2.15G     max   deny                                 -
project.max-device-locked-memory
        privileged      1.94GB      -   deny                                 -
        system          16.0EB    max   deny                                 -
project.max-locked-memory
        system          16.0EB    max   deny                                 -
project.max-port-ids
        privileged      8.19K       -   deny                                 -
        system          65.5K     max   deny                                 -
project.max-shm-memory
        privileged      16.0EB      -   deny                                 -
        system          16.0EB    max   deny                                 -
project.max-shm-ids
        privileged      4.10K       -   deny                                 -
        system          16.8M     max   deny                                 -
project.max-msg-ids
        privileged        128       -   deny                                 -
        system          16.8M     max   deny                                 -
project.max-sem-ids
        privileged      4.10K       -   deny                                 -
        system          16.8M     max   deny                                 -
project.max-crypto-memory
        privileged      7.78GB      -   deny                                 -
        system          16.0EB    max   deny                                 -
project.max-tasks
        system          2.15G     max   deny                                 -
project.max-lwps
        system          2.15G     max   deny                                 -
project.cpu-cap
        system          4.29G     inf   deny                                 -
project.cpu-shares
        privileged          1       -   none                                 -
        system          65.5K     max   none                                 -
zone.max-swap
        system          16.0EB    max   deny                                 -
zone.max-locked-memory
        system          16.0EB    max   deny                                 -
zone.max-shm-memory
        system          16.0EB    max   deny                                 -
zone.max-shm-ids
        system          16.8M     max   deny                                 -
zone.max-sem-ids
        system          16.8M     max   deny                                 -
zone.max-msg-ids
        system          16.8M     max   deny                                 -
zone.max-lwps
        system          2.15G     max   deny                                 -
zone.cpu-cap
        system          4.29G     inf   deny                                 -
zone.cpu-shares
        privileged          1       -   none                                 -

Now, I have a user, attached to this project this user runs a program that processes multiple files on the server and these program used to process 100 files per minute on 850 server running Solaris 8 O/S.

We upgraded our server to T4 sparc generation with Host CPU (CPUs: 128 Cores: 16 Sockets: 2) and Solaris 10 O/S. Now the program runs very slow doing 100 files per 5 minutes.

Below is the prstat -J results:

Code:

PROJID    NPROC  SWAP   RSS MEMORY      TIME  CPU PROJECT
          104       13   19M   54M    0.2%   0:00:14 0.5% group.ctron
         100      119   19G   19G    59%    0:58:12 0.4% group.dba
           0       90  438M  499M    1.5%   0:19:19 0.2% system
          14       12   10M   16M     0.0%   0:00:00 0.0% group.sysadmin
          1        5   20M   24M      0.1%   0:00:13 0.0% user.root


Host CPU (CPUs: 128 Cores: 16 Sockets: 2)

And I what I have realized is that the NPROC value,from prstat -J for project id 104 does go above 40.

What attribute should I change and to which value, in order to improve my processing performance?

How do I make a project a default project and remove the current default project?

Please Help!!!!!

Thanks in advance...

Last edited by Phuti; 11-13-2012 at 09:24 AM..

Phuti

View Public Profile for Phuti

Find all posts by Phuti

11-14-2012

Registered User

65, 14

Join Date: Nov 2012

Last Activity: 13 January 2014, 7:20 AM EST

Location: Warsaw, Poland

Posts: 65

Thanks Given: 0

Thanked 14 Times in 13 Posts

There are two methods to setup default project.
1. add entry in file /etc/user_attr for example:

Code:

gregory::::project=projectname

2. create project with a special name for example:
-user.gregory (this creates project which is default for user gregory)
-group.staff (this creates project which is default for group staff)

For details see:

Code:

man getdefaultproj

What resource limit you want to increase? Does your process need more cpu, memory, or something else? Have you check this with some stats command?

This User Gave Thanks to GP81 For This Post:

GP81

View Public Profile for GP81

Find all posts by GP81

11-26-2012

Registered User

72, 0

Join Date: Jan 2008

Last Activity: 6 December 2017, 4:07 AM EST

Location: I live in Pretoria, South Africa

Posts: 72

Thanks Given: 20

Thanked 0 Times in 0 Posts

Thanks a lot guys for the replies.

It looks like my problem was caused by the NFS configurations.

I am using the NetApp NFS filesystems for our application and for our Oracle database. We decided to move our apllication to the local disk to test if we get a better performance. It proved that we have a problem on the NFS filesystem as our application performs five times better than when it is on NFS.

I thought the issues are with the resource controls on the O/S level but in this case it looks like it is the NFS configurations.

Thanks a lot for the replies...

Phuti

View Public Profile for Phuti

Find all posts by Phuti

Solaris

Solaris 10

4 More Discussions You Might Find Interesting

1. Solaris

Patching Procedure in Solaris 10 with sun cluster having Solaris zone

Discussion started by: nick101

2. Solaris

root disk mirroring in solaris volume manager for solaris 10

Discussion started by: ramareddi16

3. Solaris

Unable to login using ssh,telnet onto my solaris machine with solaris 10 installed

Discussion started by: sankasu

4. Solaris

application compiled on solaris 10 throwing error when executed on solaris 9

Discussion started by: ash_bit2k2