Re: select question

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Tue, 18 Mar 2003 08:58:43 +0100
Message-ID: <u9kd7vgi9tqa7h82i6pbf5gucjt4p3bllb@4ax.com>

On Tue, 18 Mar 2003 15:33:45 +0800, "music4" <music4_at_163.net> wrote:

>Do you have any more idea?

Most likely your server is badly tuned, your online redo log files are way too small (the default is 200k, which is ridiculous nowadays) and you are switching log files like hell, which would be easily pertinent from v$log_history.
Please try to *resolve* the *issue* instead of just *fighting symptoms*

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Mar 18 2003 - 01:58:43 CST