Personal tools
You are here: Home Oracle How To's How many applications are running on ORACLE ?
Navigation
Log in


Forgot your password?
 
Document Actions

How many applications are running on ORACLE ?

To view all applications which are running on oracle database



The statement below lists all active applications on oracle database


set lines 120
set pages 100
COLUMN owner FORMAT A15
COLUMN username FORMAT A20
COLUMN object_owner FORMAT A20
COLUMN object_name FORMAT A30
COLUMN locked_mode FORMAT A15
column os_user_name format a15
SELECT b.session_id AS session_id,
NVL(b.oracle_username, '(oracle)') AS username,
a.owner AS object_owner,
a.object_name,
Decode(b.locked_mode, 0, 'None',
1, 'Null (NULL)',
2, 'Row-S (SS)',
3, 'Row-X (SX)',
4, 'Share (S)',
5, 'S/Row-X (SSX)',
6, 'Exclusive (X)',
b.locked_mode) locked_mode,
b.os_user_name
FROM dba_objects a,
v$locked_object b
WHERE a.object_id = b.object_id
ORDER BY 1, 2, 3, 4;


Security Awareness
Would you like your company to implement gamification into your security awareness program?





Polls