Determining how many server processes are started
WilhelmSep 28 2007 — edited Sep 28 2007I want to determine how many server processes are started to serve incoming connections in DEDICATED configuration, I have two choices:
1)SELECT COUNT(1) FROM V$SESSION WHERE USERNAME IS NOT NULL;
2)select count(program) from v$process where UPPER(PROGRAM) LIKE '%ORACLE<SID>%';
Which one is more accurate?
On oracle documentation Oracle Database Reference 10gR2(B14237-02), for the description of PROGRAM column in v$process, it only says 'Program in progress'. So i am worried, that the PROGRAM column will show background processes as well(which i don't want to know)