Database Administration (MOSC)

MOSC Banner

Sessions and processes issue

edited Jun 15, 2018 11:14AM in Database Administration (MOSC) 7 commentsAnswered

Using oracle 10.2.0.3 on Linux 64

here is the SQL I used to find processes not matching sessions
==========================================================
SQL> select inst_id,count(*) from gv$process where (inst_id,addr) not in (select inst_id,paddr from gv$session) group by rollup(inst_id) ;

INST_ID COUNT(*)
---------- ----------
1 3
2 3
3 6
12
==========================================================
Is this correct?
_
Yesterday before the server crash I saw values of up to 1600 for INST_ID = 2. At that moment 2100 - 2200 processes ran on the server (checked with ps -ef | grep oracle | wc -l and gv$process).
_
Now I'm concerned about processes having no sessions and what they are doing. I didn't have the possibility to check a particular process with strace or tracing it with ORACLE. Please comment on this.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center