Is there any way to get the number of current open session for a particular user without having access to v$session or any dba tables?
You can get the number of sessions by the following OS commands
netstat -an | grep (database port) | wc -l