GitHub - LucaCanali/Oracle_DBA_scripts: A collection of old-school CLI scripts for Oracle RDBMS monitoring and performance troubleshooting.

Branches Tags

Name		Name	Last commit message	Last commit date
Latest commit History 5 Commits
OraLatencyMap		OraLatencyMap
reports		reports
FindSidfrom_ospid.sql		FindSidfrom_ospid.sql
LICENSE		LICENSE
README.txt		README.txt
SessInfo.sql		SessInfo.sql
adg.sql		adg.sql
ash.sql		ash.sql
ash2.sql		ash2.sql
ash3.sql		ash3.sql
ash4.sql		ash4.sql
ash_h.sql		ash_h.sql
ash_report.sql		ash_report.sql
ash_sess.sql		ash_sess.sql
ash_top.sql		ash_top.sql
awr_global_report.sql		awr_global_report.sql
awr_report.sql		awr_report.sql
awr_snapshots.sql		awr_snapshots.sql
awr_sql_report.sql		awr_sql_report.sql
binds.sql		binds.sql
cancel.sql		cancel.sql
ddl.sql		ddl.sql
ehm.sql		ehm.sql
ehm_local.sql		ehm_local.sql
ehm_micro.sql		ehm_micro.sql
ehm_micro_local.sql		ehm_micro_local.sql
eventmetric.sql		eventmetric.sql
explain.sql		explain.sql
explain_awr.sql		explain_awr.sql
filemetric.sql		filemetric.sql
flash.sql		flash.sql
grants.sql		grants.sql
iometric.sql		iometric.sql
iometric_details.sql		iometric_details.sql
jobs_running.sql		jobs_running.sql
kill.sql		kill.sql
kill_select.sql		kill_select.sql
load.sql		load.sql
locks.sql		locks.sql
locks_10g.sql		locks_10g.sql
locks_details.sql		locks_details.sql
login.sql		login.sql
longops.sql		longops.sql
longops_10g.sql		longops_10g.sql
longops_details.sql		longops_details.sql
monitor.sql		monitor.sql
monitor_details.sql		monitor_details.sql
monitor_plan.sql		monitor_plan.sql
monitor_report_sid.sql		monitor_report_sid.sql
monitor_report_sid_active.sql		monitor_report_sid_active.sql
monitor_report_sql_id.sql		monitor_report_sql_id.sql
monitor_report_sql_id_active.sql		monitor_report_sql_id_active.sql
obj.sql		obj.sql
sessmetric.sql		sessmetric.sql
sql.sql		sql.sql
sysmetric.sql		sysmetric.sql
sysmetric_details.sql		sysmetric_details.sql
top.sql		top.sql
top_10g.sql		top_10g.sql
transactions.sql		transactions.sql
u.sql		u.sql

Repository files navigation

Command-line DBA Scripts for Oracle, mostly aimed at troubleshooting performance 

Author: Luca.Canali@cern.ch
Current version: June 2015
Description of the scripts at: http://externaltable.blogspot.com/2012/09/on-command-line-dba.html