Re: DIRTY BUFFER FLUSH!!!!

From: Jeremiah Wilton <jeremiah_at_wolfenet.com>
Date: Sun, 27 Dec 1998 23:48:43 -0800
Message-ID: <Pine.OSF.3.95.981227233739.27148A-100000@gonzo.wolfenet.com>

On Fri, 25 Dec 1998 naveen_arora_at_my-dejanews.com wrote:
>
> I see on my ORACLE server on UNIX, making idle time of CPU =0
> DBWR,LGWR,SNPs processes are eating away time.
> Is there any means to fllush dirty buffers,
> WITHOUT DBSHUT/DBSTART ?
To force a global checkpoint of dirty blocks in the buffer to all the datafiles, you can use "alter system checkpoint." This will force a fast checkpoint (similar to the slow checkpoint performed at log switch).

However, I would be quick to point out that having dirty buffer blocks does not correlate to having Oracle's background processes chewing up 100% of your CPU. If no work is being performed, the instance should use a minimal amount of resources on the host. Whichever process is running away with the CPU should be examined for problems. The oradebug feature of Server Manager allows you to attatch to a running Oracle process and dump the state to a trace file.

--
Jeremiah Wilton http://www.wolfenet.com/~jeremiah Received on Mon Dec 28 1998 - 01:48:43 CST