• From: "Jeffrey Beckstrom" <JBECKSTROM@xxxxxxxxx>
  • To: "oracle-l-freelists" <oracle-l@xxxxxxxxxxxxx>, "oracle-db-l" <oracle-db-l@xxxxxxxxxxxxxxxxxxxx>
  • Date: Wed, 02 Jun 2010 12:21:30 -0400

I was trying to find out some sql in sys.dba_hist_sql_plan but was
unable to.  I had seen the sql running, captured the sql_id and then
waited until the next hour and still not in the table.  What controls
putting information in sys.dba_hist_sql_plan?
Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority
1240 W. 6th Street
Cleveland, Ohio 44113

Other related posts: