Link to home
Start Free TrialLog in
Avatar of taaz
taaz

asked on

Running application

How to find how many applications are running in oracle.?


Avatar of schwertner
schwertner
Flag of Antarctica image

Counting the sessions.

SELECT count(*) from v$session;
 You can analyze further looking the IP,s and other columns
in this view
Avatar of taaz
taaz

ASKER

what could be reason when an application failed to start in oracle.
Oracle is running but one of the application is failing to start
Whats the error message?
ASKER CERTIFIED SOLUTION
Avatar of schwertner
schwertner
Flag of Antarctica image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of taaz

ASKER

thanks Schewrtner
Good luck!