• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

no. of connection

 
kannan vinayagam Duraiswamy
Ranch Hand
Posts: 52
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
is it possible to find the no. of connection opened by the DB(oracle).


 
vanlalhmangaiha khiangte
Ranch Hand
Posts: 170
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi ,
Do you mean the sessions ?

You can do it thro



Hope this helps .
 
kannan vinayagam Duraiswamy
Ranch Hand
Posts: 52
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 170
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Login as the system administrator.
 
ken zhu
Greenhorn
Posts: 20
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
vanlalhmangaiha khiangte wrote:Hi ,
Do you mean the sessions ?

You can do it thro



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
Bartender
Posts: 2588
11
C++ Linux Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic