Home » RDBMS Server » Server Administration » Discoverer inactive process / CPU use problems on Oracle 8
Discoverer inactive process / CPU use problems on Oracle 8 [message #63986] Thu, 02 December 2004 02:01 Go to next message
Patrick Tahiri
Messages: 119
Registered: January 2004
Senior Member
Hi,

I runned a report via Discoverer, and it seems that even when the report is finished (DML were executed and finished, no physical reads and consistent gets), there is still an inactive discoverer process (on the database side) that is using huge amount of CPU?! Anyone had similar problems? Could someone explain me why or what can be at the origin of this problem?

I had to kill the process and then everything (CPU use) went back to normal again.

Many thanks!

Best regards,

Patrick.

Report message to a moderator

Re: Discoverer inactive process / CPU use problems on Oracle 8 [message #63990 is a reply to message #63986] Thu, 02 December 2004 07:06 Go to previous messageGo to next message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
Run a trace on the session to see what you can determine about the originating call.

Run tkprof against the .trc using "record=disco_call.sql"

Report message to a moderator

Re: Discoverer inactive process / CPU use problems on Oracle 8 [message #63994 is a reply to message #63986] Thu, 02 December 2004 21:00 Go to previous message
Frank
Messages: 7901
Registered: March 2000
Senior Member
In OEM you should be able to see the current SQL of the session.
If this sql takes a loooong time, no point in creating a trace, it will only be in the trace once the statement comes to an end.
btw, this is where StatsPack comes in very handy !

hth

Report message to a moderator

Previous Topic: PLS-00123 & Resource_Limit parameter ?
Next Topic: How to upgrade my Oracle 9.2.0?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jan 09 22:49:30 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.