Re: how know solaris bit

2001-11-15 Thread Byron Pearce

Seema:

You will want to use the isainfo command:

# isainfo -kv

Seema Singh wrote:

> Hi
> How we know the OS is 32 bit or 64 bit on SOlaris?
> Thanks
> -Seema
>
> _
> Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Seema Singh
>   INET: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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).

--
====
Byron Pearce mailto:[EMAIL PROTECTED]
Tenure Systems, Inc. Arlington, Texas

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


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Byron Pearce
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).



Re: Correction : EMC symetrix - 1M stripe width - Raid 0+

2001-11-14 Thread Byron Pearce
> > --
> > > Please see the official ORACLE-L FAQ:
> > > http://www.orafaq.com
> > > --
> > > Author:
> > >   INET: [EMAIL PROTECTED]
> > >
> > > 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: [EMAIL PROTECTED] (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).
> >
> > =
> > Connor McDonald
> > http://www.oracledba.co.uk (mirrored at
> > http://www.oradba.freeserve.co.uk)
> >
> > "Some days you're the pigeon, some days you're the statue"
> >
> > __
> > Do You Yahoo!?
> > Everything you'll ever need on one web page from News and Sport to
> Email and
> > Music Charts
> > http://uk.my.yahoo.com
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: =?iso-8859-1?q?Connor=20McDonald?=
> >   INET: [EMAIL PROTECTED]
> >
> > 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: [EMAIL PROTECTED] (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).
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author:
> >   INET: [EMAIL PROTECTED]
> >
> > 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: [EMAIL PROTECTED] (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).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Don Granaman
>   INET: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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).

--

Byron Pearce mailto:[EMAIL PROTECTED]
Tenure Systems, Inc. Arlington, Texas

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


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Byron Pearce
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).



Re: Operating Systems

2001-11-14 Thread Byron Pearce
the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Boivin, Patrice J
>   INET: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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).

--

Byron Pearce mailto:[EMAIL PROTECTED]
Tenure Systems, Inc. Arlington, Texas

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


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Byron Pearce
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).



Re: Failures in creating Oracle database file.

2001-11-13 Thread Byron Pearce


Jesse:
It sounds as if you may have run into the 2GB file size limit. 
Has your filesystem been created and mounted with the "largefiles" option?
An easy way to check would be to try and create the tablepace with a
1GB or 2GB datafile and see if it works.
"Jesse W. Asher" wrote:
 
I'm attempting to create a 3GB file on an XFS filesystem using Oracle
8i running on RedHat 7.1 with a generic 2.4.10 kernel and I'm getting some
errors.  Here's the command and output I'm getting:
CREATE TABLESPACE ALTUSER DATAFILE '/export/4/oracle/oradata/alt/data01.dbf'
SIZE 3000M REUSE AUTOEXTEND ON NEXT 1280K
MINIMUM EXTENT 128K DEFAULT STORAGE ( INITIAL 128K NEXT 128K MINEXTENTS
1 MAXEXTENTS 4096 PCTINCREASE 0);
CREATE TABLESPACE ALTUSER DATAFILE '/export/4/oracle/oradata/alt/data01.dbf'
SIZE 3000M REUSE
*
ORA-01119: error in creating database file '/export/4/oracle/oradata/alt/data01.dbf'
ORA-27037: unable to obtain file status
Linux Error: 75: Value too large for defined data type
=
Any ideas as to what could be causing this?  I thought the file
size limit is 4GB which is why I made the file 3GB.  Is this correct
or am I missing something??  Many thanks!!
 
-- 
Jesse W. Asher  [EMAIL PROTECTED]
 

--
====
Byron Pearce
mailto:[EMAIL PROTECTED]
Tenure Systems, Inc.
Arlington, Texas
"It's hard to be a ninja when you wear a beeper."
 


Re: Another Oracle DBA gets "The Bullet" WAS: Help!: Job Descrip

2001-11-13 Thread Byron Pearce
 large Austin employers
