FAQ
Which trace files can I remove and which ones shouldn't I remove. I used to
remove all trace files two week old or older, but found that even though I removed
them the database still thought it was writing to them. When I went to look at the
trace files specified in the alert log Oracle had not recreated them so I couldn't
get all the info I needed.

Thanks, Dave Turner
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: David Turner
INET: turner_at_tellme.com

Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).

Search Discussions

  • Kevin Lange at Nov 2, 2001 at 9:34 pm
    I used to just drop trace files created before the last restart of the
    database.

    -----Original Message-----
    Sent: Friday, November 02, 2001 2:50 PM
    To: Multiple recipients of list ORACLE-L

    Which trace files can I remove and which ones shouldn't I remove. I used to
    remove all trace files two week old or older, but found that even though I
    removed
    them the database still thought it was writing to them. When I went to look
    at the
    trace files specified in the alert log Oracle had not recreated them so I
    couldn't
    get all the info I needed.

    Thanks, Dave Turner
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: David Turner
    INET: turner_at_tellme.com

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------

    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Kevin Lange
    INET: kgel_at_ppoone.com

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------

    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
  • Connor McDonald at Nov 2, 2001 at 10:04 pm
    fuser should tell you if they are being written to at
    the moment. Otherwise you could use the routine
    dbms_system.read_ev to see which sessions have 10046
    set - if they do, then keep the trace file

    hth
    connor

    David Turner wrote: > Which
    trace files can I remove and which ones
    shouldn't I remove. I used to
    remove all trace files two week old or older, but
    found that even though I removed
    them the database still thought it was writing to
    them. When I went to look at the
    trace files specified in the alert log Oracle had
    not recreated them so I couldn't
    get all the info I needed.


    Thanks, Dave Turner
    --
    Please see the official ORACLE-L FAQ:
    http://www.orafaq.com
    --
    Author: David Turner
    INET: turner_at_tellme.com

    Fat City Network Services -- (858) 538-5051 FAX:
    (858) 538-5051
    San Diego, California -- Public Internet
    access / Mailing Lists
    To REMOVE yourself from this mailing list, send an
    E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of
    'ListGuru') and in
    the message BODY, include a line containing: UNSUB
    ORACLE-L
    (or the name of mailing list you want to be removed
    from). You may
    also send the HELP command for other information
    (like subscribing).
    Connor McDonald
    http://www.oracledba.co.uk (mirrored at
    http://www.oradba.freeserve.co.uk)

    "Some days you're the pigeon, some days you're the statue"

    Do You Yahoo!?
    Everything you'll ever need on one web page from News and Sport to Email and Music
    Charts
    http://uk.my.yahoo.com

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: =?iso-8859-1?q?Connor=20McDonald?=
    INET: hamcdc_at_yahoo.co.uk

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedNov 2, '01 at 8:38p
activeNov 2, '01 at 10:04p
posts3
users3
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase