LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - General
User Name
Password
Linux - General This Linux forum is for general Linux questions and discussion.
If it is Linux Related and doesn't seem to fit in any other forum then this is the place.

Notices

Reply
 
LinkBack Search this Thread
Old 03-06-2013, 01:24 AM   #1
Rantu
LQ Newbie
 
Registered: Feb 2013
Posts: 2

Rep: Reputation: Disabled
Storage LUN utilization is 100%


I have a oracle database server running in RAC mode. The underlying storage LUN's are of 2*2TB. When DBA importing data, the utilization of these LUN's reaches 100% in iostat -x command. As per DBA the performance is a bit slow.

Can someone explain where the problem might be? What should be the optimal utilization % for a storage LUN? Do I need to increae the count of the LUN's ? say 4*1TB ?
 
Old 03-07-2013, 10:58 AM   #2
TB0ne
Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 13,766

Rep: Reputation: 2346Reputation: 2346Reputation: 2346Reputation: 2346Reputation: 2346Reputation: 2346Reputation: 2346Reputation: 2346Reputation: 2346Reputation: 2346Reputation: 2346
Quote:
Originally Posted by Rantu View Post
I have a oracle database server running in RAC mode. The underlying storage LUN's are of 2*2TB. When DBA importing data, the utilization of these LUN's reaches 100% in iostat -x command. As per DBA the performance is a bit slow.

Can someone explain where the problem might be? What should be the optimal utilization % for a storage LUN? Do I need to increae the count of the LUN's ? say 4*1TB ?
Seriously?? Your DBA is importing data, and is wondering why the disks are busy? The disks are busy, because there is a lot of IO going on, due to the data import.

There is no way to tell you how to optimize it, since we don't know how the tables are laid out, what RAID level/BCV options you have on behind the scenes, or any of the other relevant information, including how large the import is, and if it's finishing. Best thing to do would be to work with Oracle, give them a trace, and see what they suggest.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
100% CPU utilization linuxandtsm Linux - Newbie 6 05-31-2012 01:38 AM
Replacing 200 GB LUN with 100 GB LUN in LVM rajaniyer123 Linux - Enterprise 4 03-27-2012 12:32 PM
CPU 100 % Utilization rajaniyer123 Solaris / OpenSolaris 1 09-20-2007 11:31 AM
100 % CPU utilization Ganesh Kamat Linux - General 14 04-18-2003 01:34 PM
Utilization of a 100 MB switch... WeNdeL Linux - Networking 3 02-11-2003 09:47 AM


All times are GMT -5. The time now is 08:29 AM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration