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

gwenshap
215 Stars 155 Forks 11 Commits 0 Opened issues

Description

Scripts that make my job as a DBA a bit easier

Services available

!
?

Need anything else?

Contributors list

No Data

=========

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