Skip to content

ora600pl/jas-min

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

20 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

jas-min 0.1.0

Kamil Stawiarski kamil@ora-600.pl

This tool will parse STATSPACK or AWR report into JSON format which can be used by visualization

tool of your choice. The assumption is that text file is a STATSPACK report and HTML is AWR. The

tool is under development and it has a lot of bugs, so please test it and don't hasitate to suggest

some code changes :)

JAS-MIN has also possibility of drawing basic plots using plotly library.

USAGE:

jas-min [OPTIONS]

OPTIONS:

-d, --directory <DIRECTORY>    Parse whole directory of files [default: NO]

-f, --file <FILE>              Parse a single text or html file [default: NO]

-h, --help                     Print help information

-o, --outfile <OUTFILE>        Write output to nondefault file? Default is directory_name.json

-p, --plot <plot>              Draw a plot? [default: false]

-s, --server <SERVER>          Run in server mode - you can parse files via GET/POST methods.

                               HTTP will listen on 6751 port by default [default: 0.0.0.0:6751]

-V, --version                  Print version information

If you choose to plot a chart, you will see a basic distribution of DB Time vs DB CPU, distribution TOP 5 wait events from the times, when DB CPU was less then 66.6% of DB Time plus some TOP SQLs by Elapsed Time, sorted by amount of occuriance.

About

JSON AWR Statspack Minier

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published