| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Thanks RE: help - raw disks
--0-861021530-968781309=:23495
Content-Type: text/plain; charset=us-ascii
Thanks toall those who responded regarding my post about raw disks. Your insight helped out greatly.
ddorr.cs_at_clearstream.com wrote:
Using raw devices instead of regular FS files is not so much overhead, you
just have to be very rigourous.
Yes the disks slices must be owned by oracle, so that the processes can
write to them : chown oracle:dba /dev/rdsk/c2t4d9s? for each disk will do
that for you.
No you can't rename your slices/datafiles : what we do here, to easy
datafile management, is to create a directory in /dev/rdsk named as the
ORACLE_SID and create symbolic links in that dir pointing to raw slices :
in /dev/rdsk/ORCL :
SYSTEM_01 -> /dev/rdsk/c2t3d9s0
so to add a datafile to a tablespace : alter tablespace SYSTEM add datafile '/dev/rdsk/ORCL/SYSTEM_01' size 100M;
When you drop a tablespace, you do not need / cannot "drop" the raw datafile , just reuse it !
To see/change the disk partitionning, use prtvtoc/format /dev/rdsk/c2t4d9s0 ( that's on solaris ).
Do not hesitate to email me directly if you need futher assistance.
> ----------
> From: Brian Wisniewski[SMTP:brian_wisniewski_at_yahoo.com]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Monday, September 11, 2000 22:10
> To: Multiple recipients of list ORACLE-L
> Subject: help - raw disks
>
> I've never used raw devices before and could use some help. Using raw
> devices was not a decision I was involved in and not one I can change.
>
> I've read about as as much as I can on MetaLink and anywhere else I could
> find info. Now I could use some clarification and help.
>
> Solaris, Oracle 8.1.6
>
> Here are just 3 of the 210 partitions available
> lrwxrwxrwx 1 root root /dev/rdsk/c2t4d9s1/dev/rdsk/c2t4d9s1
> ... /dev/rdsk/c2t4d9s2
> ... /dev/rdsk/c2t4d9s3
>
> I am under the impression Oracle/DBA needs to be the owner and group of
> the partitions I will be using - is this correct? chown oracle
> /dev/rdsk/c2t4d9s1, chgrp dba ...
>
> I know there can only be 1 datafile per partition but can I name datafiles
> on these partitions just like on regular file systems?
>
> eg. create tablespace raw_data datafile '/dev/rdsk/c2t4d9s2/raw_data.dbf'
> size 500M or is the name of the device the file name? '/dev/rdsk/c2t4d9s2'
> size 500M
>
> If I can name a fi! ! le 'data.dbf' how do I delete the file if I drop a
> tablespace? Is this part of the dd command I just haven't absorbed yet?
>
> How do you monitor I/O activity and such to know if you have a hot spot?
>
> I have a map someone created showing all of the partitions, controllers,
> partition size and such but is there a command to verify the size of the
> parititions? I read you should create each file at least 2 oracle block
> sizes less than the size of the partition so I wanted to verify the exact
> size before attempting to create a file.
>
> Any good websites or books giving detailed info about raw devices you've
> come across would also be very beneficial.
>
> I'm sure I could go on and on but if you could help me get started it
> would be very much appreciated. If you respond to the list could you also
> cc brian_wisniewski_at_yahoo.com as I'm more likely to receive it first from
> the cc than through the list.
>
> Thanks - Brian
>
>
>
>
>
>
> _____
>
> Do You Yah! ! oo!?
> Yahoo! Mail - Free email you can access from anywhere!
>
-- Author: INET: ddorr.cs_at_clearstream.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). --------------------------------- Do You Yahoo!? Yahoo! Mail - Free email you can access from anywhere! --0-861021530-968781309=:23495 Content-Type: text/html; charset=us-ascii <P> Thanks toall those who responded regarding my post about raw disks. Your insight helped out greatly.</P> <P> </P> <P>- Brian<BR></P> <P> <B><I>ddorr.cs_at_clearstream.com</I></B> wrote: <BR> <BLOCKQUOTE style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">Using raw devices instead of regular FS files is not so much overhead, you<BR>just have to be very rigourous.<BR>Yes the disks slices must be owned by oracle, so that the processes can<BR>write to them : chown oracle:dba /dev/rdsk/c2t4d9s? for each disk will do<BR>that for you.<BR>No you can't rename your slices/datafiles : what we do here, to easy<BR>datafile management, is to create a directory in /dev/rdsk named as the<BR>ORACLE_SID and create symbolic links in that dir pointing to raw slices :<BR><BR>in /dev/rdsk/ORCL :<BR><BR>SYSTEM_01 -> /dev/rdsk/c2t3d9s0<BR><BR>so to add a datafile to a tablespace : alter tablespace SYSTEM add datafile<BR>'/dev/rdsk/ORCL/SYSTEM_01' size 100M;<BR><BR>When you drop a tablespace, you do not need / cannot "drop" the raw<BR>datafile , just reuse it !<BR><BR>To see/change the disk partitionning, use prtvtoc/format /dev/rdsk/c2t4d9s0<BR>( that's on sola! ris ).<BR><BR>Do not hesitate to email me directly if you need futher assistance.<BR><BR><BR>> ----------<BR>> From: Brian Wisniewski[SMTP:brian_wisniewski_at_yahoo.com]<BR>> Reply To: ORACLE-L_at_fatcity.com<BR>> Sent: Monday, September 11, 2000 22:10<BR>> To: Multiple recipients of list ORACLE-L<BR>> Subject: help - raw disks<BR>> <BR>> I've never used raw devices before and could use some help. Using raw<BR>> devices was not a decision I was involved in and not one I can change. <BR>> <BR>> I've read about as as much as I can on MetaLink and anywhere else I could<BR>> find info. Now I could use some clarification and help. <BR>> <BR>> Solaris, Oracle 8.1.6 <BR>> <BR>> Here are just 3 of the 210 partitions available <BR>> lrwxrwxrwx 1 root root /dev/rdsk/c2t4d9s1/dev/rdsk/c2t4d9s1 <BR>> ... /dev/rdsk/c2t4d9s2 <BR>> ... /dev/rdsk/c2t4d9s3 <BR>> <BR>> I am under the impression Oracle/DBA needs to be the owner and group o! f<BR>> the partitions I will be using - is this correct? chown oracle<BR>> /dev/rdsk/c2t4d9s1, chgrp dba ... <BR>> <BR>> I know there can only be 1 datafile per partition but can I name datafiles<BR>> on these partitions just like on regular file systems? <BR>> <BR>> eg. create tablespace raw_data datafile '/dev/rdsk/c2t4d9s2/raw_data.dbf'<BR>> size 500M or is the name of the device the file name? '/dev/rdsk/c2t4d9s2'<BR>> size 500M <BR>> <BR>> If I can name a fi! ! le 'data.dbf' how do I delete the file if I drop a<BR>> tablespace? Is this part of the dd command I just haven't absorbed yet? <BR>> <BR>> How do you monitor I/O activity and such to know if you have a hot spot? <BR>> <BR>> I have a map someone created showing all of the partitions, controllers,<BR>> partition size and such but is there a command to verify the size of the<BR>> parititions? I read you should create each file at least 2 oracle block<BR>> sizes! less than the size of the partition so I wanted to verify the exact<BR>> size before attempting to create a file. <BR>> <BR>> Any good websites or books giving detailed info about raw devices you've<BR>> come across would also be very beneficial. <BR>> <BR>> I'm sure I could go on and on but if you could help me get started it<BR>> would be very much appreciated. If you respond to the list could you also<BR>> cc brian_wisniewski_at_yahoo.com as I'm more likely to receive it first from<BR>> the cc than through the list. <BR>> <BR>> Thanks - Brian <BR>> <BR>> <BR>> <BR>> <BR>> <BR>> <BR>> _____ <BR>> <BR>> Do You Yah! ! oo!?<BR>> Yahoo! Mail - Free email you can access from anywhere!<BR>> <BR>-- <BR>Author: <BR>INET: ddorr.cs_at_clearstream.com<BR><BR>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051<BR>San Diego, California -- Public Internet access / Mailing Lists<BR>------------------------------------! --------------------------------<BR>To REMOVE yourself from this mailing list, send an E-Mail message<BR>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in<BR>the message BODY, include a line containing: UNSUB ORACLE-L<BR>(or the name of mailing list you want to be removed from). You may<BR>also send the HELP command for other information (like subscribing).</BLOCKQUOTE><p><br><hr size=1><b>Do You Yahoo!?</b><br> <a href="http://mail.yahoo.com/">Yahoo! Mail</a> - Free email you can access from anywhere!Received on Tue Sep 12 2000 - 12:55:09 CDT
 |
 |