- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Oracle 8i on filesystem.
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-25-2002 03:53 AM
тАО03-25-2002 03:53 AM
Oracle 8i on filesystem.
I want use filesystem for oracle 8i as the datafile.
please give me some advice on
this.
I know a lot of people use raw lv to storage the oracle data.
but someone told me that we can get high performance use filesystem. :-)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-25-2002 04:47 AM
тАО03-25-2002 04:47 AM
Re: Oracle 8i on filesystem.
You should setup your directories according to Oracle Flexible Architecture ( OFA ).
Check Oracle Metalink and your Oracle documentation for that.
Sample :
/unnn/oradata/ORACLE_SID/arch
for offile redolog files
/unnn/oradata/ORACLE_SID/bdump
for alert logs and system traces
/unnn/oradata/ORACLE_SID/cdump
for Oracle coredumps / traces
/unnn/oradata/ORACLE_SID/exp
for exports
/unnn/oradata/ORACLE_SID/imp
for imports
/unnn/oradata/ORACLE_SID/udump
for userdumps
/unnn/oradata/ORACLE_SID/dbs
for datafiles ( tablespaces )
/unnn/oradata/ORACLE_SID/log
for online logs
/unnn/oradata/ORACLE_SID/cntl
for controlfiles
/home/dba/oracle/admin/ORACLE_SID/arch linked to arch dir mentioned above
/home/dba/oracle/admin/ORACLE_SID/bdump as above
/home/dba/oracle/admin/ORACLE_SID/cdump as above
/home/dba/oracle/admin/ORACLE_SID/udump as above
/home/dba/oracle/admin/ORACLE_SID/create for sql scripts to create a database
/home/dba/oracle/admin/ORACLE_SID/exp for scripts and parfiles for exports
/home/dba/oracle/admin/ORACLE_SID/imp for scripts and parfiles for imports
/home/dba/oracle/admin/ORACLE_SID/sql for sql scripts
and so on.
Samples given in OFA.
keep away online logs from offline logs ( separate disks )
keep away index tablespaces from data tablespaces ( separate disks )
Keep control files away from the others
keep your application logs and output files seaparated.
this needs careful planning and may take some time to spread the different databases through the different mountpoints / disks / directories.
Rgds
Alexander M. Ermes
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-25-2002 05:18 AM
тАО03-25-2002 05:18 AM
Re: Oracle 8i on filesystem.
This is not as raw vs. filesystem question, it is a practical disk layout question. Separate the busiest filesystems onto different disks, even different controllers for optimum performance.
Bill Hassell, sysadmin
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-25-2002 12:16 PM
тАО03-25-2002 12:16 PM
Re: Oracle 8i on filesystem.
In theory the raw device will give you a better performance, but I've read that the actual gain is minimal.
The advantage in using filesystem is the vastly easier administration of the database such as tablespace growth.
So go with Ernest suggestion, the OFA std. to spread the different part of Oracle on different mountpoints, ofcourse being on different disk drives.
Andreas
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-25-2002 07:29 PM
тАО03-25-2002 07:29 PM
Re: Oracle 8i on filesystem.
and even secondary index area(again for splitting up I/O). I hope that this helps.
Regards,
Jason V.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-26-2002 12:48 AM
тАО03-26-2002 12:48 AM
Re: Oracle 8i on filesystem.
since you asked for "filesystem", I guess you want to know the special mount-options for the "Online" or "Advanced" JFS/VxFS:
mincache=direct,convosync=direct
are very useful if (and only if) you only have Oracle-datafiles stored on that filesystem - nothing else, no tracefile/textfile/codefiles, etc!
What happens, is that you avoid the so-called "double-buffering" of the Oracle-datablocks (from Oracle-SGA to UNIX-buffercache to disk), which saves a lot of RAM (and a little time). Then you dedicate that RAM to Oracle and THEN you are much faster :-)
Just my $0.02,
Wodisch