| ASM Diskgroup resize [message #563882] |
Fri, 17 August 2012 12:28  |
prashanthgs
Messages: 89
Registered: May 2005
Location: chennai
|
Member |
|
|
Hi,
We have database with asm setup. Here the issue is
we have disks 10 for data1 and 10 for fra.
On data1 and fra (9 disks are 33gb and 1 disk is 136gb). As this 1 disk is 136 gb, we observed that striping is more on this disk which results in impacting performance of the Applications accesseing this database. Though asm keeps uniform usage across all the disks, it writes more data or reads more data from the disk which is 136gb.
How we can fix this issue like
a. Can disk of 136gb can be sliced to 33gb without any data loss?
b. Can we drop disk 136gb without any data loss?
Currently 30gb has been used on 136gb disk and 26 gb has been used on 33gb.
If you have come across this issue, how we can perform this.
Thanks
Environment : Non RAC
ASM --Oracle 11gR1
DB -- Oracle 10GR2
|
|
|
|
|
|
|
|
| Re: ASM Diskgroup resize [message #563894 is a reply to message #563885] |
Fri, 17 August 2012 12:54  |
prashanthgs
Messages: 89
Registered: May 2005
Location: chennai
|
Member |
|
|
Thanks for your quick response.
Are you sure you get an impact on the application because of this? How did you see that?
-----------------------------------------------------------------------------------------
We see lots of long running queries in the database (espcially DML statements).
Earlier we did some gather stats, rebuilding indexes of those tables etc based on awr report. But that fixed the issue temporarily.
Then, while analyzing the disk group, we observed this also could be an cause. But as you said, disk group of 136gb was added on Nov 2011 but the performance impact issue (app support complains) only after July 2012 ie. it hit around 100 IPOS.
SAN team confirmed that IOPS (ie.measure of data coming to the disk) is more from July 2012 on this disk (136gb_ comparing to other disks. ie. it hit around 100 IOPS from July.
|
|
|
|
|
|
| Re: ASM Diskgroup resize [message #563901 is a reply to message #563895] |
Fri, 17 August 2012 13:31 |
 |
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
In addition, more IO on a "disk" does not mean there are served slowler than on the other "disk".
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
