DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: No logging option for Online logs

  1. #1
    Join Date
    Sep 2001
    Posts
    200

    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.

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092

    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

  3. #3
    Join Date
    Sep 2001
    Posts
    200
    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.

  4. #4
    Join Date
    Oct 2002
    Posts
    807
    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.

  5. #5
    Join Date
    Sep 2001
    Posts
    200
    Thanx a bunch
    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
  •  


Click Here to Expand Forum to Full Width