- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: "cooked files" and Oracle
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
тАО11-02-2003 06:33 PM
тАО11-02-2003 06:33 PM
"cooked files" and Oracle
the idea of using "cooked files"
with Oracle? What is "cooked files"
and how this one help for better
performance of DB? How I can use
this technology?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-02-2003 06:38 PM
тАО11-02-2003 06:38 PM
Re: "cooked files" and Oracle
"cooked files/filesystems" refers to "normal" mounted filesystems. So Oracle datafiles are placed in directories, just like other files.
The other option is to use raw file systems, where a full logical volume is used as one Oracle datafile.
"Cooked filesystems" are easier to manage at a small performance cost.
regards,
Thierry.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-02-2003 07:19 PM
тАО11-02-2003 07:19 PM
Re: "cooked files" and Oracle
Here's a recent thread...
http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=234347
-- Graham
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-02-2003 08:39 PM
тАО11-02-2003 08:39 PM
Re: "cooked files" and Oracle
But my question is more about
how I can configure Oracle DB to use
"cooked files" /step by step,if posible/.
Any real experiece?
Any good documents about it?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-02-2003 09:13 PM
тАО11-02-2003 09:13 PM
Re: "cooked files" and Oracle
When creating creating oracle tablespaces, you will be creating the datafiles, which inturn will be using the space in the mounted file systems and there is no seperate creation techniques for the cooked filesystems for oracle.cooked the name itself sounds its meaning, where for RAW we have lots of procedure for handling.
Create tablespace( datafile) whose path using the filesystems( A very Normal CREATE TABLESPACE command.....)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-03-2003 03:29 PM
тАО11-03-2003 03:29 PM
Re: "cooked files" and Oracle
-
"Cooked" Datafiles are directly related to tablespaces. hence, if you want to use "cooked" datafiles (which in fact would be same when using raw), you would create your tablespace as:
-
create tablespace tbs_medium
datafile '/u03/oracle/datafiles/tbs_medium_01.dbf'
size 25m reuse
autoextend on
maxsize 100m
extent management local uniform size 1m;
-
The above SQL statement will create a locally managed tablespace which will also be the way to go. Also, the "cooked" file will be automatically created if you have enough space on the /u03/ file system.
-
hOpe this helps
regards
Yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-03-2003 05:01 PM
тАО11-03-2003 05:01 PM
Re: "cooked files" and Oracle
Raw: supposedly faster, but no OS commands to copy and manipulate files. This scares some DBA's.
Someone came up with cooked as a name opposite to raw. Comediens. I've been working with raw logical volume databases since 1996. Its not so bad so long as you are sharp on your utilities(sqlplus).
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-03-2003 08:40 PM
тАО11-03-2003 08:40 PM
Re: "cooked files" and Oracle
Just my five cents...
Regards,
Marcin
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-03-2003 08:43 PM
тАО11-03-2003 08:43 PM
Re: "cooked files" and Oracle
Marcin