- 浏览: 25817 次
- 性别:
- 来自: 北京
最新评论
1.manual
undo_management=manual
transactions
transactions_per_rollback_segment
rollback_segments =('rbs1','rbs2')
create rollback segment rbs1 tablespace undotbs1; privs seg
create public rollback segment prbs1 tablespace undotbs1 public seg
alter rollback segment rbs1 online;
note: create rollback segment default offline,we need to online;
when instance startup, the oracle open private seg(rollback_segments ),then caculate the numbers of rollbacksegments with transactions/transactions_per_rollback_segment.if rollback_segments = the result, oracle open database,other ,get public segs then open database.
2.auto
undo_management=auto
undo_tablespace=undotbs1
if undotablespace is to small,autoetend off ,when we execute big transactions, we encounter some errors.ORA-30036: unable to extend segment by 8 in undo tablespace 'SMALLUNDO'. ORA-06512: at line 3
3. it is a common misconception that undo is used to restore the database physically to the
way it was before the statement or transaction executed, but this is not so. The database is
logically restored to the way it was—any changes are logically undone—but the data struc-
tures, the database blocks themselves, may well be different after a rollback. The reason for
this lies in the fact that, in any multiuser system, there will be tens or hundreds or thousands
of concurrent transactions. One of the primary functions of a database is to mediate concur-
rent access to its data. The blocks that our transaction modifies are, in general, being modified
by many other transactions as well. Therefore, we cannot just put a block back exactly the way
it was at the start of our transaction—that could undo someone else’s work!
For example, suppose our transaction executed an INSERT statement that caused the allo-
cation of a new extent (i.e., it caused the table to grow). Our INSERT would cause us to get a
new block, format it for use, and put some data on it. At that point, some other transaction
might come along and insert data into this block. If we were to roll back our transaction, obvi-
ously we cannot unformat and unallocate this block. Therefore, when Oracle rolls back, it is
really doing the logical equivalent of the opposite of what we did in the first place. For every
INSERT, Oracle will do a DELETE. For every DELETE, Oracle will do an INSERT. For every UPDATE,
Oracle will do an “anti-UPDATE,” or an UPDATE that puts the row back the way it was prior to our
modification.
4.Generates the Most and Least Undo
an INSERT will, in general, generate the least amount of undo, since all Oracle needs to record for this is a rowid to “delete.
The INSERT generated very little undo that needed to be logged.
The UPDATE generated an amount equal to the before image of the data that was changed.
The DELETE generated the entire set of data written into the undo segment.
an update of an unindexed column not only executes much faster, but will tend to generate significantly less undo than an update of an indexed column.
5.ORA-01555: snapshot too old Error,provide for read consistency,
that results in the ORA-01555 error
CAUSE:
• The undo segments are too small for the work you perform on your system.
• Your programs fetch across COMMITs (actually a variation on the preceding point).
We covered this in the last chapter.
• Block cleanout. Delayed Block Cleanout,To clean out the
block, Oracle determines the undo segment used for the previous transaction (from the blocks
header) and then determines if the undo header indicates whether it has been committed or
not. This confirmation is accomplished in one of two ways. One way is that Oracle can deter-
mine that the transaction committed a long time ago, even though its transaction slot has
been overwritten in the undo segment transaction table. The other way is that the COMMIT SCN
is still in the transaction table of the undo segment, meaning the transaction committed a short time ago, and its transaction slot hasn’t been overwritten.if its transaction slot has been overwritten,when clear block ,result in ORA-01555.
发表评论
-
from string get number data using pl/sql or sql
2012-02-16 17:32 849declare @aa varchar(80),--- ... -
SQL
2012-02-15 18:01 6761.select sal salary from emp; ... -
modify ip
2012-02-10 17:45 7491.netconfig 2./etc/sysconfig/n ... -
MULTI dbwr or io slaves
2012-02-10 15:21 841thanks dukope of itpub. ... -
FAQS
2012-02-09 15:59 7061.How can I get the largest amo ... -
HOW TO STUDY ORACLE FROM Yong Huang
2012-01-18 14:48 760Assuming you want to study orac ... -
RMAN
2012-01-14 17:07 6501.components of the rman ... -
INSTANCE and CRASH RECOVERY
2012-01-12 10:12 7101.type of checkpoint full c ... -
STARTUP PFILE=
2011-12-31 14:11 11161.vi initdbs.ora spfile=&quo ... -
MANAGE TABLE
2011-12-26 16:50 5321.heap table IOT PARTI ... -
MONITOR redo size
2011-12-21 17:48 6121.set autot on stat 2.unsin ... -
What do rollback and commit
2011-12-21 11:21 701When we COMMIT, all that is lef ... -
What is the schema ?
2011-12-20 15:18 556A schema is a collection of dat ... -
DBA SQL
2011-12-19 15:21 4101.select a.name,b.status from v ... -
SEGMENT EXTENTS ORACLEBLOCK
2011-12-15 16:11 7551.SEGMENT: allocated fo ... -
MANAGE TABLESPACE AND DATAFILES
2011-12-13 15:28 5361. tablespace,segment,extent,bl ... -
ORACLE NET
2011-12-12 09:49 6541.net_service_name: servive ... -
SQLPLUS TIPS
2011-12-09 17:51 8671.SQLPLUS : a tool that execute ... -
ORACLE ENVIRONMENT VARIABLES
2011-12-09 17:15 623ORACLE_HOME ORACLE_SID : or ... -
Exam Test1
2011-12-09 16:18 6071.utl_file_dir: indicate the di ...
相关推荐
ManageEngine EventLogAnalyzer 12.04 license文件,亲测可用。
ManageEngine Eventlog Analyzer是用来分析和审计系统及事件日志的管理软件,能够对全网范围内的主机、服务器、网络设备、数据库以及各种应用服务系统等产生的日志,进行全面收集和细致分析,通过统一的控制台进行...
ManageEngine Desktop Central 10 License 实测可用。
ManageEngine Applications Manager 7.0 crack file
ManageEngine-EventLog-Analyzer-12.0.5 软件,
ManageEngine ADManager Plus 是一款简单易用的 Windows Active Directory 管理和报表的解决方案,可以帮助AD 管理员和帮助台技术人员在日常管理中提高效率。利用直观的网站界面,这款软件可以处理各种复杂任务,...
解决双击我的电脑出现计算机管理或者 manage
此Ontrack Disk Manage 10.46.06 光盘是我从网上搜集到的,经测试好用.使用的时候,如出现输入提示符号,请输入DM再按确定键则可.我已将此光盘传到115网盘,有需要者可到http://u.115.com/file/dns2dtzw# Ontrack_Disk_...
SolidWorks PDM/Manage2023 安装指南,适用于新人进行安装学习使用。安装包含SQL SERVER 安装,请学习者安装教程自行进行下载安装。软件安装包存放于DS SOLIDWORKS 安装包内,下载后即可自行解压使用。
从官网的发行说明上来看,https://www.manageengine.com/products/applications_manager/release-notes.html 12.9是最后12系列版本最后一个。此版本为64位。需要32位的请留言。
ManageEngine_FirewallAnalyzer注册码
ManageEngine-EventLog-Analyzer-12.0.5-Build12050安装包 ,500个节点。
SOLIDWORKS manage 2021 基础配置 教程
manage it your guide 管理指南
AdventNet ManageEngine ApplicationManager Enterprise v12.1.0 算是比较新的版本了.
针对snmp协议的利用工具,实现针对snmp数据包的构造,分析,发送等功能。支持v1 v2c v3等。
ADAudit Plus是由ManageEngine(卓豪)官方出品的一款IT运维管理解决方案。在企业中为了方便处理日常事务,管理员需要给帮助台、支持人员、人力资源和其它用户指派相应的管理权限,如用户管理、组管理、计算机管理等...
适用于SOLIDWORKS PDM 和 2022-SOLIDWORKS Manage 的初学者安装指南。
VMware vSphere: Install, Configure, Manage
soc manage system paper 电池管理 paper