-
Load on base oracle
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?
-
Post this results
Code:
SQL> show parameter cpu_count
NAME TYPE VALUE
------------------------------------ ------- ------------------------------
cpu_count integer 2
-
Your application is not scalable?
Jeff Hunter
-
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
-
Maybe you are I/O bound and the CPUs have no work to do.
Jeff Hunter
-
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.
-
SQL> show parameter cpu_count
NAME TYPE VALUE
------------------------------------ ------- ------------------------------
cpu_count integer 12
-
As Jeff said, is your storage is maxed out by I/O so that the CPU is waiting?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|