| OEM not showing Explain Plan [message #441494] |
Mon, 01 February 2010 07:51  |
firefly
Messages: 53
Registered: March 2009
Location: Europe
|
Member |
|
|
Hi,
When viewing SQL statements in Top Activity in OEM, I am only able to see the Explain Plan for the most recent statement. Is there a setting to increase the number execution plans kept?
Thanks
F
|
|
|
|
 Re: OEM not showing Explain Plan [message #441512 is a reply to message #441494] |
Mon, 01 February 2010 13:24  |
 |
LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL
|
Senior Member |
|
|
The SQL statement may be there in the AWR (depending on your snapshot retention), You could try:
Database -> Performance -> Advisor Central -> Historical SQL (or Snapshots).
PS: Also in db -> Performance you can select View data: Historical to move the window to the date/time your query was executing.
[Updated on: Mon, 01 February 2010 13:35] by Moderator Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
