Re: Oracle Server - HELP HELP

Dear Anton,

> And it comes back when Oracle is up and running for some time?
YES
> Can you identify what process it is: a background process or is it from a
> session?

It should be a session.

> Which platform? On Unix I would use top to see the process name. When it
is

Sparc/Solaris 8 on Suncluster 3.0, I used TOP to see the process ID, but i can't connect to Oracle already.

> for example ora_snp<n>_<SID> it is a job that's running (query DBA_JOBS or
> DBA_JOBS_RUNNING).
> From what version did you upgrade?

Upgrade from 8.1.6.

> Check alert log and look for possible trace files in udump or bdump
> directory of ORACLE_HOME/rdbms/log dir, maybe you find some info there.
>

"Anton Buijs" <remove_aammbuijs_at_xs4all.nl> ??? news:3ee1d460$0$49114$e4fe514c_at_news.xs4all.nl ???...
>
> jj <14g_at_hongkong.com> schreef in berichtnieuws
> bbsi0q$i464_at_rain.i-cable.com...
> | 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
> |
>
> And it comes back when Oracle is up and running for some time?
> Can you identify what process it is: a background process or is it from a
> session?
> Which platform? On Unix I would use top to see the process name. When it
is
> for example ora_snp<n>_<SID> it is a job that's running (query DBA_JOBS or
> DBA_JOBS_RUNNING).
> From what version did you upgrade?
> Check alert log and look for possible trace files in udump or bdump
> directory of ORACLE_HOME/rdbms/log dir, maybe you find some info there.
>
>
Received on Sat Jun 07 2003 - 07:26:11 CDT