Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: RAC for Reporting...!
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