dba_hist_sql_plan
From: Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org>
Date: Wed, 02 Jun 2010 12:21:30 -0400
Message-Id: <4C064CCA0200000B004C22CF_at_groupwise.gcrta.org>
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?
Date: Wed, 02 Jun 2010 12:21:30 -0400
Message-Id: <4C064CCA0200000B004C22CF_at_groupwise.gcrta.org>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jun 02 2010 - 11:21:30 CDT