Oracle8i database is runnig on UNIX HP9000 machine which has six processors in it. Is there any way to tell oracle to use all six processors when I do the dataloading in oracle tables.
Is it a oracle specific setting or UNIX related settings?
Please help me.
Thanks.
Jain
Oracle 8i automatically detets the available cpu.
Use CPU_COUNT parameter.
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 '%¶meter%'
new 6: WHERE name like '%cpu%'
Session System
NAME VALUE Modifiable Modifiable
-------------------------------------------------- ---------------------------- ---------- ----------
cpu_count 12 FALSE FALSE
if the underlying OS (ie. Linux) doesn't have (or doesn't have decent) SMP support will Oracle still be able to take advantage of SMP? or is Oracle's ability to use mulitple processor dependent on the underlying OS?
If the underlying OS does not support SMP, then Oracle will not able to use it.
Quote:
Originally posted by tamilselvan
If the underlying OS does not support SMP, then Oracle will not able to use it.
whats SMP????????? and whats it there for.
MULTIPLE PROCESSOR