dba_hist_sql_plan
- 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:
