RE: 10g - ASM

  • From: Ravi Kulkarni <kulkarni.ravi@xxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 10 May 2004 16:28:58 -0500

the HOST= should map to a PHYSICAL IP address.

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Koivu, Lisa
Sent: Monday, May 10, 2004 4:01 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: 10g - ASM


Hi Pete and Byron,=20

Thanks for your response. =20

I question the whole idea in a SAN environment because the server I have
to work with only has 2 controllers, and the SAN cache is going to skew
any performance metrics gleaned from the i/o. =20

Does that make sense or am I off my rocker?

Also, for those of you who have created the +ASM instance - the
LOCAL_LISTENER keeps crapping out.  How did you configure the
LOCAL_LISTENER parameter in the spfile or init.ora?  I've tried the
listener name, fully qualifying the listener address and port, including
+ASM in the sid_list_listener, and not, and it still doesn't like the
LOCAL_LISTENER parameter.=20

Any suggestions are appreciated. =20

Thanks=20
Lisa

-----Original Message-----
From: Pete Sharman [mailto:peter.sharman@xxxxxxxxxx]=20
Sent: Monday, May 10, 2004 3:22 PM
To: oracle-l@xxxxxxxxxxxxx
Cc: Peter Ross Sharman
Subject: RE: 10g - ASM

Byron

I tend to believe (personal opinion and all that crap) that an automatic
so=3D
lution can usually be improved upon by an extremely competent person who
kn=3D
ows the system inside out and all that.  Trouble is, there ain't many
peopl=3D
e like that out there.  So for those sites that don't have Jonathan on a
le=3D
ash, ASM might well be the easiest approach to get reasonable
performance. =3D
 Thankfully, there are always going to be those big mothers of systems
that=3D
 need someone to hold their hand.

SELECT personal_opinion, witty_remark
FROM company_requirements;

:)

 =3D

Pete
 =3D

"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
 =3D

"Oh no, it's not.  It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] =3D
On Behalf Of Byron Pearce
Sent: Tuesday, 11 May 2004 4:42 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: 10g - ASM

Lisa:

I haven't run ASM on Windows.  Howevever, on Unix platforms it uses the
=3D

raw device, meaning that it has direct access to the disk.  In the case
=3D

of your SAN, that would mean the "logical disk" as it is presented to =
=3D

the node.  In theory, that should be a distinct physical disk but in the
=3D

world of storage virtualization that is not always the case.  Having =3D

said that, if Oracle thinks that two "disks" are distinct and they are =
=3D

actually different views of the same physical disk, then this can cause
=3D

ASM to make some poor performance-related decisions regarding its =3D

striping and mirroring.

I have experimented with it, but haven't tried to implement it in any =
=3D

kind of production capacity.  Some of the major arguments put forth for
=3D

the use of ASM include the ability to easily add disks, distribute =3D

I/O's, stripe, mirror, etc. all maintained and handled by the database.
=3D

I can see some advantages for the small shops where they want to =3D

allocate a pool of disks and leave Oracle to run on them without all of
=3D

the disk fine-tuning, but I am not convinced about larger enterprise =3D

configurations where you're trying to squeeze every last drop of juice =
=3D

out of the lemon.  I am still on the fence and haven't developed a =3D

religious feeling about it yet as I am still studying the implications.

Hope this helps a bit.

Koivu, Lisa wrote:

>Hello all,=3D3D20
>
>I'm currently installing 10g on Windows 2003.  Anyone using Automatic
>Storage Management? =3D3D20
>
>I read this in the ASM documentation (below), and I'm concerned because
>a LUN is a logical volume.  I wonder if implementing ASM is just an
>unnecessary pain for a SAN environment, especially considering the
>enormous SAN cache. =3D3D20
>
>Way back when I didn't have grey hair and I worked on Unix, all my
>devices were logical volumes.  That was standard in every Unix shop I
>worked in.  I get the feeling I'm missing something or misinterpreting
>this paragraph below.  It sounds like it wants direct access to disks,
>period.
>
>I am not a SAN, Unix or Windoze expert.  Comments, anyone? =3D3D20
>
>Thanks
>
>
>
>With Automatic Storage Management, the definition of the logical
volumes
>of a storage array is critical to database performance. Automatic
>Storage Management cannot optimize database data placement when the
>storage array disks are subdivided or aggregated. Aggregating and
>subdividing the physical volumes of an array into logical volumes can
>hide the physical disk boundaries from Automatic Storage Management.
>Consequently, careful consideration of storage array configuration is
>required.
>
>
>Lisa Koivu
>Sr. Monkey
>Orlando, FL, USA
>
>
>
>"The sender believes that this E-Mail and any attachments were free of
=3D3D=3D

>any virus, worm, Trojan horse, and/or malicious code when sent. This
=3D3D
>message and its attachments could have been infected during =3D3D
>transmission.  By reading the message and opening any attachments, the
=3D3D=3D

>recipient accepts full responsibility for taking proactive and remedial
=3D3D=3D

>action about viruses and other defects. The sender's business entity is
=3D3D=3D

>not liable for any loss or damage arising in any way from this message
=3D3D=3D

>or its attachments."
>
>----------------------------------------------------------------
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>----------------------------------------------------------------
>To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
>put 'unsubscribe' in the subject line.
>--
>Archives are at //www.freelists.org/archives/oracle-l/
>FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
>-----------------------------------------------------------------
>
>
>  =3D

>

-- =3D

=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D=
3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D
=3D3D=3D
=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D=
3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D
=3D3D=3D
=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D=
3D=3D3D=3D3D=3D3D
Byron Pearce                         mailto:pearceb@xxxxxxxxxx
Tenure Systems, Inc.                 Dallas/Fort Worth, TX

"It's hard to be a ninja when you wear a beeper."



----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------


----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

"The sender believes that this E-Mail and any attachments were free of =
any virus, worm, Trojan horse, and/or malicious code when sent. This =
message and its attachments could have been infected during =
transmission.  By reading the message and opening any attachments, the =
recipient accepts full responsibility for taking proactive and remedial =
action about viruses and other defects. The sender's business entity is =
not liable for any loss or damage arising in any way from this message =
or its attachments."

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: