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