Hi Tom

As always thanks in advance.

Environment is 12c R2 SE.

1 -> Need help to build a script to monitor and collect the total execution time of multiple SQL_ID at different intervals of time. Please guide me the views or tables and linking between them.

Checked from v$SQL -- giving average from starting (can do the math of taking out incremental average and calculating from it but still some times giving multiple entries for same SQL.)

DBA_HIST_SQLSTAT empty.

example--
table 1 --> SQL_ID | Timestamp | total_time_taken_to_execute
table 2 --> SQL_ID | Timestamp | no._of_time_executed_in_last_1_hour

or single table

table 1 --> {SQL_ID | start time |end time } in last 1 hour

2 ->Need help to Find out How many times SQL_ID is executed and from which os_user in specific interval of time.

example--

table 3 --> {SQL_ID | start time | os_user } in last 1 hour

3 -> Any script for standard edition which according to you might help in proactive monitoring and performance.Help on 3rd point is highly appreciated.( As I know this question is not worthy of your time )

Regards
Vikas Dixit