> > reducing staff
> > > in the tech area include AMD, Motorola, SamSung, IBM, Perficient
> > and CSC.
> > > Non-tech companies such as law firms, travel agencies (they're
> > pretty much
> > > toast right now anyway), and advertising agencies have been really
> > hurt by
> > > the abrupt cessation of money which used to flow from the startups.
> > >
> > > It's still a great place to live, but a month or two ago, even the
> > Austin
> > > American-Statesman noted that the area was experiencing a
> > "brain-drain" as
> > > the job-seeker/jobs ratio climbed ever higher.  Last week, they
> > posited
> > the
> > > major reason for the area not experiencing a total employment
> > tragedy was
> > > the abundance of State and Local jobs, which, until about 9 months
> > ago,
> > > went begging as private industry vacuumed anybody who could spell
> > "PC" off
> > > the street (if you could spell DBA you had it made).
> > >
> > > The Sunday help-wanted ads have gone from 4 full pages of "Computer
> > Jobs"
> > > to less than two columns, and there are very few senior positions
> > > available.  We even used to have out-of-town companies advertise,
> > but that
> > > trend has dried up as well.
> > >
> > > It anin't pretty folks.
> > >
> > > Maybe Scott (I still think I ought to drive down just to meet the
> > guy) in
> > > San Antonio can give us a more regional perspective.  At the height
> > of the
> > > frenzy, I know a bunch of people who left positions in SA to come
> > to
> > > Austin.
> > >
> > >
> > > David A. Barbour
> > > Oracle DBA, OCP
> > > AISD
> > > 512-414-1002
> > >
> > >
> > >
> > > "Troiano, Paul
> > > (CAP, GEFA)" To: Multiple
> > recipients
> > of list ORACLE-L <[EMAIL PROTECTED]>
> > >  > > pital.com>   Subject: RE:
> > Help!: Job
> > Description for Data Architect
> > > Sent by:
> > > [EMAIL PROTECTED]
> > >
> > >
> > > 11/12/2001 05:40
> > > PM
> > > Please respond to
> > > ORACLE-L
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > How is the job market in Austin?
> > >
> > >
> > > -Original Message-
> > > [mailto:[EMAIL PROTECTED]]
> > > Sent: Monday, November 12, 2001 4:00 PM
> > > To: Multiple recipients of list ORACLE-L
> > >
> > >
> > >
> > > Hey, the job market isn't any better (worse?) here in
> > Austin-by-God, TX
> > > than anywhere else.  We've got a chance to hire a real talented
> > developer
> > > (worked with him before - taught me a lot), but his salary is just
> > a bit
> > > more than the school district is used to paying for "programmers."
> > I
> > > suggested they come up with a new job description to justify the
> > salary
> > > (it's not that great folks - this guy just wants to stay in
> > Austin).
> > > "Wonderful idea" says the boss, "what should we call the position
> > to
> > > confuse the HR folks?"  "Data Architect" I reply.  "Great" says he,
> > "write
> > > it up and have it on my desk by 5:30."
> >
> === message truncated ===
>
> __
> Do You Yahoo!?
> Find the one for you at Yahoo! Personals
> http://personals.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rachel Carmichael
>   INET: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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).

--

Byron Pearce mailto:[EMAIL PROTECTED]
Tenure Systems, Inc. Arlington, Texas

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


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Byron Pearce
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).



Re: Oracle Licensing Scheme

2001-10-31 Thread Byron Pearce

George:

I'm not a sales guy, so I would definitely talk to Oracle for the most current
pricing/configuration info (as well as discounts).

However, as of the 10/19/2001 price list, the costs are $15K/CPU for Standard
Edition and $40K/CPU for Enterprise Edition.  The named user licenses for the
same are $300 and $800 respectively.  At least that's according to the
information that I have.

Don't forget that their are optional componenets such as RAC, Partitioning,
Advanced Security, etc.

George Hofilena wrote:

