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
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
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
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).
/forum/fa/2115/0/
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 Mar 28 18:42:27 CDT 2024