Monitoring Disco Usage during the working day
Hello everyone,
In my organisation we use Discoverer 10g (10.1.2) and have a large userbase (approx 1000), typically perfomance suffers at month end a peak usage time for the system.
Last month we approached users and asked them to record their experiences in timings when running and exporting the reports, this has been good in getting a general view of how things are but not giving me what I ideally want in terms of detail.
I was wondering if anyone could give me direction in how to obtain the kind of information I am wanting including:
1. A view on activity at any point - see what queries are running, by who and how long they have ran for.
2. See how many user Disco sessions are in progress.
3. Any detail on times against individual reports in terms of running, exporting and estimates given.
I have just recently been given SQL access to our system and have a smalll knowlege of SQL so would appreicate any help that can be given to help me get at this info as I am sure it is somewhere in the system.
I am in the process of getting our 3rd party guys to install the EUL workbooks and make these available to me - request has taken 2 months so far though so if I can get this data through SQL myself it would make my life much easier.
if anyone has any general comments on performance and ways to monitor I would be intersted to hear them!