Hello Gurus,

I have 9i on Windows 2000 box with 4 processors... There are some heavy and
big queries while running uses only single processor, which I feel is
loading that processor un-necessarily where the load can be shared by all
the 4 processors..

What I want to know from u all is, when I write the query, I can tell that
particular query to use all the 4 processors. How is it done?

E.g.: "Select /*+ 4, process" some thing like this, which I had forgot.

Can some one refresh me.

/- Vin

Oracle LazyDBA home page