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 Apr 17 00:02:57 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.