statspack

From: Oradba Linux <oradba_linux_at_verizon.net>
Date: Tue, 30 Jan 2007 02:26:10 GMT
Message-ID: <61yvh.7087$SE6.191@trnddc03>

I am trying to find out the execution plan of a SQL that was executed in the database about a week back. I am using sprepsql.sql. Should i watch out for any surprises , caveats using this. I understand that the execution path about a week back will not be the same as current. I want to actually the execution path the SQL took a week back. Obviously i am trying to performance tune the SQL which is behaving poorly now vs a week back. Received on Mon Jan 29 2007 - 20:26:10 CST