Log Switch hangup?

From: Eric Fang <eric_fang_at_yahoo.com>
Date: Tue, 2 May 2000 22:09:52 -0700 (PDT)
Message-Id: <10485.104763@fatcity.com>

The database is Oracle8i on NT. After certain transactions(delete 1m records from a table), the log switch stops(I checked v$log_history), usually it switches every 30 seconds, I have to tune the redo log by either increase the redo log file(one user with 4 redo log file, 10m each) or increase the log_checkpoint_interval(I set the value as 80000 with db_block_size=16k).

Could anyone give me some advice? Thanks.

ERic Fang

---

Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger. http://im.yahoo.com/ Received on Wed May 03 2000 - 00:09:52 CDT