SETTING EVENT- ERRORSTACK
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: SETTING EVENT- ERRORSTACK

Hybrid View

  1. #1
    Join Date
    Dec 2001
    Location
    Baltimore, MD
    Posts
    372
    Hi All
    How do set event to get more details through trace generated by ORA-00272.

    event="00272 trace name errorstack level 10"

    is this set at the sqlplus or c:\ prompt?

    Do you only set event through trace generated .trc or ORA- message as well?

    Based on the above ora-00272 Can some one show me an example please?
    Thanks
    Arsene Lupain
    The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    yo do that when support tells you, even you do it what are you going to do with the trace file, even support needs a documentation to decode the trace file when they are reading it....

  3. #3
    Join Date
    May 2002
    Location
    California, USA
    Posts
    175

    Cool

    You can do that two ways:

    1. In your init.ora file:

    event="00272 trace name errorstack level 10'

    reboot Oracle db after that.

    2. From svrmgrl as user internal or sqlplus - sysdba (9i):

    ALTER SYSTEM SET EVENT '00272 trace name errorstack level 10';

    Setting the event will dump the memory heap, which Oracle Support will use to find the cause of the ORA-00272 error. Also could dump the SQL statement causing the error. The pattern is:

    00272 - ORA-00272
    trace name - trace file in udump
    level 10 - how much information to be dumped.

    It is good idea to do that with Oracle Support guidance, since anyway they have to figure it our what is the reason.

    Hope that helps,

    clio_usa
    Senior Oracle DBA

    visit our web site !!







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