Error: ORA 10061 Text: disable SMON from cleaning temp segment ------------------------------------------------------------------------------- Explanation: This is NOT an error but is a special EVENT code. It should *NOT* be used unless explicitly requested by RD support. It allows you to prevent SMON from cleaning up temporary segments. If set in: 7.0.X: This will prevent SMON performing cleanup of TEMP segments and from coalsecing extents. The cleanup action was performed every 3 minutes in 7.0.X releases. 7.1.X: The event behaviour is modified in that TEMP segment cleanup is skipped on TIMEOUTS but will be performed if SMON is posted. The cleanup only occurs every 12 hours or when posted in 7.1.X releases. You can POST SMON by performing a failed CREATE TABLE command. A new event 10269 is for coalescing extents. Usage: event="10061 trace name context forever, level 10" Articles: @Archived Managing SMON Activity on multiple OPS instances <Note:45856.1>
© 2006 – 2011, www.oracledatabase12g.com. 版权所有.文章允许转载,但必须以链接方式注明源地址,否则追究法律责任.
相关文章 | Related posts:
- EVENT: 10015 "Write Trace for Undo Segment Recovery"
- Setting an Oracle event:The structure of the trace syntax
- EVENT:10228 trace application of redo by kcocbk
- EVENT:10210 check data block integrity
- EVENT:10212 check cluster integrity
- Rollback Segment Utilization:Extent, Wrap and Shrink
- EVENT: 10231 "skip corrupted blocks on _table_scans_"
最新评论