- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Oracle raw volume size
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-04-2004 06:13 PM
тАО03-04-2004 06:13 PM
Since time immemorial, we've been using raw datafiles in our Oracle databases.
We usually create the LVOL with a size exactly 4MB larger than the storage statement that is used when the datafile is added to the tablespace, but for the life of us, we can't remember WHY!
We seem to think there is some "overhead" space needed by Oracle, and we don't know whether this somehow relates to the guaranteed free space that is normally kept by the OS in filesystems (free_space_percent)?
Can anybody shed any light, or are we slavishly following an old practice that no longer is required?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-04-2004 09:49 PM
тАО03-04-2004 09:49 PM
Re: Oracle raw volume size
cf. attachment from Metalink doc id 146384.1
Regards,
Jean-Luc
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-04-2004 09:50 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-04-2004 10:01 PM
тАО03-04-2004 10:01 PM
Re: Oracle raw volume size
Seems like we've been wasting a lot of space over the years, for nothing.......
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-05-2004 02:15 PM
тАО03-05-2004 02:15 PM
Re: Oracle raw volume size
> Seems like we've been wasting a lot of
> space over the years, for nothing.......
Well Jakes, if you like so many create your datafiles as a 'round' number of megabytes like 512MB or 4096MB and your PE is 4MB then you didn't really waste anything because you'll need a whole PE more for being a byte over.
'course you could have created the LV first (as a nice round number because you have no choice! :-), and then back-tracked the Oracle filesize as LV-size minus overhead.
I also recall liking to round-up to full MBs, to help dd scripts. It allows you to copy with for example bs=1024k without errors but the details escape me for now.
Finally... 'a lot' is probably less than 1% anyway assuming the datafiles are a few 100 MB.
Cheers,
Hein.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-14-2004 10:49 PM
тАО03-14-2004 10:49 PM
Re: Oracle raw volume size
You are correct: the PE size is of course the real issue. With VGs of over 750GB, we often have to modify the PE size to be 8MB (in order not to exceed the published limits for MAX PE per PV, etc).
So we sometimes waste 7MB per datafile. Our local Oracle "standards" usually mean that datafiles are 2GB (2000MB, not 2048!), so if we have a 300GB tabelspace, we would have (obviously) 150 datafiles, with a wastage of 7MB minimum per datafile. That's 1050MB wasted! Not a lot when thinking of a 300GB tabelspace, but I'm a real miser...;->