Home » RDBMS Server » Enterprise Manager » OEM not showing Explain Plan
OEM not showing Explain Plan [message #441494] Mon, 01 February 2010 07:51 Go to next message
Messages: 53
Registered: March 2009
Location: Europe

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?


icon12.gif  Re: OEM not showing Explain Plan [message #441512 is a reply to message #441494] Mon, 01 February 2010 13:24 Go to previous message
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

Previous Topic: Dump area getting increase
Next Topic: Oracle Enterprise Manager NOT showing correct status
Goto Forum:

Current Time: Thu Apr 22 12:05:49 CDT 2021