How to identify concurrent sessions...

[jlakhani]

Hello. I have been asked to produce a report of a total number of concurrent sessions in a given database..Initally it was

select count(*) into sessions from v$session where username is not null;

but that shows total number of sessions..
any ideas?

thx

[davey23uk]

deifn what you mean by concurrent sessions then. the count(*) from v$session is the number of sessions in the database as you say - are they not concurrent?

[pando]

add status = 'ACTIVE' ?