Re: Parallel Query Option

Atul Ashar wrote:

> I need some info about spreading tables across different datafiles of a
> tablespace to reduce contention.
>
> Our tablespaces are spread across three different devices (i.e. each
> tablespace has a file on each device). I would like to spread all tables
> across all the devices so that each process of parallel query option will
> read different datafiles.
>

Although 3 files on separate devices may give slightly better performance on single-user
access with PQO, your optimum strategy is to use the HP-UX Logical Volume Manager to
create a logical device that cycles around the 3 physical devices, with chunks of around
1MB per device. Received on Wed Jan 29 1997 - 00:00:00 CST