Tag Archives: scripts

Load profile

I like Load profile section of Statspack or AWR reports (who doesn’t). It’s short and gives a brief understanding of what kind of work a database does. But what if you don’t have an access to Statspack or AWR but still want to see something similar? It’s possible to use V$SYSMETRIC to get this numbers for last 60 or 15 seconds. I wanted to write a script to do this for a long time. Here it is.

Continue reading

Custom treedump

Not a tree, actually 😉 Just dump. Index dump. Custom index dump 😀 with blackjack and hookers (c)
Check it out here if you haven’t seen this yet.