Schedule Statspack Report Generation.

Declaration : In this scripts using for schedule statspack report generation for hourly, frequently and purge weekly snapshots. Statspack is instead of AWR because AWR report is licensed.   ...

Query to find ASM Error details.

Description: This script is used for finding ASM error details on ASM disk. script: select io.inst_id , dg.name diskgroup_name , io.disk_number , d.name disk_name –, d.label , d.read_errs , ...

query to find top sort segment usage.

Description: This query belongs to find the top sort segment usage on oracle. Script: col sid format 999999 col spid format a6 col tablespace format a10 col username format a25 col noexts format ...

Start typing and press Enter to search