Ryan
NetApp is in another class of devices labeled NAS for Network Attached
Storage. Because its connection with your server runs over a network
connection, the performance is very much dependent on the speed and
configuration of the network connection.
As has been explained to me, and I
: 212-358-8211 x 359
http://www.gridapp.com
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of DENNIS WILLIAMS
Sent: Friday, September 19, 2003 11:30 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Re: max parallel query
Ryan
NetApp
://www.gridapp.com
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of DENNIS WILLIAMS
Sent: Friday, September 19, 2003 11:30 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Re: max parallel query
Ryan
NetApp is in another class
:
.com Subject: RE: Re: max parallel query
PROTECTED]cc:
.com Subject: RE: Re: max
parallel query
09/19/2003 11:49
AM
Please respond
-220-3551
Phone: 212-358-8211 x 359
http://www.gridapp.com
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Goulet, Dick
Sent: Friday, September 19, 2003 1:50 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Re: max parallel query
Matt
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Goulet, Dick
Sent: Friday, September 19, 2003 1:50 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Re: max parallel query
Matt,
Question: What else do you have running on your
Hrrrmmthe on-topic-ness of this has strayed far from Oracle. My
apologies.
Not sure I agree with the last statement... I think it is on topic... Many
of us DBA types are often involved in these kinds of discussions internally
and the more informed we are the better off we are... It
i know there are no magic formulas, but im hoping for something better than trial and
error. i would assume that parallel query helps most when:
1. are doing work off of multiple mount points.
2. Have alot more LIOs to perform than PIOs(such as sorts).
am i close on this?
From: M Rafiq
If you want rules of thumb, then take CPU_COUNT+1 up to CPU_COUNT *2.
I think LIO PIO ratio is irrelevant, the most important is whether you are
able to construct optimal parallel execution plan, e.g. avoid excessive
parallel slave messaging waiting. This is mostly design and SQL issue.
The
hmmm... when i run statspack during a big load. most of my waits are from
redo log waits and read from a staging datafile. we have all of our
datafiles on the same I/O mount. We are using a Network Appliance back end
with asynch I/O.
are you telling me that putting these files on seperate mount
Ryan
You are probably bottlenecking on the NetApp. Probably your network link
to it. If you have some regular (a.k.a. direct attached) disk available,
consider using it for your redo logs.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
If different mount point means different disk spindle group or different
disk array, then of course, your performance will be improved, but if we
talk about the same box, same number of disks just split to two or three,
you probably won't get any performance increase. One disk spindle still
i dont manage the netapp and am not a hardware person. could you explain a
little better? Is netapp similiar to SAN?
what is asynch I/O?
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, September 18, 2003 6:24 PM
Ryan
You are probably
Netapp is NAS afaik, that means a bunch of disks used over fast network.
SAN is a bunch of disks used over SCSI or Fibre interface (EMC Clariion for
example). I tend to trust and appreciate SAN more than NAS, but NAS can be
more cost effective in small-to medium environments.
What I meant, is
15 matches
Mail list logo