sqldmp.sh


dumps the shared pool and does explain plans for the heaviest queries as well as statistics on unnecessary parsing due to use of hard coded values instead of bind variables.

To use:
 sqldmp.sh DUMP - dumps the shared pool v$sqlarea
 sqldmp.sh EXPS - gives explain plans
 sqldmp.sh FNDS - finds queries w/o bind variables






Questions or comments ? Send a note to oraperf@yahoo.com