Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: RAC for Reporting...!

Re: RAC for Reporting...!

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Thu, 06 May 2004 09:46:04 -0700
Message-ID: <1083861964.570430@yasure>


Matt wrote:

> [SNIP]
> However this will have its own problems because Query users will force
> inter node block transfer to occur which will add a large performance
> overhead to the application. (And some of the users' queries are
> absolute nightmares in terms of LIOs).
>
> Matt

Interblock transfers are the only negative I can see in your proposal.

What is it about "some of the users' queries" that causes this? Can you change the architecture or the queries in such as way as to eliminate or minimize the issue?

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Thu May 06 2004 - 11:46:04 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US