Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Instance has a process running constantly
Thanks for responding Ron.
Here's the SGA info:
Database buffers = 400 kbytes
Fixed size = 48 kbytes Redo Buffers = 72 kbytes variable Size = 7,404 kbytes
I'm not sure how to tell if there are any tasks from DBMS_Jobs running. I ran the view sys.dba_jobs_running and got zero rows returned. I found 6 active session IDs running in the Instance Manager, all with OS User = "unknown" and Program = oracle80.exe.
"Ron Reidy" <ron_at_indra.com> wrote in message
news:3BB10C2D.98B915FB_at_indra.com...
> DAR wrote:
> >
> > When my instance of Oracle is running, my hard drive light is constantly
> > glowing. No applications are running. When I display Window's Task
Manager
> > and view Processes, ORACLE80.EXE is using a large share of Memory (Mem
> > Usage) and CPU. The CPU and Mem Usage constantly change. If I stop this
> > instance of Oracle, my hard drive light stops glowing.
> >
> > When I query the table sys.gv_$session_event, the row where "event" =
"db
> > file sequential read" and "sid" = 5 has it's "total_waits" in the tens
of
> > millions. Every time I requery, it increases rapidly.
> >
> > I have other PC on my network, but the problem occurs whether they're
turned
> > on or off.
> >
> > I've turned on auditing but I'm not sure what to audit. I have 5 or 6
> > tablespaces.
> >
> > I'm running Oracle 8.0.5 on Win 2000 Pro. Any suggestions will be
> > appreciated.
> How big is the SGA? Are there any tasks running from DBMS_JOBS? How
> big are your redo logs? etc. etc.
> --
> Ron Reidy
> Oracle DBA
> Reidy Consulting, L.L.C.
Received on Wed Sep 26 2001 - 09:57:01 CDT