Need help with Oracle-DBA-Scripts?
Click the “chat” button below for chat support from the developer who created it, or find similar developers for support.

About the developer

236 Stars 161 Forks 11 Commits 0 Opened issues


Scripts that make my job as a DBA a bit easier

Services available


Need anything else?

Contributors list

# 23,326
11 commits


= 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.