> I can't seem to find anything clear on licensing rates at Oracle's site
> anymore.  Maybe it's my eyes, but I just couldn't find it.  Only thing I saw
> was their claim that they have now changed their licensing scheme to user
> and cpu units but I wanted the the rates.
>
> I need to know, besides (or before) calling Oracle, what the licensing rates
> are now for 8.0.5 Standard and Enterprise Editions and whether there's
> additional costs for opening up our database to Internet users.
>
> Thanks,
>
> George
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: George Hofilena
>   INET: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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).

--

Byron Pearce mailto:[EMAIL PROTECTED]
Tenure Systems, Inc. Arlington, Texas

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


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Byron Pearce
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).



Re: Root to connect as system

2001-10-30 Thread Byron Pearce

Joe:

I have a vague, hazy recollection of that as well.  Way back under v6 (when men
were men and sheep were nervous :-) ), I think I recall reading that the root user
was forbidden to do a "connect internal" to the database even if a member of the
"dba" group.  I remember having to setup an account to be used, but that may have
been specific to our port (DEC Ultrix).

Ah, yes.  The days of SQL*DBA (didn't even have to "connect internal" to
startup/shutdown the database back then). . .

Actually, I just ran a really quick test under Linix and it wouldn't take.  This
was under v8.1.7.  I will have to get access to some other systems tonight to see
if it is true for v7/v9 and other OS's such as Solaris and HP-UX.

Joe Testa wrote:

> my question is "why are you insisting on root logging into the
> database???"  create a new userid to do the connection.
>
> i thought i remembered somewhere about root not being able to login,
> maybe that was back and hardcoded for svrmgrl.
>
> joe
>
> Sujatha Madan wrote:
> >
> > Ok, I have solved the issue of the listener, however I still cannot get root
> > to log on as system.
> >
> > - My Oracle home is set correct
> > - My Oracle sid is set correct
> > - ld library path is correct
> > - other path;s are correct
> >
> > does anyone have an idea on how to fix this?
> >
> > thanx
> >
> > -Original Message-
> > Sent: Tuesday, 30 October 2001 1:40 PM
> > To: Multiple recipients of list ORACLE-L
> >
> > I have set the SID correct and all the environment variables correctly. What
> > I didn't do was set up the listener and tnsnames. However, when I am trying
> > to set up the listener, for some reason it is not able to find the
> > executables. It is looking in a different directory. The Oracle Home is set
> > correctly.
> >
> > -Original Message-
> > Sent: Tuesday, 30 October 2001 12:20 PM
> > To: Multiple recipients of list ORACLE-L
> >
> > Looks like your oracle sid is set incorrectly and you
> > are trying to connect without using a tns service name
> >
> > Deepak
> >
> > PS: have you set the env variables .. type env at the
> > unix prompt and check if PATH /ORACLE_HOME/
> > LD_LIBRARY_PATH are set correctly
> >
> > --- Sujatha Madan <[EMAIL PROTECTED]>
> > wrote:
> > > Hi,
> > >
> > > How can I allow root to connect to the database as
> > > system. At the moment
> > > when I try this, I keep getting a ORA-01034: Oracle
> > > not available error,
> > > even though the database is up and running fine.
> > >
> > > Regards,
> > >
> > > Sujatha
> > > --
> > > Please see the official ORACLE-L FAQ:
> > > http://www.orafaq.com
> > > --
> > > Author: Sujatha Madan
> > >   INET: [EMAIL PROTECTED]
> > >
> > > 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: [EMAIL PROTECTED] (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).
> >
>
> --
> Joe Testa
> Performing Remote DBA Services, need some backup DBA support?
> For Sale: Oracle-dba.com domain, its not going cheap but feel free to
> ask :)
> IM: n8xcthome or joen8xct
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Joe Testa
>   INET: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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).

--

Byron Pearce  

Re: SqlPlus connection timeout

2001-10-03 Thread Byron Pearce

Rohini:

