• show max number of connections allowed 

    select name,value from v$parameter where name = 'sessions';

  • show current active connections 

    select count(*) from v$session;