Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> NOLOGGING - too much logging!
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."
Received on Sat Jun 06 1998 - 11:30:54 CDT