




版权说明:本文档由用户提供并上传,收益归属内容提供方,若内容存在侵权,请进行举报或认领
文档简介
1、Managing Undo DataObjectivesAfter completing this lesson, you should be able to do the following:Explain DML and redo data generationMonitor and administer undo dataDescribe the difference between undo data and redo dataConfigure undo retentionGuarantee undo retentionUse the Undo AdvisorData Manipul
2、ationData manipulation language (DML) consists of the following SQL statements:INSERTUPDATEDELETEMERGEDML always executes as part of a transaction, which can be:Rolled back, using the ROLLBACK commandCommitted, using the COMMIT commandData Manipulation and Redo DataBlock 1Block 3Block 2SQL COMMIT;Re
3、do log fileVerify that redo data is on the disk and write COMMIT recordWrite verified, COMMITrecord written, control returned SQL SQL DELETE FROM employees WHERE salary 10000;SQL UPDATE employeesSET salary = 5000WHERE employee_id = 202;Undo DataUndo data is:A copy of original, premodified dataCaptur
4、ed for every transaction that changes dataRetained at least until the transaction is endedUsed to support:Rollback operationsRead-consistent and flashback queriesRecovery from failed transactionsUserUndo DataFull Notes PageTransactions and Undo DataEach transaction is assignedto only one undo segmen
5、t.An undo segment can servicemore than one transaction at a time.Update transactionOld valueNew valueUndo segmentTableStoring Undo InformationUndo information is stored in undo segments, which are, in turn, stored in an undo tablespace. Undo tablespaces:Are used only for undo segmentsHave special re
6、covery considerationsMay be associated with only a single instanceRequire that only one of them be the current writable undo tablespace for a given instance at any given timeUndo Data Versus Redo DataUndoRedoRecord ofHow to undo a changeHow to reproduce a changeUsed forRollback, read-consistency, an
7、d flashbackRecovery, to roll forward database changesStored inUndo segmentsRedo log filesProtects againstInconsistent reads in multiuser systemsData lossMonitoring UndoUndo usually requires little management. The areas to monitor include:Free space in an undo tablespace“Snapshot too old” errorsDBAMo
8、nitoring UndoFull Notes PageAdministering UndoAdministration of undo should include preventing:Space errors in an undo tablespace:Size the undo tablespace properly.Ensure that large transactions commit periodically.“Snapshot too old” errors:Configure an appropriate undo retention interval.Size the u
9、ndo tablespace properly.Consider guaranteeing undo retention.Use automatic undo management:DBAUNDO_MANAGEMENT=AUTOUNDO_TABLESPACE=UNDOTBS1Configuring Undo RetentionDBAUNDO_RETENTION specifies (in seconds) the amount of already committed undo information that is to be retained. The only time you must
10、 set this parameter is when:The undo tablespace has the AUTOEXTEND option enabledYou want to set undo retention for LOBsYou want to guarantee retentionConfiguring Undo RetentionFull Notes PageGuaranteeing Undo RetentionGuarantee: 15 minutesA transaction that generatesmore undo than what thereis spac
11、e for will fail.Undo dataSELECT statementsrunning 15 minutes or lessare always satisfied.Sizing the Undo TablespaceCurrent table-space sizeUndo consumption rateUsing the Undo AdvisorSummaryIn this lesson, you should have learned how to:Explain DML and redo data generationMonitor and administer undo segmentsConfigure undo retentionGuarantee undo retentionUse the Undo AdvisorPractice Overview: Managing Undo SegmentsThis
温馨提示
- 1. 本站所有资源如无特殊说明,都需要本地电脑安装OFFICE2007和PDF阅读器。图纸软件为CAD,CAXA,PROE,UG,SolidWorks等.压缩文件请下载最新的WinRAR软件解压。
- 2. 本站的文档不包含任何第三方提供的附件图纸等,如果需要附件,请联系上传者。文件的所有权益归上传用户所有。
- 3. 本站RAR压缩包中若带图纸,网页内容里面会有图纸预览,若没有图纸预览就没有图纸。
- 4. 未经权益所有人同意不得将文件中的内容挪作商业或盈利用途。
- 5. 人人文库网仅提供信息存储空间,仅对用户上传内容的表现方式做保护处理,对用户上传分享的文档内容本身不做任何修改或编辑,并不能对任何下载内容负责。
- 6. 下载文件中如有侵权或不适当内容,请与我们联系,我们立即纠正。
- 7. 本站不保证下载资源的准确性、安全性和完整性, 同时也不承担用户因使用这些下载资源对自己和他人造成任何形式的伤害或损失。
最新文档
- 预防安全攀爬课件
- 妇产科健康教育与咨询指导技术
- 顺产产妇护理课件
- 项目工程管理第五章课件
- 水肌酸产品项目社会稳定风险评估报告(模板)
- 县医院医疗服务能力基本标准
- 县防汛应急预案、县抗旱应急预案、县自然灾害救助应急预案、县处置森林火灾应急预案
- 五年级奥数春季班第13讲-概率初识
- 2025年卫星云图接收设备项目合作计划书
- 现代康复治疗技术考试试题含答案
- 【超星尔雅学习通】航空概论网课章节答案
- 兽医传染病学(山东联盟)智慧树知到答案章节测试2023年青岛农业大学
- 肠系膜脉管系统肿瘤的诊断
- 爆破工程技考核试卷
- GB/T 35273-2020信息安全技术个人信息安全规范
- GB 18068-2000水泥厂卫生防护距离标准
- 教师调动登记表(模板)
- 2022年医院收费员考试试题及答案
- 福建省林业行政执法人员法律考试
- 《组织机构代码证》word版
- 钢筋下料单(参考模板)
评论
0/150
提交评论