Xref: alice comp.databases.oracle.server:22279 Path: alice!news-feed.fnsi.net!news.idt.net!woodstock.news.demon.net!demon!dispose.news.demon.net!demon!news.demon.co.uk!demon!rwx777.demon.co.uk!steve From: Steve Haynes Newsgroups: comp.databases.oracle.server Subject: NOLOGGING - too much logging! Date: Sat, 6 Jun 1998 17:30:54 +0100 Organization: . Message-ID: <2si5uKA+6We1Ew5u@rwx777.demon.co.uk> X-Trace: news.demon.co.uk 897150723 nnrp-05:25795 NO-IDENT rwx777.demon.co.uk:158.152.187.113 X-Complaints-To: abuse@demon.net MIME-Version: 1.0 X-Newsreader: Turnpike (32) Version 3.05 Lines: 25 Hi All, RE: 8.0.4 on NT. I'm designing a small (2GB) datamart and since it is easily recreated, there is no need for backups, so all redo is a waste of time. I made all tables and indexes no logging but was amazed to see lots of redo still happening. When I checked all_tables I found all the oracle internal stuff set to logging=YES, can I make all that NO as well? The main question is exactly how I can tell the amount of logging going on, the alert log tells me "swtiching to thread 1" etc about every 20 secs (I have 5X5Mb logfiles), this seemed too much so I check trc files from CKPT and something else (sorry can't recall) and these indicated logfile switches every hour or so. What do I believe?! I sometimes see "checkpoint not complete" in the alert log too. Any info around on this, all my million books don't go deep enough. Thanks Steve -- "The floggings will continue until morale improves."