HPE Storage Users Group

A Storage Administrator Community




Post new topic Reply to topic  [ 1 post ] 
Author Message
 Post subject: Interesting Observation with Database drives
PostPosted: Sun Dec 20, 2009 1:14 am 
Site Admin
User avatar

Joined: Tue Aug 18, 2009 10:35 pm
Posts: 1328
Location: Dallas, Texas
We run Oracle on AIX using Oracle's "ASM" (Automatic Storage Management). Basically the RAW disks are assigned to Oracle instead of the operating systems logical volume manager. This means everyone except the DBA is blind to the amount of consumed/free space on those LUNs.

However, if the oracle LUNs are Thin Provisioned, you can use the 3par tools to see how much space has been allocated to the ASM LUNs and with some simple calculations figure it out yourself. Better yet you can also use System Reporter to track DB growth rates over time.

This is just one of many reasons why you should deploy a strong and meaningful LUN labeling convention from the start.

My basic naming convention is <Hostname>_<Lun#>
When I can, I will tag on additional info such as _ASM or _<VolumeGroupName> for AIX.

This makes it easier to work when in the provisioning list as well as the system reporter selection windows where filters are king.

_________________
Richard Siemers
The views and opinions expressed are my own and do not necessarily reflect those of my employer.


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 1 post ] 


Who is online

Users browsing this forum: No registered users and 61 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group | DVGFX2 by: Matt