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 -----------------------------------------------------------------