no. of connection

[kannan vinayagam Duraiswamy]

is it possible to find the no. of connection opened by the DB(oracle).

[vanlalhmangaiha khiangte]

Hi ,
Do you mean the sessions ?

You can do it thro

  select * from v$session where status='ACTIVE'  

Hope this helps .

[kannan vinayagam Duraiswamy]

ok...i connected oracle using below params
export oracle_sid=.....
export oracle_home=..path...
...path...sqlplus username/password...

it becomes like..
SQL>

i exceute the query..but it says..
ORA-00942: table or view does not exist

any idea...

[vanlalhmangaiha khiangte]

Login as the system administrator.

[ken zhu]

vanlalhmangaiha khiangte wrote:Hi ,
Do you mean the sessions ?

You can do it thro

  select * from v$session where status='ACTIVE'  

Hope this helps .

i don't know whether you are familiar with java, since i aslo have a question:
what the relation between oralce session and java connection, i mean whether i open a connection in java program then oralce have a active session and if i close conneciton then the session will become inactive or non-display.

thanks.

[Jan Cumps]

i mean whether i open a connection in java program then oralce have a active session and if i close conneciton then the session will become inactive or non-display.

Yes. When you create a jdbc connection, you create a database session. When you close your jdbc connection, the corresponding database session is closed too.