Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Top SQL from statspack
Try running $ORACLE_HOME/rdbms/admin/sprepsql.sql. Give it the bsnap,
esnap, and hash value. It will produce a report with the full sql
statement in it.
Received on Mon Dec 20 2004 - 10:14:23 CST