oracle

check_and_kill.sql - SQL for checking on what sessions are doing

DataGuard.txt - SQL snippets for monitoring and managing DataGuard

job_scheduling.sql - Queries regarding jobs and schedules

locks.sql - Queries I use to figure out locking issues

SSD.sql - queries I use to decide which segments should be placed on SSDs

tablespace.sql - queries to manage tablespace sizes

tfsclock.sql - complex query from Oracle that gives a lot of details about locks

undo_space.sql - queries to dig into undo usage

Name		Name	Last commit message	Last commit date
Latest commit History 6 Commits
prcs		prcs
utils		utils
ASH2.sql		ASH2.sql
DataGuard.txt		DataGuard.txt
PGA_watch.sql		PGA_watch.sql
README.md		README.md
SSD.sql		SSD.sql
advisor_profile_recs.sql		advisor_profile_recs.sql
check_and_kill.sql		check_and_kill.sql
col_high_low_val.sql		col_high_low_val.sql
double_tablespace.sql		double_tablespace.sql
explain_plan.sql		explain_plan.sql
external_table_load_example.sql		external_table_load_example.sql
find_sql.sql		find_sql.sql
fsx.sql		fsx.sql
index_efficiency.sql		index_efficiency.sql
job_scheduling.sql		job_scheduling.sql
locks.sql		locks.sql
login.sql		login.sql
my_sqlmon.sql		my_sqlmon.sql
sql_monitor_offload.sql		sql_monitor_offload.sql
tablespace.sql		tablespace.sql
tfsclock.sql		tfsclock.sql
top-sql.sql		top-sql.sql
top_excel.sql		top_excel.sql
top_queries.sql		top_queries.sql
undo_space.sql		undo_space.sql

Provide feedback