aspose file tools*
The moose likes Oracle/OAS and the fly likes no. of connection Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "no. of connection" Watch "no. of connection" New topic
Author

no. of connection

kannan vinayagam Duraiswamy
Ranch Hand

Joined: Jan 12, 2009
Posts: 52
is it possible to find the no. of connection opened by the DB(oracle).



Kannan.DV
vanlalhmangaiha khiangte
Ranch Hand

Joined: Sep 11, 2006
Posts: 170
Hi ,
Do you mean the sessions ?

You can do it thro



Hope this helps .
kannan vinayagam Duraiswamy
Ranch Hand

Joined: Jan 12, 2009
Posts: 52
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

Joined: Sep 11, 2006
Posts: 170
Login as the system administrator.
ken zhu
Greenhorn

Joined: Apr 09, 2009
Posts: 20
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

Joined: Dec 20, 2006
Posts: 2510
    
  10

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.


OCUP UML fundamental and ITIL foundation
youtube channel
 
 
subject: no. of connection