Is there any way to tell oracle to use all available processors on a machine ?

[mrvajrala]

I think its from version 8

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle8 Enterprise Edition Release 8.0.4.4.0 - Production
PL/SQL Release 8.0.4.4.0 - Production
CORE Version 4.0.4.0.0 - Production
TNS for Solaris: Version 8.0.4.0.0 - Production
NLSRTL Version 3.3.1.0.0 - Production

SQL> @param
Enter value for parameter: cpu
old 6: WHERE name like '%&parameter%'
new 6: WHERE name like '%cpu%'

Session System
NAME VALUE Modifiable Modifiable
-------------------------------------------------- ---------------------------- ---------- ----------
cpu_count 12 FALSE FALSE