Tags » Monitoring Scripts

Monitoring Query run time

1. Below Query is used to find the running query estimation.

select * from (select opname, target, sofar, totalwork,units, elapsed_seconds,to_char(START_TIME,’ dd-Mon-YYYY HH24:mi:ss’) START_TIME,
to_char(LAST_UPDATE_TIME,’ dd-Mon-YYYY HH24:mi:ss’) LAST_UPDATE_TIME, 156 more words

Monitoring Scripts

Monitoring tablespace reports in html

We need 2 scripts to perfom this. the first script wil call the secnd scripts to pull the report in HTML.

1. First script needs to have sys/system user pwd to pull database info, save the below file as DBANME_tablespace_rpt.sql . 488 more words

Monitoring Scripts

Redo Log file frequency per hour

Use the below Script to find out the log file switch frequency, It may help in planning redo log size and archive sizes. I did find some where on the net , this was helpful at times. 243 more words

Monitoring Scripts