We're thinking of moving a client application to Citrix because of ongoing issues with clients on workstation. We'll probably have to purchase more Citrix, TS-RDP etc licenses if we do this, and I want to find out the max connected users over a period of time.
The application connects to the database with one account, so the query I want to run is a simple "select username, count(*) from v$session where username = 'x' group by username"
What I want to do is run this query over a couple of days, repeating every 5 minutes, spooling output to a text file.
Would I use dbms_lock to do this or is there wait or sleep function I can use?
Database is 11.2.0.1
thanks