Tanel Poder's Troubleshooting & Performance Tools for Oracle databases
Switch branches/tags
Nothing to show
Clone or download
Latest commit 6a628ef Nov 9, 2018
Permalink
Failed to load latest commit information.
aot initial commit May 15, 2018
ash formatting Sep 19, 2018
ast move scalar subquery demos to ast/ May 15, 2018
awr v0.1 Oct 29, 2018
comments initial commit May 15, 2018
demos initial commit May 15, 2018
dtrace initial commit May 15, 2018
exadata initial commit May 15, 2018
experiments initial commit May 15, 2018
im initial commit May 15, 2018
logs propagate logs and tmp directories to git repo too May 15, 2018
ppx rename Oct 29, 2018
setup 1st ver Oct 29, 2018
statspack initial commit May 15, 2018
tmp propagate logs and tmp directories to git repo too May 15, 2018
tools sqlflame intermediate format example Nov 2, 2018
.gitignore propagate logs and tmp directories to git repo too May 15, 2018
46off.sql initial commit May 15, 2018
46on.sql initial commit May 15, 2018
53off.sql initial commit May 15, 2018
53on.sql initial commit May 15, 2018
LICENSE.txt add copyright notice May 17, 2018
README.md initial commit May 15, 2018
a.sql initial commit May 15, 2018
acc.sql initial commit May 15, 2018
aon.sql initial commit May 15, 2018
appinfo.sql initial commit May 15, 2018
aq.sql initial commit May 15, 2018
ar.sql initial commit May 15, 2018
arg.sql initial commit May 15, 2018
as.sql initial commit May 15, 2018
ascii.sql initial commit May 15, 2018
asfp.sql initial commit May 15, 2018
ash.sql initial commit May 15, 2018
ashtop.sql initial commit May 15, 2018
asmdf.sql initial commit May 15, 2018
asmdg.sql initial commit May 15, 2018
asmdump.sql initial commit May 15, 2018
asmdumpf.sql initial commit May 15, 2018
asmls.sql initial commit May 15, 2018
asql.sql initial commit May 15, 2018
atname.sql initial commit May 15, 2018
aud.sql initial commit May 15, 2018
audo.sql initial commit May 15, 2018
audo2.sql initial commit May 15, 2018
aw.sql initial commit May 15, 2018
ba.sql initial commit May 15, 2018
bclass.sql initial commit May 15, 2018
bf.sql initial commit May 15, 2018
bg.sql initial commit May 15, 2018
bg2.sql initial commit May 15, 2018
bgact.sql initial commit May 15, 2018
bh_by_ts.sql initial commit May 15, 2018
bhdo.sql initial commit May 15, 2018
bhla.sql initial commit May 15, 2018
bhobjects.sql initial commit May 15, 2018
bhobjects2.sql initial commit May 15, 2018
bitmask.sql initial commit May 15, 2018
bufp.sql initial commit May 15, 2018
bufprof.sql initial commit May 15, 2018
bufprof_wrong.sql initial commit May 15, 2018
c.sql initial commit May 15, 2018
calc.sql initial commit May 15, 2018
cancel.sql use oracle 12.2+ approach to cancel Sep 19, 2018
cbo_helper.sql initial commit May 15, 2018
cborun.sql initial commit May 15, 2018
cbothis.sql initial commit May 15, 2018
cc.sql initial commit May 15, 2018
channels.sql initial commit May 15, 2018
channels2.sql initial commit May 15, 2018
channels3.sql initial commit May 15, 2018
chr.sql initial commit May 15, 2018
cid.sql initial commit May 15, 2018
cinfo.sql initial commit May 15, 2018
clt.sql initial commit May 15, 2018
cnt.sql initial commit May 15, 2018
cnta.sql initial commit May 15, 2018
cntg.sql initial commit May 15, 2018
cofef.sql updates Nov 1, 2018
cofef_missing.sql 1st Nov 9, 2018
cofep.sql updates Nov 1, 2018
col.sql initial commit May 15, 2018
colltypes.sql initial commit May 15, 2018
colusage.sql initial commit May 15, 2018
comm.sql initial commit May 15, 2018
compileall.sql initial commit May 15, 2018
cons.sql initial commit May 15, 2018
cons2.sql initial commit May 15, 2018
cont.sql initial commit May 15, 2018
create_sql_baseline.sql updates and doc in header Nov 1, 2018
create_sql_patch.sql updates and doc in header Nov 1, 2018
cs.sql initial commit May 15, 2018
csv.sql initial commit May 15, 2018
curheaps.sql initial commit May 15, 2018
curlog.sql initial commit May 15, 2018
curschema.sql initial commit May 15, 2018
d.sql initial commit May 15, 2018
d2.sql initial commit May 15, 2018
date.sql initial commit May 15, 2018
date2unix.sql initial commit May 15, 2018
db.sql initial commit May 15, 2018
dba.sql initial commit May 15, 2018
dba2.sql initial commit May 15, 2018
dbinfo.sql initial commit May 15, 2018
dblinks.sql initial commit May 15, 2018
dc.sql initial commit May 15, 2018
ddl.sql initial commit May 15, 2018
dec.sql initial commit May 15, 2018
dep.sql initial commit May 15, 2018
desc.sql initial commit May 15, 2018
descx.sql initial commit May 15, 2018
descx2.sql initial commit May 15, 2018
descxx.sql initial commit May 15, 2018
descxx2.sql initial commit May 15, 2018
df.sql fix formatting when tablespace is empty Sep 11, 2018
dfm.sql fix formatting when tablespace is empty Sep 11, 2018
dg.sql initial commit May 15, 2018
diag.sql initial commit May 15, 2018
diag_sid.sql initial commit May 15, 2018
dir.sql initial commit May 15, 2018
dirs.sql initial commit May 15, 2018
disable_restricting_fks.sql initial commit May 15, 2018
disco.sql initial commit May 15, 2018
dist.sql initial commit May 15, 2018
distribution.sql initial commit May 15, 2018
dnfs.sql initial commit May 15, 2018
doid.sql initial commit May 15, 2018
drop_sql_baseline.sql updates and doc in header Nov 1, 2018
drop_sql_patch.sql 1st commit Nov 1, 2018
dsv.sql initial commit May 15, 2018
du.sql initial commit May 15, 2018
du2.sql initial commit May 15, 2018
dump.sql initial commit May 15, 2018
dumptrc.sql initial commit May 15, 2018
dumpvar.sql initial commit May 15, 2018
dv.sql initial commit May 15, 2018
e2d.sql initial commit May 15, 2018
ed.sql initial commit May 15, 2018
el.sql initial commit May 15, 2018
eoff.sql initial commit May 15, 2018
eon.sql initial commit May 15, 2018
ep.sql initial commit May 15, 2018
eqs.sql initial commit May 15, 2018
equiv.sql initial commit May 15, 2018
equivx.sql initial commit May 15, 2018
es.sql initial commit May 15, 2018
esn.sql initial commit May 15, 2018
esnx.sql initial commit May 15, 2018
et.sql initial commit May 15, 2018
ev.sql initial commit May 15, 2018
evh.sql initial commit May 15, 2018
evi.sql initial commit May 15, 2018
evo.sql initial commit May 15, 2018
evts.sql add event dump script Jun 20, 2018
extloc.sql initial commit May 15, 2018
exttab.sql initial commit May 15, 2018
f.sql initial commit May 15, 2018
fcha.sql initial commit May 15, 2018
fcura.sql initial commit May 15, 2018
fd.sql initial commit May 15, 2018
fgran.sql initial commit May 15, 2018
find.sql initial commit May 15, 2018
fish.sql initial commit May 15, 2018
fix.sql initial commit May 15, 2018
ft.sql initial commit May 15, 2018
fusage.sql initial commit May 15, 2018
fv.sql initial commit May 15, 2018
fv2.sql initial commit May 15, 2018
fva.sql initial commit May 15, 2018
fval.sql initial commit May 15, 2018
fval2.sql initial commit May 15, 2018
getplusparm.sql initial commit May 15, 2018
getprev.sql initial commit May 15, 2018
gettracename.sql initial commit May 15, 2018
grep.sql initial commit May 15, 2018
grp.sql initial commit May 15, 2018
grpa.sql initial commit May 15, 2018
grpn.sql initial commit May 15, 2018
grpo.sql initial commit May 15, 2018
grps.sql initial commit May 15, 2018
gsqlmon.sql initial commit May 15, 2018
gss.sql initial commit May 15, 2018
gtrans.sql initial commit May 15, 2018
gts.sql initial commit May 15, 2018
gtsh.sql initial commit May 15, 2018
h.sql initial commit May 15, 2018
h2s.sql initial commit May 15, 2018
ha.sql initial commit May 15, 2018
hash.sql initial commit May 15, 2018
heap6.sql initial commit May 15, 2018
heapdump_analyzer initial commit May 15, 2018
help.sql initial commit May 15, 2018
hex.sql initial commit May 15, 2018
hexop.sql initial commit May 15, 2018
hg.sql initial commit May 15, 2018
hint.sql initial commit May 15, 2018
hintclass.sql initial commit May 15, 2018
hintfeature.sql initial commit May 15, 2018
hinth.sql initial commit May 15, 2018
hist2.sql initial commit May 15, 2018
hist_generic.sql initial commit May 15, 2018
hof.sql initial commit May 15, 2018
hoff.sql initial commit May 15, 2018
hon.sql initial commit May 15, 2018
hp.sql initial commit May 15, 2018
hr.sql initial commit May 15, 2018
hs.sql initial commit May 15, 2018
hsel.sql initial commit May 15, 2018
html.sql initial commit May 15, 2018
html2.sql initial commit May 15, 2018
html3.sql initial commit May 15, 2018
html_.sql initial commit May 15, 2018
html_settings.sql initial commit May 15, 2018
htmloff.sql initial commit May 15, 2018
htmlon.sql initial commit May 15, 2018
htmlon_.sql initial commit May 15, 2018
htmlrun.sql initial commit May 15, 2018
htmlset.sql initial commit May 15, 2018
htmlset2.sql initial commit May 15, 2018
i.sql initial commit May 15, 2018
i2h.sql initial commit May 15, 2018
id.sql initial commit May 15, 2018
ii.sql initial commit May 15, 2018
ima.sql initial commit May 15, 2018
imseg.sql initial commit May 15, 2018
imtab.sql initial commit May 15, 2018
imu.sql initial commit May 15, 2018
ind.sql initial commit May 15, 2018
ind2.sql initial commit May 15, 2018
init.sql initial commit May 15, 2018
intopt.sql initial commit May 15, 2018
inv.sql initial commit May 15, 2018
jf.sql initial commit May 15, 2018
jobdisable.sql initial commit May 15, 2018
jobs.sql initial commit May 15, 2018
jobsr.sql initial commit May 15, 2018
kcbbes.sql initial commit May 15, 2018
kcboqh.sql initial commit May 15, 2018
kcbsw.sql initial commit May 15, 2018
kcbsw_10.sql initial commit May 15, 2018
kcbsw_11.sql initial commit May 15, 2018
kcbsw_9.sql initial commit May 15, 2018
kcbwds.sql initial commit May 15, 2018
kcbwh.sql initial commit May 15, 2018
kghlu.sql initial commit May 15, 2018
kglbroken.sql initial commit May 15, 2018
kgllk.sql initial commit May 15, 2018
kglob.sql initial commit May 15, 2018
kglpn.sql initial commit May 15, 2018
kill.sql initial commit May 15, 2018
kill_cpu.sql initial commit May 15, 2018
killi.sql initial commit May 15, 2018
ksllw.sql initial commit May 15, 2018
ksmdd.sql initial commit May 15, 2018
ksminfo.sql initial commit May 15, 2018
ksmlru.sql initial commit May 15, 2018
ksmsp.sql initial commit May 15, 2018
ksmsp2.sql initial commit May 15, 2018
ksqeq.sql initial commit May 15, 2018
ksqrs.sql initial commit May 15, 2018
kstex.sql initial commit May 15, 2018
ksupr.sql initial commit May 15, 2018
ksuse.sql initial commit May 15, 2018
ktuxe.sql initial commit May 15, 2018
l.sql initial commit May 15, 2018
la.sql initial commit May 15, 2018
last.sql initial commit May 15, 2018
lastchanged.sql initial commit May 15, 2018
lastmon.sql initial commit May 15, 2018
lastmont.sql initial commit May 15, 2018
latchprof.sql initial commit May 15, 2018
latchprof_old.sql initial commit May 15, 2018
latchprofx.sql initial commit May 15, 2018
lc.sql initial commit May 15, 2018
lco.sql initial commit May 15, 2018
ld.sql initial commit May 15, 2018
len.sql initial commit May 15, 2018
length.sql initial commit May 15, 2018
lh.sql initial commit May 15, 2018
lhp.sql initial commit May 15, 2018
lhpx.sql initial commit May 15, 2018
li.sql initial commit May 15, 2018
li2.sql initial commit May 15, 2018
lib.sql initial commit May 15, 2018
lib2.sql initial commit May 15, 2018
list.sql initial commit May 15, 2018
lm.sql initial commit May 15, 2018
ln.sql initial commit May 15, 2018
loadset.sql initial commit May 15, 2018
lob.sql initial commit May 15, 2018
lock.sql initial commit May 15, 2018
log.sql initial commit May 15, 2018
logfile.sql initial commit May 15, 2018
login.sql initial commit May 15, 2018
long.sql initial commit May 15, 2018
lotshparses.sql initial commit May 15, 2018
lotshparses2.sql initial commit May 15, 2018
lotshparses3.sql initial commit May 15, 2018
lotslios.sql initial commit May 15, 2018
lotsparses.sql initial commit May 15, 2018
lotspios.sql initial commit May 15, 2018
lotssparses.sql initial commit May 15, 2018
lotssparses2.sql initial commit May 15, 2018
lpx.sql initial commit May 15, 2018
lpxa.sql initial commit May 15, 2018
lr.sql initial commit May 15, 2018
lrc.sql initial commit May 15, 2018
ls.sql initial commit May 15, 2018
lt.sql initial commit May 15, 2018
ltx.sql initial commit May 15, 2018
m.sql initial commit May 15, 2018
measure_io.sql initial commit May 15, 2018
mem.sql initial commit May 15, 2018
memres.sql initial commit May 15, 2018
metric.sql initial commit May 15, 2018
minelog.sql initial commit May 15, 2018
minmax.sql initial commit May 15, 2018
mloc.sql initial commit May 15, 2018
mods.sql initial commit May 15, 2018
modsx.sql initial commit May 15, 2018
mp.sql initial commit May 15, 2018
ms.sql initial commit May 15, 2018
msh.sql initial commit May 15, 2018
mutexprof.sql initial commit May 15, 2018
mycur.sql initial commit May 15, 2018
mys.sql initial commit May 15, 2018
mysid.sql initial commit May 15, 2018
mysx.sql initial commit May 15, 2018
newxpa.sql initial commit May 15, 2018
nf.sql initial commit May 15, 2018
nls.sql initial commit May 15, 2018
nonshared.sql initial commit May 15, 2018
nonshared2.sql initial commit May 15, 2018
nonsharedsum.sql initial commit May 15, 2018
nonsharedsum2.sql initial commit May 15, 2018
nonsharedsum3.sql initial commit May 15, 2018
nonsharedsum_html.sql initial commit May 15, 2018
nonsharedsum_html_111.sql initial commit May 15, 2018
o.sql initial commit May 15, 2018
o2.sql initial commit May 15, 2018
oc.sql initial commit May 15, 2018
od.sql initial commit May 15, 2018
odc.sql initial commit May 15, 2018
oddc.sql add PROMPT command to show what this script does May 18, 2018
odh.sql initial commit May 15, 2018
odl.sql initial commit May 15, 2018
ods.sql initial commit May 15, 2018
odsid.sql initial commit May 15, 2018
odt.sql initial commit May 15, 2018
oerr.sql initial commit May 15, 2018
ofe.sql initial commit May 15, 2018
oi.sql initial commit May 15, 2018
oid.sql initial commit May 15, 2018
ol.sql initial commit May 15, 2018
oprivs.sql initial commit May 15, 2018
oprivs2.sql initial commit May 15, 2018
ora_hash.sql initial commit May 15, 2018
osp.sql initial commit May 15, 2018
ostack.sql initial commit May 15, 2018
ostackprof.sql initial commit May 15, 2018
otherxml.sql initial commit May 15, 2018
ou.sql initial commit May 15, 2018
p.sql initial commit May 15, 2018
paddr.sql initial commit May 15, 2018
partkeys.sql initial commit May 15, 2018
partmon.sql initial commit May 15, 2018
partpruning.sql initial commit May 15, 2018
pd.sql initial commit May 15, 2018
pd2.sql initial commit May 15, 2018
pdbs.sql initial commit May 15, 2018
pdv.sql initial commit May 15, 2018
peek.sql initial commit May 15, 2018
pgav.sql initial commit May 15, 2018
pmem.sql initial commit May 15, 2018
pmem_detail.sql initial commit May 15, 2018
pn.sql initial commit May 15, 2018
pr.sql initial commit May 15, 2018
prc.sql initial commit May 15, 2018
prefetch.sql initial commit May 15, 2018
printtab2.sql initial commit May 15, 2018
privgrants.sql initial commit May 15, 2018
privgrants2.sql initial commit May 15, 2018
privs.sql initial commit May 15, 2018
privs2.sql initial commit May 15, 2018
proc.sql initial commit May 15, 2018
procid.sql initial commit May 15, 2018
prq.sql initial commit May 15, 2018
prr.sql initial commit May 15, 2018
prs.sql initial commit May 15, 2018
pv.sql initial commit May 15, 2018
pvalid.sql initial commit May 15, 2018
px.sql initial commit May 15, 2018
px2.sql initial commit May 15, 2018
pxs.sql initial commit May 15, 2018
rac112.sql initial commit May 15, 2018
reg.sql initial commit May 15, 2018
repg.sql initial commit May 15, 2018
repo.sql initial commit May 15, 2018
repo2.sql initial commit May 15, 2018
res.sql initial commit May 15, 2018
res2.sql initial commit May 15, 2018
rman_archlogs.sql initial commit May 15, 2018
roles.sql initial commit May 15, 2018
rowcache.sql initial commit May 15, 2018
rowcr.sql initial commit May 15, 2018
rowid.sql initial commit May 15, 2018
rowid_scan.sql initial commit May 15, 2018
rs.sql initial commit May 15, 2018
s.sql increase p3 width for library cache pin Jul 8, 2018
saddr.sql initial commit May 15, 2018
sample.sql initial commit May 15, 2018
sampleaddr.sql initial commit May 15, 2018
saveset.sql initial commit May 15, 2018
sdr.sql initial commit May 15, 2018
se.sql initial commit May 15, 2018
sed.sql initial commit May 15, 2018
sed2.sql initial commit May 15, 2018
sedn.sql initial commit May 15, 2018
sedx.sql initial commit May 15, 2018
seg.sql initial commit May 15, 2018
seg2.sql initial commit May 15, 2018
segcached.sql initial commit May 15, 2018
segeof.sql initial commit May 15, 2018
segext.sql initial commit May 15, 2018
segext2.sql initial commit May 15, 2018
segstat.sql initial commit May 15, 2018
segstat2.sql initial commit May 15, 2018
segstatint.sql initial commit May 15, 2018
segsum.sql initial commit May 15, 2018
sel.sql initial commit May 15, 2018
select.sql initial commit May 15, 2018
seq.sql initial commit May 15, 2018
seq2.sql initial commit May 15, 2018
ses.sql initial commit May 15, 2018
ses2.sql initial commit May 15, 2018
sesopt.sql initial commit May 15, 2018
sest.sql initial commit May 15, 2018
set.sql initial commit May 15, 2018
sga.sql initial commit May 15, 2018
sgai.sql initial commit May 15, 2018
sgares.sql initial commit May 15, 2018
sgastat.sql initial commit May 15, 2018
sgastatx.sql initial commit May 15, 2018
sgav.sql initial commit May 15, 2018
sh.sql initial commit May 15, 2018
sid.sql initial commit May 15, 2018
sinfo.sql initial commit May 15, 2018
sl.sql initial commit May 15, 2018
sleep.sql initial commit May 15, 2018
sm.sql initial commit May 15, 2018
smem.sql initial commit May 15, 2018
smem_detail.sql initial commit May 15, 2018
sn.sql initial commit May 15, 2018
snapcpu.sql initial commit May 15, 2018
snapio.sql initial commit May 15, 2018
snaplio.sql initial commit May 15, 2018
snapper.sql remove one no_unnest hint that slowed sesstat query down Oct 27, 2018
snapper3.sql initial commit May 15, 2018
snapper_v1.sql initial commit May 15, 2018
snapper_v2.sql initial commit May 15, 2018
snapperloop.sql initial commit May 15, 2018
snapperloop.zip initial commit May 15, 2018
snappio.sql initial commit May 15, 2018
snappiomb.sql initial commit May 15, 2018
snapredo.sql initial commit May 15, 2018
snaptime.sql initial commit May 15, 2018
snapwait.sql initial commit May 15, 2018
snb.sql initial commit May 15, 2018
sne.sql initial commit May 15, 2018
snr.sql initial commit May 15, 2018
soff.sql initial commit May 15, 2018
sol102.sql initial commit May 15, 2018
sol112.sql initial commit May 15, 2018
someload.sql initial commit May 15, 2018
source.sql initial commit May 15, 2018
source2.sql initial commit May 15, 2018
sout.sql initial commit May 15, 2018
sowalk.sql initial commit May 15, 2018
sp.sql initial commit May 15, 2018
splast.sql initial commit May 15, 2018
spmem.sql initial commit May 15, 2018
spoolrun.sql initial commit May 15, 2018
sprivs.sql initial commit May 15, 2018
sprivs2.sql initial commit May 15, 2018
sql.sql initial commit May 15, 2018
sql_id.sql initial commit May 15, 2018
sqla.sql initial commit May 15, 2018
sqlbinds.sql initial commit May 15, 2018
sqlcsstat.sql initial commit May 15, 2018
sqlexecid.sql initial commit May 15, 2018
sqlf.sql initial commit May 15, 2018
sqlfh.sql initial commit May 15, 2018
sqlflame.sql v0.2 with some more comments Oct 29, 2018
sqlfn.sql initial commit May 15, 2018
sqlfna.sql initial commit May 15, 2018
sqlh.sql initial commit May 15, 2018
sqli.sql initial commit May 15, 2018
sqlid.sql add ela_sec_exec column Sep 7, 2018
sqlidx.sql initial commit May 15, 2018
sqll.sql initial commit May 15, 2018
sqlmem.sql initial commit May 15, 2018
sqlmemx.sql initial commit May 15, 2018
sqlmon.sql initial commit May 15, 2018
sqlmon_restarts.sql formatting Sep 7, 2018
sqlmon_sn.sql initial commit May 15, 2018
sqlopt.sql initial commit May 15, 2018
sqlprof.sql initial commit May 15, 2018
sqlt.sql initial commit May 15, 2018
sqlt9.sql initial commit May 15, 2018
sqltune_tune_sqlid.sql initial commit May 15, 2018
sr.sql initial commit May 15, 2018
sr2.sql initial commit May 15, 2018
sr_old.sql initial commit May 15, 2018
srp.sql initial commit May 15, 2018
srs.sql initial commit May 15, 2018
sru.sql initial commit May 15, 2018
srun.sql initial commit May 15, 2018
st.sql initial commit May 15, 2018
stack_helper.vbs initial commit May 15, 2018
stat.sql initial commit May 15, 2018
statn.sql initial commit May 15, 2018
subheap.sql initial commit May 15, 2018
sum.sql initial commit May 15, 2018
svcs.sql initial commit May 15, 2018
sw.sql initial commit May 15, 2018
sw2.sql initial commit May 15, 2018
swa.sql initial commit May 15, 2018
swag.sql initial commit May 15, 2018
swani.sql initial commit May 15, 2018
swb.sql initial commit May 15, 2018
swf.sql initial commit May 15, 2018
swg.sql initial commit May 15, 2018
swo.sql initial commit May 15, 2018
swp.sql initial commit May 15, 2018
swu.sql initial commit May 15, 2018
swug.sql initial commit May 15, 2018
sye.sql initial commit May 15, 2018
syn.sql initial commit May 15, 2018
syn2.sql initial commit May 15, 2018
sys.sql initial commit May 15, 2018
sysm.sql initial commit May 15, 2018
sysopt.sql initial commit May 15, 2018
syspriv.sql initial commit May 15, 2018
syt.sql initial commit May 15, 2018
t.sql initial commit May 15, 2018
tab.sql initial commit May 15, 2018
tab2.sql initial commit May 15, 2018
tabhist.sql initial commit May 15, 2018
tabpart.sql initial commit May 15, 2018
tabsubpart.sql initial commit May 15, 2018
tail.sql initial commit May 15, 2018
temp.sql initial commit May 15, 2018
ti.sql updates for AST class Oct 15, 2018
tlc.sql initial commit May 15, 2018
toff.sql initial commit May 15, 2018
ton.sql initial commit May 15, 2018
top.sql initial commit May 15, 2018
topcur.sql updates for AST class Oct 15, 2018
topcurmem.sql initial commit May 15, 2018
topmsh.sql initial commit May 15, 2018
topseg.sql initial commit May 15, 2018
topseg2.sql initial commit May 15, 2018
topsegstat.sql initial commit May 15, 2018
topsql.sql initial commit May 15, 2018
tpt.sql initial commit May 15, 2018
tq.sql initial commit May 15, 2018
trace.sql initial commit May 15, 2018
traceme.sql initial commit May 15, 2018
traceoff.sql initial commit May 15, 2018
tracesid.sql initial commit May 15, 2018
tracesidoff.sql initial commit May 15, 2018
trans.sql initial commit May 15, 2018
trci.sql initial commit May 15, 2018
trig.sql initial commit May 15, 2018
trigger.sql initial commit May 15, 2018
trim_database.sql initial commit May 15, 2018
troff.sql initial commit May 15, 2018
tron.sql initial commit May 15, 2018
ts.sql initial commit May 15, 2018
tsv.sql initial commit May 15, 2018
typ.sql initial commit May 15, 2018
typ2.sql initial commit May 15, 2018
u.sql initial commit May 15, 2018
u_exit.sql initial commit May 15, 2018
ua.sql initial commit May 15, 2018
uall.sql initial commit May 15, 2018
ub.sql initial commit May 15, 2018
ucpid.sql initial commit May 15, 2018
uds.sql initial commit May 15, 2018
ue.sql initial commit May 15, 2018
uganco.sql initial commit May 15, 2018
ugav.sql initial commit May 15, 2018
ulock.sql initial commit May 15, 2018
umachine.sql initial commit May 15, 2018
undefparm.sql initial commit May 15, 2018
uniq.vbs initial commit May 15, 2018
unix2date.sql initial commit May 15, 2018
uo.sql initial commit May 15, 2018
uopid.sql initial commit May 15, 2018
uos.sql initial commit May 15, 2018
up.sql initial commit May 15, 2018
us.sql initial commit May 15, 2018
use.sql initial commit May 15, 2018
userenv.sql initial commit May 15, 2018
usid.sql initial commit May 15, 2018
uspid.sql initial commit May 15, 2018
usql.sql initial commit May 15, 2018
usqlx.sql initial commit May 15, 2018
utopsql.sql initial commit May 15, 2018
uu.sql initial commit May 15, 2018
v.sql initial commit May 15, 2018
v2.sql initial commit May 15, 2018
vaud.sql initial commit May 15, 2018
w.sql initial commit May 15, 2018
w4.sql initial commit May 15, 2018
waitprof.sql initial commit May 15, 2018
wat.sql initial commit May 15, 2018
wc.sql initial commit May 15, 2018
wp.sql initial commit May 15, 2018
wr.sql initial commit May 15, 2018
wrka.sql add usage info to comments Sep 22, 2018
wrkasum.sql add usage info to comments Sep 22, 2018
x.sql initial commit May 15, 2018
x101.sql initial commit May 15, 2018
x2.sql initial commit May 15, 2018
x9.sql updates for AST class Oct 15, 2018
x9a.sql initial commit May 15, 2018
x9all.sql initial commit May 15, 2018
xa.sql initial commit May 15, 2018
xall.sql initial commit May 15, 2018
xawr.sql expand syntax to @xawr sql_id plan_hash_value Oct 29, 2018
xb.sql fix opt cardinality misestimate logic Oct 30, 2018
xbi.sql fix opt cardinality misestimate logic Oct 30, 2018
xco.sql initial commit May 15, 2018
xde.sql initial commit May 15, 2018
xde2.sql initial commit May 15, 2018
xi.sql updates for AST class Oct 15, 2018
xia.sql updates for AST class Oct 15, 2018
xls.sql initial commit May 15, 2018
xm.sql initial commit May 15, 2018
xma.sql initial commit May 15, 2018
xmai.sql initial commit May 15, 2018
xmon.sql initial commit May 15, 2018
xms.sql initial commit May 15, 2018
xms2.sql initial commit May 15, 2018
xmsh.sql initial commit May 15, 2018
xmsi.sql initial commit May 15, 2018
xp.sql initial commit May 15, 2018
xpa.sql initial commit May 15, 2018
xph.sql initial commit May 15, 2018
xpi.sql initial commit May 15, 2018
xpia.sql initial commit May 15, 2018
xpih.sql initial commit May 15, 2018
xplto.sql initial commit May 15, 2018
xpm.sql initial commit May 15, 2018
xprof.sql initial commit May 15, 2018
xr.sql initial commit May 15, 2018
xs.sql initial commit May 15, 2018
xsid.sql initial commit May 15, 2018
xsida.sql initial commit May 15, 2018
xt.sql initial commit May 15, 2018
xte.sql initial commit May 15, 2018
xtreset.sql initial commit May 15, 2018
xx.sql initial commit May 15, 2018

README.md

Tanel Poder's Troubleshooting Scripts (TPT)

These sqlplus scripts are for Oracle Database performance optimization & troubleshooting. Most of the scripts should be runnable directly from SQL Developer too.

Getting Started & Videos

To get an idea of how I set up my client environment and use some of my main Oracle-related scripts, check out the videos here:

Also you can follow me in Twitter as I'll post any noteworthy updates there: