Hi there,
I think you shold consider the Parallel Query Option. But
- It costs money (it must be licenced separately)
- It requires quite a bit of learning (manuals)
El-Hachemi ABDELHAK wrote:
>
> I have a 1GB RAM Solaris 2.5.1 machine with 4 cpus.
> How can I force Oracle7.3.2.3 to use the 4 cpus when running on large
> tables or when performing complex queries .
>
> Rgrds
>
> El-Hachemi ABDELHAK <abdelhak_at_montrouge.geoquest.slb.com>
> GAM Data Management / Systems Support
> Schlumberger GeoQuest
>
> El-Hachemi ABDELHAK
> GAM Data Management / <abdelhak_at_montrouge.geoquest.slb.com>
> Systems Support HTML Mail
> Schlumberger GeoQuest
> Work: (33) 01- 4746 6619
> Netscape Conference Address
> Netscape Conference DLS Server
> Additional Information:
> Last Name ABDELHAK
> First Name El-Hachemi
> Version 2.1
Received on Fri Oct 09 1998 - 06:41:37 CDT
