Home » RDBMS Server » Enterprise Manager » Display details from error tab with a query in Oracle enterprise manager 10.2.0.1 (Enterprise manager 10.2.0.1)
Display details from error tab with a query in Oracle enterprise manager 10.2.0.1 [message #649378] Wed, 23 March 2016 14:48 Go to next message
Julya
Messages: 4
Registered: March 2016
Location: Bucharest
Junior Member
Hi,
i need urgently to know , how to Display details from error tab with a query in Oracle enterprise manager 10.2.0.1,
see the attachment.
I mean, how can i find the tables that stay behind Enterprise manager 10.2.0.1.
I need to make a query to display details , from the image attached.
I don't want to user the graphic interface.
Thanks in advance for help!

  • Attachment: oem_10.jpg
    (Size: 62.95KB, Downloaded 95 times)

[Updated on: Wed, 23 March 2016 14:51]

Report message to a moderator

Re: Display details from error tab with a query in Oracle enterprise manager 10.2.0.1 [message #649379 is a reply to message #649378] Wed, 23 March 2016 14:54 Go to previous messageGo to next message
Michel Cadot
Messages: 65203
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

(SQL) Trace the EM session, you will then see which queries it executes.

Re: Display details from error tab with a query in Oracle enterprise manager 10.2.0.1 [message #649380 is a reply to message #649379] Wed, 23 March 2016 15:00 Go to previous messageGo to next message
Julya
Messages: 4
Registered: March 2016
Location: Bucharest
Junior Member
Hi ,
thanks for help, how can i trace EM sessions ?
Re: Display details from error tab with a query in Oracle enterprise manager 10.2.0.1 [message #649381 is a reply to message #649380] Wed, 23 March 2016 15:03 Go to previous messageGo to next message
BlackSwan
Messages: 25720
Registered: January 2009
Location: SoCal
Senior Member
unwilling or incapable to use GOOGLE yourself?

https://www.google.com/webhp?hl=en&tab=ww#hl=en&q=oracle+sql+trace+session
Re: Display details from error tab with a query in Oracle enterprise manager 10.2.0.1 [message #649382 is a reply to message #649380] Wed, 23 March 2016 15:04 Go to previous messageGo to next message
Michel Cadot
Messages: 65203
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Query V$SESSION to know which session is running EM then use DBMS_MONITOR.SESSION_TRACE_ENABLE.

icon14.gif  Re: Display details from error tab with a query in Oracle enterprise manager 10.2.0.1 [message #649386 is a reply to message #649382] Wed, 23 March 2016 15:31 Go to previous messageGo to next message
Julya
Messages: 4
Registered: March 2016
Location: Bucharest
Junior Member
Thanks a lot !!
Re: Display details from error tab with a query in Oracle enterprise manager 10.2.0.1 [message #649410 is a reply to message #649382] Thu, 24 March 2016 13:36 Go to previous message
Julya
Messages: 4
Registered: March 2016
Location: Bucharest
Junior Member
Hi i tried,
but i did not found in the sqls from trc, information from details window.
Any news ideas ?
Thanks a lot!
Previous Topic: EM shows white screen after login as sys
Next Topic: unable to configure dbconsole in oracle
Goto Forum:
  


Current Time: Thu Nov 23 21:37:28 CST 2017

Total time taken to generate the page: 0.02396 seconds