If you want to perform load analysis on how many concurrent request were run each day, the script below was useful to provide such information.
SQL> SELECT sysdate -1, COUNT(*)
WHERE to_char(actual_completion_date,'YYYYMMDD') =
(SELECT to_char(sysdate -1,'YYYYMMDD') FROM dual);
This script will only provide the number of completed concurrent request.
Next» Total DB Tablespace Size