Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

Can somebody suggest any steps I can take to improve the CPU performance of an Oracle 8.0.5 database on a Virtualised Windows 2000?

Update

New installed OS, Windows 2000 Server Advanced SP4
Oracle 8.0.5
Vmware vSphere 4
Cpu layout: 4 Virtual Cpu’s
Memory: 4GB
Dell Poweredge T710
Disk: Local raid 10
2 x Intel Xeon X 5560 @ 2.8GHz
8 virtual cores

Update 2

Only 2 CPUs are being maxed out, where 4 are available. Please refer to image: alt text

share|improve this question
    
What virtualizer? What hardware CPU layout / Virtual server CPU layout? –  TomTom Jul 19 '10 at 14:11
    
Hi TomTom, I've updated the question. Thanks –  DaveDev Jul 19 '10 at 14:56
    
Are you seeing all the cores being maxed out? –  Phil Hannent Jul 19 '10 at 15:01
    
Hi Guys, I added a chart that will answer a few more questions –  DaveDev Jul 19 '10 at 15:28
    
Actually it looks like you've got three vCPUs maxed out, not two - have you got the vmtools installed? does this need to run on 2000 not 2003/2008? same for Oracle? –  Chopper3 Jul 19 '10 at 15:53
show 1 more comment

1 Answer

Oracle 8.0.5 (wince).

Well one reason that you may only be using three cores is the number of concurrent sessions. A database session executes on a single CPU (ignoring parallel processing which I don't thing was around for 8.0.5, and is an edge case anyway).

If you see this when the database is idle, then that is one set of problems (and very likely related to virtualisation). Otherwise I'd start by treating as a database problem, and try to lock it down to what the workload is.

Try having a look at v$session and maybe v$sql to see what is executing. Statspack would be the main tool for investigating performance from the database end.

share|improve this answer
    
+1, especially for the wince. –  DCookie Jul 23 '10 at 17:18
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.