EVENT: 10500 “turn on traces for SMON”

Error:  ORA 10500
Text:   turn on traces for SMON
-------------------------------------------------------------------------------
Cause:
Action:
        Level:  <=5  trace instance recovery
        > 5  trace posting of SMON

To set event 10500:

For the instance:
a.  Shutdown database
b.  Edit the initialisation parameter file and add:
    event="10500 trace name context forever, level <value>"
c.  restart the database

For the SMON session:
Post the SMON process using oradbx (Oracle 7) or oradebug (Oracle 8).
For oradebug from server manager issue:

oradebug setospid <OS PID>
oradebug event 10500 trace name context forever, level <value>

For further information about oradebug Note 29786.1
                              oradbx   Note 28863.1

<value> is 'Level' as per above

© 2007 – 2011, www.oracledatabase12g.com. 版权所有.文章允许转载,但必须以链接方式注明源地址,否则追究法律责任.

相关文章 | Related posts:

1. EVENT:10061 disable SMON from cleaning temp segment
2. Setting an Oracle event:The structure of the trace syntax
3. EVENT:10211 check index block integrity
4. EVENT:10210 check data block integrity
5. EVENT: 10231 "skip corrupted blocks on _table_scans_"
6. EVENT:10212 check cluster integrity
7. Extracting Data from a Corrupt Table using DBMS_REPAIR or Event 10231
8. EVENT: 10060 dump predicates in optimizer (kko)
9. EVENT:10228 trace application of redo by kcocbk
10. EVENT: 10015 "Write Trace for Undo Segment Recovery"