by gwenshap

Scripts that make my job as a DBA a bit easier

213 Stars 150 Forks Last release: Not found 11 Commits 0 Releases

Available items

No Items, yet!

The developer of this repository has not created any items for sale yet. Need a bug fixed? Help with integration? A different license? Create a request here:


= 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


DataGuard.txt - SQL snippets for monitoring and managing DataGuard checkandkill.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 jobscheduling.sql - Queries regarding jobs and schedules SSD.sql - queries I use to decide which segments should be placed on SSDs undospace.sql - queries to dig into undo usage tablespace.sql - queries to manage tablespace sizes

We use cookies. If you continue to browse the site, you agree to the use of cookies. For more information on our use of cookies please see our Privacy Policy.