Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> PCM Oracle DB, Hitting hard drive hard
DFiamingo
post Mar 20 2017, 02:18 AM
Post #1


Newbie
*

Group: Members
Posts: 1
Joined: 19-March 17
Member No.: 51,845



Hello Experts,

I have a client running an EMR software (PCM by Prime Clinical) that gets hammered by an Oracle database with disk reads at 100-200 MBytes per second. 100MB/Sec even when idle.

The system should be sufficent: Dell PowerEdger R710 Dual Xeon X5647 2.93Ghz, 8 CORE, 16 CORES with HT, 32GB Memory, 2TB SATA 7200 in RAID1. 20-30 users.

i manage the hardware but Prime Clinical manages the software.

What if anything can be done to enhance performance on this system?

The EMR company says it's a disk issue so I was thinking about doing a disk image of the RAID1 to a RAID10 to increase the Read/Write performance.

Any other thoughts on how to improve performance?

Thanks
Go to the top of the page
 
+Quote Post
limsk
post Mar 20 2017, 04:41 AM
Post #2


Advanced Member
***

Group: Members
Posts: 87
Joined: 20-January 08
From: Kuala Lumpur, MY
Member No.: 16,279



QUOTE (DFiamingo @ Mar 20 2017, 03:18 PM) *
Hello Experts,

I have a client running an EMR software (PCM by Prime Clinical) that gets hammered by an Oracle database with disk reads at 100-200 MBytes per second. 100MB/Sec even when idle.

The system should be sufficent: Dell PowerEdger R710 Dual Xeon X5647 2.93Ghz, 8 CORE, 16 CORES with HT, 32GB Memory, 2TB SATA 7200 in RAID1. 20-30 users.

i manage the hardware but Prime Clinical manages the software.

What if anything can be done to enhance performance on this system?

The EMR company says it's a disk issue so I was thinking about doing a disk image of the RAID1 to a RAID10 to increase the Read/Write performance.

Any other thoughts on how to improve performance?

Thanks


You may want to have the DBA gather some performance snapshots (AWR if you have the Eneterprise Edition only Diagnostic Pack License or Statspack otherwise) to see what exactly is the system doing that causes i/o during idle hours. It could be excessive auditing or perhaps (if operating on Windows) an overzealous Anti-virus software conflicting with Oracle.

Go to the top of the page
 
+Quote Post
burleson
post Mar 20 2017, 11:15 AM
Post #3


Advanced Member
***

Group: Members
Posts: 13,409
Joined: 26-January 04
Member No.: 13



Hi, and welcome to the forum!

>> disk reads at 100-200 MBytes per second. 100MB/Sec even when idle.

Well, something is doing I/O!

Run a STATSPACK or AWR report over a five minute period to see what data files are getting the I/O.

An idle database should not do much I/O.

Check iostat:

http://www.dba-oracle.com/t_11_2_new_v_dol...ostat_views.htm

http://www.dba-oracle.com/t_linux_iostat.htm

**********************************************************

>> What if anything can be done to enhance performance on this system?

Then you add faster hardware.

You first need to understand where your bottleneck is:

http://dba-oracle.com/t_troubleshooting.htm




--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 24th May 2017 - 02:58 AM