Scripts that make my job as a DBA a bit easier
Switch branches/tags
Nothing to show
Clone or download
Permalink
Failed to load latest commit information.
ASH2.sql Adding some scripts Nov 22, 2011
DataGuard.txt Adding some scripts Nov 22, 2011
PGA_watch.sql scripts used to optimize and troubleshoot data load Nov 2, 2012
README Adding some scripts Nov 22, 2011
SSD.sql Adding some scripts Nov 22, 2011
advisor_profile_recs.sql Adding queries from Marc's tuning advisor blog post Dec 22, 2012
check_and_kill.sql Adding some scripts Nov 22, 2011
col_high_low_val.sql Stats translation script from Martin Widlake and Gary Myers Dec 19, 2012
double_tablespace.sql Adding some scripts Nov 22, 2011
explain_plan.sql Adding some scripts Nov 22, 2011
external_table_load_example.sql scripts used to optimize and troubleshoot data load Nov 2, 2012
find_sql.sql scripts used to optimize and troubleshoot data load Nov 2, 2012
fsx.sql Kerry Osborne's offloading script Feb 2, 2013
index_efficiency.sql Added Jonathan Lewis's index efficience test. May 17, 2012
job_scheduling.sql Adding some scripts Nov 22, 2011
locks.sql Adding some scripts Nov 22, 2011
login.sql scripts used to optimize and troubleshoot data load Nov 2, 2012
my_sqlmon.sql scripts used to optimize and troubleshoot data load Nov 2, 2012
sql_monitor_offload.sql query from tanel to check exec plan for offloading Feb 2, 2013
tablespace.sql removed an an unnecessary condition that annoyed me Nov 9, 2012
tfsclock.sql Adding some scripts Nov 22, 2011
top-sql.sql Added CPU as an event to allow finding top CPU queries too Dec 21, 2012
top_excel.sql adding new awr analysis tools Apr 18, 2012
top_queries.sql adding new awr analysis tools Apr 18, 2012
undo_space.sql Adding some scripts Nov 22, 2011

README

=========
= About =
=========

This is a collection of useful Oracle SQL and shell scripts that I use.

I don't mind how you use these scripts, but give credit if credit is due.

===========
= License =
===========

Copyright 2011 Gwen Shapira.

These programs are free software: you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation, either version 3 of the License, or
(at your option) any later version.

These programs are distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
GNU General Public License for more details.

You should have received a copy of the GNU General Public License
along with this program.  If not, see <http://www.gnu.org/licenses/>.

==========================================================================

DataGuard.txt - SQL snippets for monitoring and managing DataGuard
check_and_kill.sql - SQL for checking on what sessions are doing
locks.sql - Queries I use to figure out locking issues
tfsclock.sql - complex query from Oracle that gives a lot of details about locks
job_scheduling.sql - Queries regarding jobs and schedules
SSD.sql - queries I use to decide which segments should be placed on SSDs
undo_space.sql - queries to dig into undo usage
tablespace.sql - queries to manage tablespace sizes