How to determine . . . 
Author Message
 How to determine . . .
My manager wants to review our licensing structure and has asked me to
determine the max or average number of concurrent users.   I've poked
around but can't find anything on that.  

Alex, I'd like to buy a clue . . .
--
Ed Stevens
(Opinions expressed do not necessarily represent those of my employer.)



Wed, 24 Mar 2004 01:33:02 GMT
 How to determine . . .


Quote:
> My manager wants to review our licensing structure and has asked me to
> determine the max or average number of concurrent users.   I've poked
> around but can't find anything on that.

> Alex, I'd like to buy a clue . . .
> --
> Ed Stevens
> (Opinions expressed do not necessarily represent those of my employer.)

Ed,
If you would enable audit and audit sucessfull connects you will have a
trail in the database of all sessions.
Now I leave the most difficult part to you: write some pl/sql to determine
how many *concurrent* users (and of course you need the max of that or Larry
will sue you for cheating. Note: I always exclude Oracle provided users in
such calculations)

Hth,

Sybrand Bakker, Senior Oracle DBA



Wed, 24 Mar 2004 03:20:51 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. How to determine what form of origin to update - How to determine what other forms are currenlty shown?

2. Determining adp usage

3. Determining if a stored procedure is already running.

4. combining records and determining record count

5. Can you use parameter to determine flow-of-control

6. How to Determine Database Connected Users

7. SQL Server - Determining Permissions

8. how to determine if field value has changed?

9. Determining Nullable Columns

10. How to determine where error code come from ?

11. How to determine fragmentation via a SP

12. Need help determining the length of a string.


 
Powered by phpBB® Forum Software