Discover jkstill/oerr Open Source project by Jared (@jkstill)

Scripts for collecting, aggregating and charting Oracle ASM Metrics

141

asm-metrics

scripts for working with sar data

sar-tools

Extract CSV data from HTML AWR reports

awr-html-extract

Scripts for use in my Pythian blog on tracefile_identifier

tracefile_identifier

Histogram

A small script to retrieve some publicly available free SQL tuning tools for Oracle.

get-free-sql-tools

Tools for working with CSV data

csv-tools

A bash script used to help verify and configure HugePages for Oracle on Linux

memory-verify

Gather CPU metrics as Average Active Sessions per collection of databases.

cpu-aas

Create self-expiring AWR baselines based on the top activity found in AWR

oracle-baselines

example getopts scripts for bash

getopts-bash

Get the network latency from one database to another

db-ping

PLpgSQL

sys-context

Track space usage in ASM.

asm-space

scripts and information regarding linux timekeeping

linux-time

Oracle DBMS_STATS operations

statops

Perl Data Unloader for Oracle

dunldr

Scripts and demos for Oracle Stack Trace analysis

stack-trace-analysis

Check local or remote server (via ssh) for Intel Skylake and Kaby Lake HyperThread bugs

ht-bug-detector

Debugging packages for PL/SQL

debug-pkg

PLpgSQL

systemd-service-example

Example of creating a system service with systemd in linux

My SQL environment for client work. sql scripts, .vimrc ,etc

sql-environment

Shell and SQL for capturing useful information during high load periods

load-monitors

automatically prevent reboots under certain conditions

systemd-abort-shutdown

Code for doing things with hex - dump to, convert from. All Oracle at this time.

hexadecimal

Test scripts for various types of Oracle Partitioning

oracle-partitioning

Perl script to run multiple SQL statements from a variable number of connections.

sqlrun

functions to create Bash constants.

bash-constant

Analyze indexes and look for redundant indexes.

index-compare

Perl and (mostly) Java utilities for listing and retrieving trace files from remote Oracle servers, including Amazon RDS

tracefile-retriever

Examples of timing out queries in the database from Perl DBI

DBI-query-timeout

Files from Oracle Net Troubleshooting for DBA's

sqlnet-troubleshooting

remove duplicate addresses from address data

fixdup

Dynamically create Excel multi-worksheet workbooks and chart the data.

dynachart

Comparing the use of Analytic Functions to GROUP BY

analytics-vs-groupby

A form of 'assert' for command line arguments in bash

validate-args

scripts for viewing relevant contents of log files

log-file-filter

Oracle SQL*Net scripts, files, tests, etc

sqlnet

shell-lock

Locking in Shell (Bash)

work with Oracle Bind variables for performance analysis

ora-binds

Simple indexer to create an index of objects found in source files.

src-obj-idx

pseudo-sequence

Source material for a blog on using xargs with the find command

use-xargs

Where I begin to learn golang by building a photo catalog datdabase

golang-oerrs

Oracle Errors for golang

vimrc

Vim Script

exifdb

shell-functions

Scan Resumes for keywords and score - pretty straight forward

resume-scanner

Oracle Log Writer Tracefile Parsing

lgwr-trace-parse

use trcsess and and trace-combined-sequential.pl to get chronological output from multiple trace files

trace-combine

Demonstrations of various Oracle bits - some may be incomplete.

oracle-demos

Lot of various perl files

perl

Scripts used to check for Linux RPM updates that may conflict with installed Oracle Software

patch-check