| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> help - raw disks
--0-982906996-968686416=:15667
Content-Type: text/plain; charset=us-ascii
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 file '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
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. <BR><BR>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. <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 of the partitions I will be using - is this correct? chown oracle /dev/rdsk/c2t4d9s1, chgrp dba ... <BR><BR>I know there can only be 1 datafile per partition but can I name datafiles on these partitions just like on regular file systems? <BR><BR>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 <BR><BR>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? <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, 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. <BR><BR>Any good websites or books giving detailed info about raw devices you've 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 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. <BR><BR>Thanks - Brian <BR><BR><BR><p><br><hr size=1><b>Do You Yah!
oo!?</b><br>
<a href="http://mail.yahoo.com/">Yahoo! Mail</a> - Free email you can access from anywhere!
Received on Mon Sep 11 2000 - 10:33:36 CDT
 |
 |