- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - OpenVMS
- >
- Oracle10g - Database Files on ODS2 or ODS5
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
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
тАО11-15-2010 08:06 AM
тАО11-15-2010 08:06 AM
About to upgrade Oracle9i to Oracle10g on an Alpha running VMS8.3
The Question is this:-
Oracle upgrade notes makes it clear that the Oracle10g System files MUST reside on an ODS5 formatted disk.
However they say that the actual Oracle Data Files can reisde on either an ODS2 or ODS5 disk.
Is there any performance issues selecting either one over the other?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-15-2010 08:24 AM
тАО11-15-2010 08:24 AM
Re: Oracle10g - Database Files on ODS2 or ODS5
There are no salient differences in performance between ODS-2 and ODS-5, and the volume-level differences between the two are trivial, and the host I/O paths are basically the same for both.
The chief considerations include whether you can keep the stuff that expects ODS-2 operational. If you keep to an ODS-2 subset where that matters, that's usually feasible.
As for performance, you're running Oracle. You'll want to pick ODS-5 for its increased compatibility with newer tools, and you'll likely want to look at Oracle performance.
Though as Stonebraker commented an eon or two ago, all file systems stink as database platforms.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-15-2010 08:31 AM
тАО11-15-2010 08:31 AM
Re: Oracle10g - Database Files on ODS2 or ODS5
was thinking of changing our data disks to ODS5 for this upgrade and your answer would seem to back this up
I take it I can simply do a
$ set volume/struture_level=5 dkb100:
$ set volume/struture_level=5 dkb200:
$ set volume/struture_level=5 dkb300:
on the 3 volumes that are currently ODS2
just before I start the upgrade? Obviously after a backup!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-15-2010 08:37 AM
тАО11-15-2010 08:37 AM
SolutionThe SET VOLUME /STRUCT=5 command does almost nothing.
At its core, the command changes a single constant within the storage control block; within an ODS-level data structure.
The "reversion" path is via BACKUP, and BACKUP can "downgrade" ODS-5 to ODS-2. That's a tougher nut, as BACKUP has to rename stuff.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-15-2010 08:39 AM
тАО11-15-2010 08:39 AM
Re: Oracle10g - Database Files on ODS2 or ODS5
Seems nice and stright forward!
thank you very much
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-15-2010 08:54 AM
тАО11-15-2010 08:54 AM