Database Administration (MOSC)

MOSC Banner

Is it possible to generate a report with CPU,Memory,Elapsed Time for each session opened in Oracle?

edited Nov 13, 2020 3:10PM in Database Administration (MOSC) 3 commentsAnswered ✓

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center