File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/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: 2491
    
    8

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
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: no. of connection
 
Similar Threads
Try/catch variable scope
jdo and eclipse
enterprise application with many users
connection
J2ee app gets stuck at a stored procedure call