Is it possible to generate a report with CPU,Memory,Elapsed Time for each session opened in Oracle?
Hi, Ladies and Gentlemen!
To check one of our application resource's allocation, we need to generate a report with the following informations:
[1]. User/Schema of the session
[2]. Total amount of CPU allocated by the session of item [1];
[3]. Total amount of Memory allocated by the session of item [1];
[4]. Total amount of disk access allocated by the session of item [1];
[5]. Data/time when the session of item [1] has been logged in database;
[6]. Data/time when the session of item [1] has been logged out of database;
[7]. Total amount of time(s) allocated by the session of item [1];
(*) the main reason for this kind if report, is because we are not so sure if this application (at first, only perform small queries) is thresholding our database, since we have another application (this one, our main one) runing for this same database.