Re: Parallel Server on Windows NT

Martinho Pinto wrote:
>
> Has anyone used or heard of Oracle Parallel Server running on Wiindows
> NT. We would be glad to hear about your experiences with Oracle Parallel
> Server

You might be thinking of Oracle Parallel QUERY.

The Parallel Server option allows multiple machines each running a database instance of a single global database. Parallel Server is designed more for Clusters of machines rather than SMP machines. I don't think that anyone has an NT Cluster available yet. Do they?

Parallel Query is a different option in that it allows a single query to be transparently dismembered and farmed out to multiple processes to do their portions of the query. The result is later combined and returned. This will work nicely on a multi-cpu (ie SMP) NT box.

There are limitations to its usefulness though. Best suited to large long running querries that involve full table scans. Warehouse and Decision Support type systems.

Bruce...

--
  -----------------
   T T T T T T T T        Bruce Pihlamae
   I I I I I I I I        bpihlama_at_nla.gov.au
   I I I I I I I I        National Library of Australia
   T T T T T T T T        Phone: +616 262-1575
  -----------------       Fax:   +616 273-2116
 ===================
 "If you swallow a live frog first thing in the morning;
  nothing worse will happen to either of you that day."