If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

When I log on to the Database using DBA Studio I see 12 active sessions . 1 is for DBA Studio and 11 of them are the background processes.

What are these background processes. Can u please list them?

Is their any significance for all the background processes to have the serial# as 1? What if the serial# for background processes 7 thro' 10 (and these processes do not specify any OS info or username or the program which it is using) are something other than 1? Is there something wrong with the database?

Now after i stopped the OMServer and data gatherer the list has trimmed to 11 so all JRE is created during the above 2 services.

For 7-10 it shows as user process i saw in the process list of task manager it shows

ORADIME.EXE ,owastsvr.exe,TNSLNR.EXE,Launch.exe are running so probably this should be that ....This are oracle exe i think identified as a process in v$session.I also checked whether any other oracle exe are running other than the above nothing.

By Checking all the oracle Exe's available in Bin dir.

In your condition of DBA studio please check it what process running from Task manager may be some more oracle exe'd requ for that.

Expecting your feedback on this.

If i am wrong please correct me.

Of course the SQLPLUSW.EXE you know the session i work on.(user process).

Cheers

Padmam

[Edited by padmam on 05-04-2001 at 12:12 PM]

Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it

Yes, that is correct. The sadest part on Bills product is it would just say that it was background process. I so far I haven't found a way to associate those backgroud proceess to the process names. In any Unix or Linux, you can see the processes with the names and they get tagged with the SID. As a result you can easily associate the procees to the operation they perform.

Now, if you have the MTS setup say that you have set 2 dispatchers and 10 servers to start. YOu would see an increase in the bg processes. If you are in the unix env, then you would see ora_s000_SID,... ora_s009_SID, and ora_d000_SID, .. ora_d002_SID and so on. IF you have more than one archive destination, then your archiver process would be those count. On the other hand if you have a dedicated server setup and then you would see an increase in the db writer processes.