-
No logging option for Online logs
Hi,
How do i find out if my online logs have nologging option or not
Thanks
Tony
Life is what is happening today while you were planning tomorrow.
-
Re: No logging option for Online logs
Originally posted by ndisang
Hi,
How do i find out if my online logs have nologging option or not
Thanks
Tony
Huh? Do you mean archivelog mode? Do you mean objects in nologging mode?
Jeff Hunter
-
What i mean is this -
Assuming you want to bypass online logs during a load (to make it faster) you may want to have your online redologs not logging these transactions.
So I want to find out if those online logs have nologging on or off
Thanks
Life is what is happening today while you were planning tomorrow.
-
It is your TABLE/index that's in a logging/nologging mode. You can check this by looking at dba_tables, dba_indexes. Oh, and you also wanna check if the tablespace itself is in a forcelogging mode. If so, you can't do any nologging operations, without disabling t/s force logging first.
Many different factors affect if your transactions are getting logged. Depends on how you are loading data. Here is a concise table from asktom for direct-load inserts..if that's what you're using.
Table Mode Insert Mode ArchiveLog mode result
----------- ------------- ----------------- ----------
LOGGING APPEND ARCHIVE LOG redo generated
NOLOGGING APPEND ARCHIVE LOG no redo
LOGGING no append "" redo generated
NOLOGGING no append "" redo generated
LOGGING APPEND noarchive log mode no redo
NOLOGGING APPEND noarchive log mode no redo
LOGGING no append noarchive log mode redo generated
NOLOGGING no append noarchive log mode redo generated
PS: Sorry it's not formatted. But here's the link
http://asktom.oracle.com/pls/ask/f?p...5280714813869,
Last edited by Axr2; 06-25-2004 at 12:44 PM.
-
Life is what is happening today while you were planning tomorrow.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|