Re: What is ORACLE.EXE (PXXX) ???

From: David Fitzjarrell <oratune_at_msn.com>
Date: 26 Oct 2001 07:33:57 -0700
Message-ID: <32d39fb1.0110260633.181a8d7f@posting.google.com>

I would check your init<SID>.ora file as you have parallel query enabled and have parallel query servers running, four of them to be exact. To see which ones are in use you can query the V$PX_PROCESS view; sample output from this query follows:

SQL> select * from v$px_process;

SERV STATUS PID SPID SID SERIAL ---- --------- ------ --------- ------ ------

P002 IN USE        16 16955         21   7729 
P003 IN USE        17 16957         20   2921 
P000 IN USE        12 6999          18   4720 
P001 IN USE        13 7004           7    234

4 rows selected.

There are two parameters that determine how many parallel query servers may be running, PARALLEL_MIN_SERVERS and PARALLEL_MAX_SERVERS. PARALLEL_MAX_SERVERS sets the upper bound for the number of parallel query servers Oracle will run. PARALLEL_MIN_SERVERS sets the minimum number of parallel query servers Oracle will start. I would imagine that in your init<SID>.ora file you have:

parallel_min_servers = 2
parallel_max_servers = 5

This would produce the four parallel query servers you see in V$SESSION. But simply because the init<SID>.ora parameters are set does not mean that parallel query is automatically enabled. It must be enabled at the table level, either at table creation or by using ALTER TABLE: ALTER TABLE <tablename> PARALLEL [DEGREE X];

Apparently you have one or more tables set for parallel query since the query servers are running. You can verify this with the following query:

select table_name, degree from user_tables;

As long as DEGREE is not set to 1 parallel query is enabled. If no specific DEGREE has been set you'll see a value of DEFAULT. This is all explained quite well in the documentation.

mail_for_deja_at_yahoo.com (Anonymous) wrote in message news:<8ee5d7c9.0110260139.a66d2d_at_posting.google.com>...
> When I issue "select terminal, username, program from v$session", I
> see:
>
> TERMINAL USERNAME PROGRAM
> ---------------- ------------------------------
> ------------------------------
> HELLO1 ORACLE.EXE
> HELLO1 ORACLE.EXE
> HELLO1 ORACLE.EXE
> HELLO1 ORACLE.EXE
> HELLO1 ORACLE.EXE
> HELLO1 ORACLE.EXE
> USER1 SYSTEM F45RUN32.EXE
> USER1 SYSTEM ORACLE.EXE (P000)
> USER1 SYSTEM ORACLE.EXE (P002)
> USER1 SYSTEM ORACLE.EXE (P003)
> USER1 SYSTEM SQLPLUSW.EXE
> USER1 SYSTEM ORACLE.EXE (P001)
>
> What is "ORACLE.EXE (PXXX)"? I found that SYSTEM only login one
> session with SQL*Plus and one session with Oracle Forms Runtim, but
> why there are four ORACLE.EXE (PXXX)? (Oracle8i on Windows 2000,
> client is Windows 98)
>
> David
Received on Fri Oct 26 2001 - 09:33:57 CDT