Solaris 10 Slowness

UNIX Solaris
1

Hi,
We have got 2 solaris boxes, since our inhouse application has certified on solaris environment and now we need to certify the performance of that application on Solaris environment.

1 box we have installed websphere and the other box we have installed Oracle 10.2.0.3. both are 64bit.

Now we have created a oracle schema on the Oracle which is on Solaris 10, started executing a batch file for generating Volume data. The batch file execute the sql file to generate the volume data by inserting records in to the tables using simple insert command. We have generated 1Lakh records in 30min on Oracle which is installed on windows 4 CPU with 4GB RAM. but on Solaris it is taking more than 3hrs. The Oracle configuration is same as it is there on Windows. More over our DBA is saying the database wise the configurations and all are fine.

We are not aware anything about the Solaris box. Can some one help us in identifying the problem.

The Solaris box configuration is as follows:
Sun Fire V480 - Processor two dual-processor CPU/Memory Boards 1200-MHz UltraSPARC III Cu - 64-bit, 4-way superscalar SPARC V9
HDD - 250GB
RAM - 16 GB

Thanks & Regards,
Ram

2

The UltraSPARC III Cu CPU is from 2002 or so, IIRC.

How old is the Windows box you're running on? Is it 8 years old?

3

Thanks for responding.

I am not sure about the windows how old is it. But the machine model is Acer AltosG520 X86based PC

You can see the system information screenshot in the attachement.

Thanks & Regards,
Ram

4

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.

* 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
 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:
  1. If not, add it and modify
  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)
  1. Check the changes
  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

5

Tuning isn't going to change that much the differences which are probably most due to the obsolete box specs compared to an up to date 3 Ghz one.

6

hi,
I have confirmed with out System Administration department and they confirmed that the settings you mentioned are done already.

Can you please let me know if there is anything else we supposed to check or set.

Thanks & Regards,
RamkumarMP