OracleMaintenanceScripts

Small handy scripts to manage your Oracle database. Most of them work on multiple versions.

Name		Name	Last commit message	Last commit date
Latest commit History 62 Commits
LogManagement		LogManagement
MagicValues		MagicValues
OEM		OEM
Patching		Patching
Proxy		Proxy
RMAN		RMAN
Redo		Redo
Standby		Standby
TablespaceForecast		TablespaceForecast
Temp		Temp
Undo		Undo
All_errors.sql		All_errors.sql
CheckForInvalidIndexesAndPartitions.sql		CheckForInvalidIndexesAndPartitions.sql
CorruptedBlocks.sql		CorruptedBlocks.sql
Create_RestorePoint.sql		Create_RestorePoint.sql
DiagnoseWaitTimes.sql		DiagnoseWaitTimes.sql
DropADatabase.sql		DropADatabase.sql
Empty_All_Schemas.sql		Empty_All_Schemas.sql
FindBlockingSessions.sql		FindBlockingSessions.sql
FindOracleFeatureUsage.sql		FindOracleFeatureUsage.sql
FindRunningOracle.txt		FindRunningOracle.txt
Find_CDB_PDB.sql		Find_CDB_PDB.sql
GatherIndexStats.sql		GatherIndexStats.sql
GetJavaVersion.sql		GetJavaVersion.sql
GetLastStartupTime.sql		GetLastStartupTime.sql
ORA-01194: file 1 needs more recovery to be consistent.sql		ORA-01194: file 1 needs more recovery to be consistent.sql
OfflineDatafiles.sql		OfflineDatafiles.sql
OracleDiagnosticChecks.sql		OracleDiagnosticChecks.sql
README.md		README.md
SimulateORAerrors.sql		SimulateORAerrors.sql
SqlThatIsBeingHardParsed.sql		SqlThatIsBeingHardParsed.sql
SqlThatIsBeingHardParsedPercentages.sql		SqlThatIsBeingHardParsedPercentages.sql

Provide feedback