I would take a look at the Oracle profiles.  There is a setting for idle
time and total connect time that you can set which will disconnect the
session.

"Krishnapura, Rohini" wrote:

> Is there a timeout parameter for connecting to Sqlplus?
> If yes, where can this be edited and configured?
>
> Please let me know.
>
> Thanks,
> Rohini
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Krishnapura, Rohini
>   INET: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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).

--

Byron Pearce mailto:[EMAIL PROTECTED]
Tenure Systems, Inc. Arlington, Texas

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


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Byron Pearce
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).



Re: Comparing data between two tables in two schema

2001-10-01 Thread Byron Pearce

If you are looking for Third Party tools then I would suggest "Schema
Manager" from Quest.

"Rao, Maheswara" wrote:

> List,
>
> I have two schema.  The tables in both schema are having same name and
> structures.
>
> Is there any tool to compare the data between two schema tabels?
>
> Thanks,
>
> Rao
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rao, Maheswara
>   INET: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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).

--

Byron Pearce mailto:[EMAIL PROTECTED]
Tenure Systems, Inc. Arlington, Texas

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


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Byron Pearce
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).



Re: Are RAID 1+0 and 10 the same thing?

2001-09-20 Thread Byron Pearce

Eduard:

As Gaja points out, most of the implementations are vendor specific and
the term is used quite interchangably most of the time.  From a purist's
perspective, however, there are some subtle differences.  This amounts to
splitting hairs, but just for the sake of discussion, in RAID1+0 the disks
are mirrored first and then striped; in RAID0+1 implementations the disks
are first striped and then mirrored.

For the most part, this is more of an issue of fault tolerance than
anything else.  Follow me with a ten disk example (X1 - X5 and Z1 - Z5):

X1Z1

X2Z2

X3Z3

X4Z4

X5Z5

If we chose RAID0+1, then we would create a striped volume on X1 - X5 and
on Z1 - Z5.  Each of these striped volumes would be seen as a virtual disk
and then those two striped disks would be mirrored (often this is done at
the hardware level, though it can be done through software VM's as well).
Now, in the event of a failure for a normal RAID0 set we know that because
of the way that the data is laid out the RAID0 set cannot lose a single
disk without losing the entire stripe.  The striping is done to achieve
higher I/O rates, but at the cost of increased likelihood of failure (it
is more likely that 1 disk out of 5 will fail than 1 disk out of 1).  By
mirroring, we insure that if we lose a disk in our first stripe,
everything is still mirrored on the second stripe and progress will go on
unabated.  However, if we were to somehow lose a disk on the first stripe
and the second stripe then we would lose all of the data on this RAID0+1
disk and be forced into a recovery.  It does not happen often, but it does
happen.

In RAID1+0, the difference is that each of the individual disks are
mirrored first (X1 & Z1, X2 & Z2, X3 & Z3, X4 & Z4, X5 & Z5) and then
those disks are seen as virtual disks.  Those mirrored virtual disks are
then setup as one striped volume.  Like RAID0+1, this can be hardware or
software driven.  In any event, the difference is that in order for us to
lose data we would have to lose both sides of the mirror on an individual
disk mirror (for example, X3 & Z3).  In fact, we could lose all of the
disks Z1 - Z5 and the data would still be accessible because of X1 - X5.
This is because it is a stripe of mirrors vs. a mirror of stripes.  As I
mentioned before, this is really splitting hairs and this is only a
purist's perspective.

Again, these terms are used pretty interchangably and you should ask the
vendor for more specific details on what that means to them.  I agree with
Gaja that vendors will implement these differently.

"Shevtsov, Eduard" wrote:

> Hi List,
>
> is there any difference between 1+0 and 10?
>
> Regards,
> Ed
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Shevtsov, Eduard
>   INET: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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).

--

Byron Pearce mailto:[EMAIL PROTECTED]
Tenure Systems, Inc. Arlington, Texas

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


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Byron Pearce
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).