Scripts & Sample Tasks
This page has various useful PL/SQL procedures and the scripts required to incorporate each procedure as a task in Tascha. The latest version of Tascha is here
Download Tasks
| Task Script | Request Script | Description |
|---|---|---|
| segstats.sql | segstats_req.sql | Task that reports top segment statistics over a given time period. Two tasks are used - one for initial snapshot and another to produce report. *** 9i+ only *** |
| sesstats.sql | sesstats_req.sql | Task that reports session statistics using a supplied statistic name (v$statname.name). Two tasks are used - one for initial snapshot and another to produce report. |
| N/A | perfstat_req.sql | Task that schedules calls to Statspack. Requires that execute privilege on statspack package is granted to Tascha owner. |
| N/A | perfstat_analyze_req.sql | Task that schedules a call to dbms_stats.gather_schema_stats for the PERFSTAT schema. |
Other Useful Oracle SQL Scripts
| SQL Script | Description |
|---|---|
| N/A | None yet |