[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference smurf::ase

Title:	ase

Moderator:	SMURF::GROSSO

Created:	Thu Jul 29 1993
Last Modified:	Fri Jun 06 1997
Last Successful Update:	Fri Jun 06 1997
Number of topics:	2114
Total number of notes:	7347

2023.0. "OPS on Data Warehouse" by HGOVC::PATRICKNG () Fri Apr 25 1997 04:12

    Hi,
    
    Is it a good idea to implment Oracle Parallel Server on a Data
    Warehouse of at 600GB?
    
    I expect more read than write queries. 10 concurrent queries will be
    expected.
    
    I believe OPS provides load balance of 10 queries and high
    availability. OPS has overhead. Given more read transactions, does OPS
    improve performance?
    
    Thanks,
    Patrick

T.R Title User Personal
Name Date Lines

2023.1 Why not? NNTPD::"[email protected]" Dave Cherkus Fri Apr 25 1997 14:05 13

T.R	Title	User	Personal Name	Date	Lines
2023.1	Why not?	NNTPD::"[email protected]"	Dave Cherkus	`Fri Apr 25 1997 14:05`	13
	I have next to no field experience, but I did help support the use of OPS in a large data warehouse (read-intensive) benchmark, and I do believe Digital did win the business. I guess the question is: why not use OPS for a data warehouse application. You may want to ask in the ORACLE notesfile (BELFAST::ORACLE, last time I looked). They tend to be much better at this kind of question. Dave [Posted by WWW Notes gateway]

I have next to no field experience, but I did help support the use
of OPS in a large data warehouse (read-intensive) benchmark, and
I do believe Digital did win the business.

I guess the question is: why not use OPS for a data warehouse 
application. 

You may want to ask in the ORACLE notesfile (BELFAST::ORACLE,
last time I looked).  They tend to be much better at this kind
of question.

Dave
[Posted by WWW Notes gateway]