RE: help - raw disks

From: Richard Ji <richard_at_letsplay.com>
Date: Mon, 11 Sep 2000 16:53:50 -0400
Message-Id: <10616.116666@fatcity.com>

This is a multi-part message in MIME format.

------=_NextPart_000_0052_01C01C11.6E7DBDD0 Content-Type: text/plain;

charset="us-ascii"
Content-Transfer-Encoding: 7bit

You can create a symbolic link to point to the raw devices. /d00/oradata/orcl/system01.dbf will be a symbolic link to /dev/rdsk/c2....

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Brian Wisniewski
Sent: Monday, September 11, 2000 4:10 PM 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!

------=_NextPart_000_0052_01C01C11.6E7DBDD0 Content-Type: text/html;

charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">

<META content=3D"MSHTML 5.00.3103.1000" name=3DGENERATOR></HEAD>
<BODY>
<DIV>You=20
can create a symbolic link to point to the raw devices. =20 /d00/oradata/orcl/system01.dbf will be a symbolic link to=20 /dev/rdsk/c2....</DIV>
<BLOCKQUOTE>

 <DIV align=3Dleft class=3DOutlookMessageHeader dir=3Dltr>-----Original Message----- From: root_at_fatcity.com=20 [mailto:root_at_fatcity.com]On Behalf Of Brian = Wisniewski Sent:=20
 Monday, September 11, 2000 4:10 PM To: Multiple recipients = of list=20
 ORACLE-L Subject: help - raw disks </DIV>I've = never=20
 used raw devices before and could use some help. Using raw devices was = not a=20
 decision I was involved in and not one I can change. I've read = about=20
 as as much as I can on MetaLink and anywhere else I could find info. = Now I=20
 could use some clarification and help. Solaris, Oracle 8.1.6=20 Here are just 3 of the 210 partitions available lrwxrwxrwx = 1 root=20
 root /dev/rdsk/c2t4d9s1/dev/rdsk/c2t4d9s1 ... /dev/rdsk/c2t4d9s2 =
 ...=20

 /dev/rdsk/c2t4d9s3 I am under the impression Oracle/DBA needs = to be=20
 the owner and group of the partitions I will be using - is this = correct? chown=20
 oracle /dev/rdsk/c2t4d9s1, chgrp dba ... I know there can only = be 1=20
 datafile per partition but can I name datafiles on these partitions = just like=20
 on regular file systems? eg. create tablespace raw_data = datafile=20
 '/dev/rdsk/c2t4d9s2/raw_data.dbf' size 500M or is the name of the = device the=20
 file name? '/dev/rdsk/c2t4d9s2' size 500M If I can name a fi! = ! le=20
 'data.dbf' how do I delete the file if I drop a tablespace? Is this = part of=20
 the dd command I just haven't absorbed yet? How do you monitor = I/O=20
 activity and such to know if you have a hot spot? I have a map = someone=20
 created showing all of the partitions, controllers, partition size and = such=20
 but is there a command to verify the size of the parititions? I read = you=20
 should create each file at least 2 oracle block sizes less than the = size of=20
 the partition so I wanted to verify the exact size before attempting = to create=20
 a file. Any good websites or books giving detailed info about = raw=20
 devices you've come across would also be very beneficial. I'm = sure I=20
 could go on and on but if you could help me get started it would be = very much=20
 appreciated. If you respond to the list could you also cc=20 brian_wisniewski_at_yahoo.com as I'm more likely to receive it first from = the cc=20
 than through the list. Thanks - Brian

  <P><BR>
  <HR SIZE=3D1>
  <B>Do You Yah! ! oo!?</B><BR><A href=3D"http://mail.yahoo.com/">Yahoo! =

Received on Mon Sep 11 2000 - 15:53:50 CDT