Find the SID and SERIAL# from v$session, slap a trace
on the session using DBMS_SUPPORT and see what pops
out
hth
connor
--- Seema Singh [EMAIL PROTECTED] wrote: Hi,
I have been noticing on oRACLE 9i ora_j000 process
is taking more CPU.
When I select sid,job from dba_jobs_running its
looks
Hi,
I have been noticing on oRACLE 9i ora_j000 process is taking more CPU.
When I select sid,job from dba_jobs_running its looks like hanging.
Let me know what could be reason?
th -Seema
_
High-speed Internet access as low as
Hi,
Are job_queue_interval and job_queue_process parameters applicable to both
dedicated and parallel server? any changes regarding this in 8i.
rgds
amar
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Amar Kumar Padhi
INET: [EMAIL PROTECTED]
Fat City Network
Yes - and from 8i (I think) upwards you can bind a job
to a particular instance.
hth
connor
--- Amar Kumar Padhi [EMAIL PROTECTED] wrote:
Hi,
Are job_queue_interval and job_queue_process
parameters applicable to both
dedicated and parallel server? any changes
regarding this in 8i.