DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2001
    Baltimore, MD
    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?
    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
    Madrid, Spain
    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
    California, USA


    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,

    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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.