Load on base oracle

[JPDB_75]

I have a question.

I have an Oracle database (8.1.7) running on a Solaris Unix (5.8).
The machina has 12 cpu.

No matter how many connections and treatments I have on the machine,
Only 2 cpu seem to be working, and the machine never seem to be on 100% load, at most 10% load.

Can someone explain to me why?

[Thomasps]

Post this results

SQL> show parameter cpu_count

NAME                                 TYPE    VALUE
------------------------------------ ------- ------------------------------
cpu_count                            integer 2

[marist89]

Your application is not scalable?

[tamilselvan]

Index creation in parallel threads will use all CPUs. You can do simple test. Create a large table (10 G ) and build an index on 3 or more columns. Watch the CPU utilization. If the server is not using most of the CPUs, then there could be problem in Solaris 5.8 or the machine is NOT built properly. May be 10 CPUs are not configured properly. COntact SUN Microsystems.

Tamil

[marist89]

Maybe you are I/O bound and the CPUs have no work to do.

[Thomasps]

Originally posted by marist89
Maybe you are I/O bound and the CPUs have no work to do.

A good reason. Better to know his storage configuration.

[JPDB_75]

SQL> show parameter cpu_count

NAME TYPE VALUE
------------------------------------ ------- ------------------------------
cpu_count integer 12

[Thomasps]

As Jeff said, is your storage is maxed out by I/O so that the CPU is waiting?