Home » RDBMS Server » Server Administration » Oracle XE 10 so many oracle processes
Oracle XE 10 so many oracle processes [message #366198] Fri, 12 December 2008 01:37 Go to next message
macus
Messages: 1
Registered: December 2008
Junior Member
I have 2 Oracle servers, one is installed with Oracle 9.0.2, the other is installed with Oracle XE 10. Both are running on Linux
The oracle instance of the Oracle XE is OracleXE. I found there are so many running OracleXE process (200 or more) of the ORacle XE by executing "ps ux" . But, I only found 10 or more running <Oralce SID> process of the Oracle 9.0.2.
The no. of processes of both Oracle are defined to 400 in the spfile.
So, how can I decrease the no. of Oralce XE process showing in the OS?
Thanks.
Re: Oracle XE 10 so many oracle processes [message #366228 is a reply to message #366198] Fri, 12 December 2008 03:32 Go to previous message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Depends on what those processes are.

Every user / program that connects to the database starts a process, for example. So you could ask the user not to use the database. Wink

How many users are connected to both database?

( Do a select on v$session )
Previous Topic: ORA-01502
Next Topic: ORA-01034 only for EM Console?
Goto Forum:
  


Current Time: Sat Dec 10 16:33:47 CST 2016

Total time taken to generate the page: 0.10830 seconds