Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Solaris 10 Slowness
Operating Systems Solaris Solaris 10 Slowness Post 302408317 by RTM on Monday 29th of March 2010 07:21:11 AM
Old 03-29-2010
Did you set up system parameters and/or project for Oracle?

You can try the following, or call Oracle for latest info. Changes to /etc/system require a reboot.

Add to /etc/system - note most of this is just comments noting the differences between the old way of doing the changes inside /etc/system and the new way in a project.
Code:
* for Oracle - 11/26/08
* Old parameter and value * OS Resource Control and default value
* set shmsys:shminfo_shmmax=12026118144 * project.maxshm-memory 1/4 phys memory
*set shmsys:shminfo_shmmin=1 * No RC value
*set shmsys:shminfo_shmseg=100 * No RC value
* Semaphore parameters:
set semsys:seminfo_semmni=1000 * project.maxsem-ids default 128
*set semsys:seminfo_semmnu=512 * No RC value
*set semsys:seminfo_semmap=1024 * No RC value
*set semsys:seminfo_semmns=4096 * No RC value
* set semsys:seminfo_semmsl=512 * project.maxsem-nsems default 512

To set up a project for the oracle user -
1. Check to see if one is already set up
Code:
 projects -l
 
system
        projid : 0
        comment: ""
        users  : (none)
        groups : (none)
        attribs:
user.root
        projid : 1
        comment: ""
        users  : (none)
        groups : (none)
        attribs:
noproject
        projid : 2
        comment: ""
        users  : (none)
        groups : (none)
        attribs:
default
        projid : 3
        comment: ""
        users  : (none)
        groups : (none)
        attribs:
group.staff
        projid : 10
        comment: ""
        users  : (none)
        groups : (none)
        attribs:

2. If not, add it and modify

Code:
  projadd user.oracle

  projmod -sK "project.max-shm-memory=(privileged,4294967296,deny)" user.oracle

projects -l
system
        projid : 0
        comment: ""
        users  : (none)
        groups : (none)
        attribs:
user.root
        projid : 1
        comment: ""
        users  : (none)
        groups : (none)
        attribs:
noproject
        projid : 2
        comment: ""
        users  : (none)
        groups : (none)
        attribs:
default
        projid : 3
        comment: ""
        users  : (none)
        groups : (none)
        attribs:
group.staff
        projid : 10
        comment: ""
        users  : (none)
        groups : (none)
        attribs:
user.oracle
        projid : 100
        comment: ""
        users  : (none)
        groups : (none)
        attribs: project.max-shm-memory=(privileged,12026118144,deny)

3. Check the changes

Code:
  su - oracle
$ prctl -n "project.max-shm-memory" $$
process: 2226: -ksh
NAME    PRIVILEGE       VALUE    FLAG   ACTION                       RECIPIENT
project.max-shm-memory
        privileged      4.00GB      -   deny                                 -
        system          16.0EB    max   deny                                 -
 
$ exit
# prctl -n "project.max-shm-memory" $$
process: 4524: /usr/bin/ksh -o vi
NAME    PRIVILEGE       VALUE    FLAG   ACTION                       RECIPIENT
project.max-shm-memory
        privileged      1.95GB      -   deny                                 -
        system          16.0EB    max   deny                                 -

Note: I'm not an Oracle DBA - just passing along possible info
 

9 More Discussions You Might Find Interesting

1. Linux

slowness of Linux 8.0 server

Hi, I have a Linux 8.0 Redhat installed as a server. The samba configuration was done to allowed logging in to the server from windows workstations. I have a LAN, WAN connection. However, any time the workstation is trying to make a WAN connection it slow down all the systems on the network. Can... (0 Replies)
Discussion started by: kayode
0 Replies

2. SCO

Terminal Slowness

I have attempted to2find answers to this question: When logging into tty01 the system will take 5 to 10 seconds to display each character typed. Each other terminal will login correctly and display correctly2but not the first terminal. Rebooting was suggested on several sites and this has been... (2 Replies)
Discussion started by: ypanic
2 Replies

3. HP-UX

HP-UX Intermec Label Slowness

We recently moved from a Open VMS OS to HP-UX. When printing labels on Intermec 3400 printers we are seeing a delay of up to 3 minutes before labels print. We have printers going through a DEC Term servers and Jet Direct boxes. Any suggestions what might be causing this delay? (4 Replies)
Discussion started by: BIGJIM
4 Replies

4. Solaris

Login Slowness

Hi Folks My Sun Solaris servers are waiting for a long time after keying in the User-ID. There is a big delay in getting to the password prompt. But once the password is keyed in,it goes through in a second. The servers in which i am facing this issue is an NIS client. But i am facing this... (7 Replies)
Discussion started by: Hari_Ganesh
7 Replies

5. Solaris

NIS performance slowness

Hi I have a Solaris 10 NIS server and more than 250 NIS clients out of these there are 5 main application servers, and whenever there is any compilation happens on any of the application servers (which are acting as NIS clients) entire NIS performance will come down.Can some one help me to fix... (5 Replies)
Discussion started by: nithnara
5 Replies

6. Solaris

ssh slowness

Hi admins, After changing the ip address(temperorily) ssh to that server is very slow(exactly 25 sec).But from this new ip i can ssh to other servers without any delay problem. debug1: match: Sun_SSH_1.1.1 pat Sun_SSH_1.1.1* debug1: Enabling compatibility mode for protocol 2.0 debug1:... (2 Replies)
Discussion started by: newsol
2 Replies

7. Solaris

Java Application slowness with Xmanager

Hi! I have a m3000 server with solaris 10. Clients connecting to server using Xmanager. But when they open a Java based application its very slow and some times hanging. But when I tried with VNC it works fine. Is this a BUG in Xmanager? Or Is there any method to solve this? Thanks, Charith (3 Replies)
Discussion started by: charith.upendra
3 Replies

8. Solaris

Login slowness from LDOM to ZONE

Need assitance in troubleshooting steps . Below is the issue I have LDOM which has 4 zones on it . One zone logging into the server takes 13sec where as other zones are quick . Troubleshooting steps which I did - Checked /var/tmp . Not many files - We have LDAP but thought that wouldnt be... (7 Replies)
Discussion started by: ajayram_arya
7 Replies

9. AIX

Slowness issue

Oracle database is facing slowness issues frequently on AIX server. So can anybody suggest how to fix these issues from OS end? Do we need to tune any parameter in AIX to resolve this issue? Please post in an adequate forum! (1 Reply)
Discussion started by: vithal
1 Replies
All times are GMT -4. The time now is 09:31 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy