dbaspot
Tags Register FAQ Calendar Search Today's Posts Mark Forums Read

Oracle Processes - Oracle Database

This is a discussion on Oracle Processes - Oracle Database ; Hi, How to find out number of concurrent processes at any point of time in 10g ? Thns in advance Bye Sabya...


Home > Database Forum > Oracle Database > Oracle Processes

Reply

 

LinkBack Thread Tools Display Modes
  #1  
Old 06-08-2009, 07:48 AM
Database Newbie
 
Join Date: May 2008
Posts: 1
dba_sabya_niit is on a distinguished road
Default Oracle Processes

Hi,

How to find out number of concurrent processes at any point of time in 10g ?

Thns in advance
Bye
Sabya
Reply With Quote
  #2  
Old 10-20-2009, 01:25 AM
Database Newbie
 
Join Date: Oct 2009
Location: India
Posts: 19
giteshtrivedi is on a distinguished road
Default Re: Oracle Processes

Hi,

You can find out concurrent processes using following query.

select count(*) from v$session where username is null;
__________________
Thanks and Regards,
Gitesh Trivedi
Dbametrix Solutions
Reply With Quote
Reply

Thread Tools
Display Modes



All times are GMT -4. The time now is 11:50 PM.