Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> 2 Basic questions
Oracle 7.2.2.3
We have about 60 users. Basicaly they work with SQL*forms 3. We have very-very few SQL*Net users. Is there any good in turning on multi-threaded server? Is there any good in next line in init.ora file: mts_dispatcher="ipc,1" ?
2. Parallel options.
We have 2-processors server. Out OS (HP-UX 10.0) works fine with 2 processors. Is there any good in turning on ORACLE parallel options? I tried it, but with no visible result. I put in init.ora next lines: parallel_default_max_scans = 4 (isn't it a number of processors?) parallel_default_min_servers = 4 parallel_default_max_servers = 16 parallel_default_scansize = 1000 I expected to see 2 or 4 ora-processes (ps command) on any SELECT statement, but I only see I ora-process as it was without parallel options. Where is my error? Is parallel option tied to multi-threaded server?Received on Sat Dec 28 1996 - 00:00:00 CST
![]() |
![]() |