support/oracle
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
main
oracle/mhouri
History
root 93039b8489 2026-03-12 20:23:15
2026-03-12 21:23:47 +01:00
..
ashgetBreak.sql
2026-03-12 20:23:15
2026-03-12 21:23:47 +01:00
ashPerAction.sql
2026-03-12 20:23:15
2026-03-12 21:23:47 +01:00
ashPlanLineId2.sql
2026-03-12 20:23:15
2026-03-12 21:23:47 +01:00
ashPlanLineId.sql
2026-03-12 20:23:15
2026-03-12 21:23:47 +01:00
ashtop20.sql
2026-03-12 20:23:15
2026-03-12 21:23:47 +01:00
AwrBulkCollect.sql
2026-03-12 20:23:15
2026-03-12 21:23:47 +01:00
awrPlanLineId.sql
2026-03-12 20:23:15
2026-03-12 21:23:47 +01:00
checkUndoAsh.sql
2026-03-12 20:23:15
2026-03-12 21:23:47 +01:00
CurrentSize.sql
2026-03-12 20:23:15
2026-03-12 21:23:47 +01:00
CurSelCubeHybridNonPop.sql
2026-03-12 20:23:15
2026-03-12 21:23:47 +01:00
CurSelCubeHybridNonPopWithoutEndPoint.sql
2026-03-12 20:23:15
2026-03-12 21:23:47 +01:00
CurSelCubeHybridPop.sql
2026-03-12 20:23:15
2026-03-12 21:23:47 +01:00
disProf.sql
2026-03-12 20:23:15
2026-03-12 21:23:47 +01:00
disSPM.sql
2026-03-12 20:23:15
2026-03-12 21:23:47 +01:00
dropSPM.sql
2026-03-12 20:23:15
2026-03-12 21:23:47 +01:00
enableCons.sql
2026-03-12 20:23:15
2026-03-12 21:23:47 +01:00
FindVW_all.sql
2026-03-12 20:23:15
2026-03-12 21:23:47 +01:00
FixProfileFromXmlFromCache.sql
2026-03-12 20:23:15
2026-03-12 21:23:47 +01:00
getAdvisors.sql
2026-03-12 20:23:15
2026-03-12 21:23:47 +01:00
getAdvisorTasks.sql
2026-03-12 20:23:15
2026-03-12 21:23:47 +01:00
getarchiv.sql
2026-03-12 20:23:15
2026-03-12 21:23:47 +01:00
getFRA.sql
2026-03-12 20:23:15
2026-03-12 21:23:47 +01:00
getLOBname.sql
2026-03-12 20:23:15
2026-03-12 21:23:47 +01:00
getPartCol.sql
2026-03-12 20:23:15
2026-03-12 21:23:47 +01:00
getPartTab1.sql
2026-03-12 20:23:15
2026-03-12 21:23:47 +01:00
getPartTab2.sql
2026-03-12 20:23:15
2026-03-12 21:23:47 +01:00
getPartTab.sql
2026-03-12 20:23:15
2026-03-12 21:23:47 +01:00
getPrefs.sql
2026-03-12 20:23:15
2026-03-12 21:23:47 +01:00
getredo.sql
2026-03-12 20:23:15
2026-03-12 21:23:47 +01:00
getScalarSubInSQL.sql
2026-03-12 20:23:15
2026-03-12 21:23:47 +01:00
getUndoHist.sql
2026-03-12 20:23:15
2026-03-12 21:23:47 +01:00
gv$getBreak.sql
2026-03-12 20:23:15
2026-03-12 21:23:47 +01:00
gvsql.sql
2026-03-12 20:23:15
2026-03-12 21:23:47 +01:00
h_hist1.sql
2026-03-12 20:23:15
2026-03-12 21:23:47 +01:00
isInParse.sql
2026-03-12 20:23:15
2026-03-12 21:23:47 +01:00
isInSQLCurrentPerObj.sql
2026-03-12 20:23:15
2026-03-12 21:23:47 +01:00
isSQLCurrent.sql
2026-03-12 20:23:15
2026-03-12 21:23:47 +01:00
isSQLusingSPM.sql
2026-03-12 20:23:15
2026-03-12 21:23:47 +01:00
isSysmodifiable.sql
2026-03-12 20:23:15
2026-03-12 21:23:47 +01:00
loadSPMfromAWR.sql
2026-03-12 20:23:15
2026-03-12 21:23:47 +01:00
loadSPMfromCache.sql
2026-03-12 20:23:15
2026-03-12 21:23:47 +01:00
nonsharedMho.sql
2026-03-12 20:23:15
2026-03-12 21:23:47 +01:00
PartitionedIndexEfficiency.sql
2026-03-12 20:23:15
2026-03-12 21:23:47 +01:00
phv2.sql
2026-03-12 20:23:15
2026-03-12 21:23:47 +01:00
PXElaps.sql
2026-03-12 20:23:15
2026-03-12 21:23:47 +01:00
QCElaps.sql
2026-03-12 20:23:15
2026-03-12 21:23:47 +01:00
QcPxElaps.sql
2026-03-12 20:23:15
2026-03-12 21:23:47 +01:00
README.md
2026-03-12 20:23:15
2026-03-12 21:23:47 +01:00
SizeCurrent2.sql
2026-03-12 20:23:15
2026-03-12 21:23:47 +01:00
SpmTranfer.sql
2026-03-12 20:23:15
2026-03-12 21:23:47 +01:00
sqlHist.sql
2026-03-12 20:23:15
2026-03-12 21:23:47 +01:00
sqlmonHist.sql
2026-03-12 20:23:15
2026-03-12 21:23:47 +01:00
sqlstats.sql
2026-03-12 20:23:15
2026-03-12 21:23:47 +01:00
UndoHist.sql
2026-03-12 20:23:15
2026-03-12 21:23:47 +01:00
xpgv$.sql
2026-03-12 20:23:15
2026-03-12 21:23:47 +01:00
xpsimp.sql
2026-03-12 20:23:15
2026-03-12 21:23:47 +01:00

README.md

I share some SQL scripts that I use regularly in my work as a consultant specialized around the Oracle database

Reference in New Issue View Git Blame Copy Permalink