Re: Oracle Server - HELP HELP

This is the usual 'Bakker' post.... with the nasty remark to someone he nows not!

See Bakker, here you are again. Could you not present your answer without the nasty remark?
Huh idiot?

Sybrand Bakker wrote:

> On Sat, 7 Jun 2003 19:24:02 +0800, "jj" <14g_at_hongkong.com> wrote:
>
> >Dear everybody,
> >
> >After i upgrade my oracle to 8.1.7, i encounter a problem that some Oracle
> >process consume high cpu utilization. It makes no one can connect to the
> >Oracle.
> >
> >When i want to check what the process is running, the process completed and
> >next process started to consume CPU resources.
> >The problem disappear when i restart the Oracle
> >
> >Can anyone tell me what's wrong?
> >How can i trace this problem?
> >
> >Regards,
> >Lewis_at_zone1511.net
> >
> This is the usual post without any useful clue.
> What is the *version* (8.1.7 doesn't tell anything, especially if you
> installed from CD the 8.1.7.0.0 version)
> Which platform and version?
>
> You should be capable, using v$sesstat to check which sessions consume
> the most cpu. v$session holds the sql_hash_value and the sql_address
> of the currently executing statement.
> You can find that statement, including resources it is consuming in
> v$sql_area
> and the full text in v$sqltext_with_newlines
>
> Hth
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Sat Jun 07 2003 - 21:57:43 CDT