NO OF ACTIVE USERS in db

1 ANSWERS

1. Tayyab
   

   If you are using SQL Server then following will help you to find number of active users in a DataBase select db_name(dbid),count(*) from master..sysprocesses where spid > 49 AND db_name(dbid)='DATABASE NAME' group by db_name(dbid) Note: SPID below 50 is SQL Server itself

   Report (0) (0)  |   3 years, 3 month(s) ago  

• connecting to oracle 10g using oracle 8i session
  I am having problem with connecting to oracle 10g database from an oracle 8i session. I am using the following comm...
  Answers: 2
• NO OF ACTIVE USERS in db
  Answers: 1
• Database Administration. How to find number of valid and invalid TRIGGERS, FUNCTIONS, PROCEDURES,
  How to find number of valid and invalid TRIGGERS, FUNCTIONS, PROCEDURES, PACKAGES, INDEXES, DB LINKS in a database?...
  Answers: 1
• Database Administration. what are queries to find number of tables and number of views in a
  what are queries to find number of tables and number of views in a database?
  Answers: 1