Skip to content

Package with pl\sql scripts designed to analyze the performance reports of the Oracle 18c database. Reports come from the Statspack tool.

Notifications You must be signed in to change notification settings

martamazurkiewicz/report_diff_analyzer

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

15 Commits
 
 
 
 
 
 
 
 

Repository files navigation

report_diff_analyzer

This package aim is to compare 2 Statspack reports. It must be added to Oracle Database as package. It can be executed with SQL*PLUS. All scripts are written in PL\SQL with C fragments. PERFSTAT schema is required for this package.

Granting privileges to scripts from this package

Firstly, it is necessary to grand PERFSTAT (and probably SYS) USER privileges to directory with report_diff_analyzer scripts. It is done by creating Oracle directory object associated with physical directory

CREATE OR REPLACE DIRECTORY scripts_dir AS '/home/admin/scripts/';

and granting read and write privileges to appropriate users

GRANT READ,WRITE ON DIRECTORY scripts_dir TO perfstat,sys;

About

Package with pl\sql scripts designed to analyze the performance reports of the Oracle 18c database. Reports come from the Statspack tool.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages