OraFAQ Forum: Enterprise Manager » Display details from error tab with a query in Oracle enterprise manager 10.2.0.1

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)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Display details from error tab with a query in Oracle enterprise manager 10.2.0.1 [message #649378]

Wed, 23 March 2016 14:48

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 2110 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

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

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

Report message to a moderator

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

Julya
Messages: 4
Registered: March 2016
Location: Bucharest

Junior Member

Hi ,
thanks for help, how can i trace EM sessions ?

Report message to a moderator

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

BlackSwan
Messages: 26766
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

Report message to a moderator

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

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

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

Report message to a moderator

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

Julya
Messages: 4
Registered: March 2016
Location: Bucharest

Junior Member

Thanks a lot !!

Report message to a moderator

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

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!

Report message to a moderator

Previous Topic:	EM shows white screen after login as sys
Next Topic:	unable to configure dbconsole in oracle

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 17:08:58 CST 2024