摘要: Managing the UNDO TABLESPACE Every Oracle Database must have a method of maintaining information that is used to roll back, or undo, changes to the da 阅读全文
posted @ 2020-01-31 22:51 耀阳居士 阅读(140) 评论(0) 推荐(0) 编辑
摘要: To Bottom In this Document Goal Solution References APPLIES TO: Oracle Database - Enterprise Edition - Version 9.0.1.0 to 12.1.0.1 [Release 9.0.1 to 1 阅读全文
posted @ 2020-01-31 22:48 耀阳居士 阅读(288) 评论(0) 推荐(0) 编辑
摘要: How To Size UNDO Tablespace For Automatic Undo Management (Doc ID 262066.1) To Bottom In this Document Goal Solution References APPLIES TO: Oracle Dat 阅读全文
posted @ 2020-01-31 22:46 耀阳居士 阅读(211) 评论(0) 推荐(0) 编辑
摘要: Rollback Segment Configuration & Tips (Doc ID 69464.1) To Bottom ROLLBACK SEGMENT CONFIGURATION & TIPS Good rollback segment configuration is crucial 阅读全文
posted @ 2020-01-31 22:44 耀阳居士 阅读(142) 评论(0) 推荐(0) 编辑
摘要: 1、概念 Transaction以轮循的方式使用rollback segment里的extent,当前所在的extent满时就移动到下一个extent。可能有多个transaction同时向同一个extent写数据,但一个rollback segment block中只能保存一个transactio 阅读全文
posted @ 2020-01-31 20:34 耀阳居士 阅读(841) 评论(0) 推荐(0) 编辑
摘要: 目录 1)连接请求的变量 1、max_connections 2、back_log 3、wait_timeout和interative_timeout 2)缓冲区变量 4、key_buffer_size 5、query_cache_size(查询缓存简称QC) 6、max_connect_error 阅读全文
posted @ 2020-01-31 10:06 耀阳居士 阅读(363) 评论(0) 推荐(0) 编辑