Interested Transaction List (ITL) Waits Demystifie
When the other services want access to the row-level locking, it had to search block header contains information
Until you get the lock, the lock is easy to know the information is stored in the block header.
The first piece is placed on the lock information which part of it? It is a simple data structure "ITL",
A rowid contains the Service Address the maintenance of the connection list information. ITL Services includes a number of affairs slot or logo. When a line block in the first lock, the Panel will be a panel bed in which this logo has been locked, and other firms lock when the other block, information will be deposited into the affairs of other pieces of tank .
Rollback or submit recorded Service, the lock was released, the Panel will be to re-use of slots, the queue is a result of some block-level.
Table of affairs is the number of slot parameters from Table MAXTRANS decision. ITL can not create more freedom Affairs shafts or
MAXTRANS values are close to, at this time will result in "equeue" wait event.
 |  |
Related Posts of Interested Transaction List (ITL) Waits Demystifie
-
Oracle HowTo: a die to determine the progress of affairs Recovery
Encountered a problem yesterday, at the opening of the serial SMON is restored, for a die affairs, how to observe the progress of their recovery. Service has been unable to die because of v $ transaction through to observe, so must be carried out to ...
-
Detailed rules Optimize Oracle statement
1. The types of Oracle Optimizer Oracle's Optimizer total of three kinds: a.RULE (rule-based) b.COST (based on cost) c.CHOOSE (optional) Optimize the default settings, you can file through the init.ora parameters OPTIMIZER_MODE various statements ...
-
Oracle Database Exp / Imp tools for performance tuning
Abstract: Oracle Exp / Imp instrument is a simple, convenient and flexible backup and restore data transfer tool, it can implement the entire class library, user-level, table-class data backup and recovery. For the amount of data in class G or G with ...
-
Detailed: database name. Instance name. ORACLE_SID. Database name
Detailed: database name, instance name, ORACLE_SID, database name, global database names, service names and hand the script to create oracle database Database name, instance name, database name, global database names, service names, This is easy for some
-
Database tuning problem (parameter binding, Histogram Analysis)
1, histogram Analysis of depth. . 20080901 ~ 20060101 ~ 99991231 2, the binding parameters The use of different parameters of the different analysis. . . The use of index Scanning the entire table is slightly
-
setting to discuss filing oracle10g
Oracle Database 10g Enterprise Edition Release 10.2.0 .4.0 - Prod PL / SQL Release 10.2.0 .4.0 - Production IXDBA.NET Community Forums CORE 10.2.0 .4.0 Production TNS for Solaris: Version 10.2.0 .4.0 - Production NLSRTL Version 10.2.0 .4.0 - Producti ...
-
LISTENER and EZCONNECT
listener =========================== Listener should be noted that there are two methods Register: Dynamic and Static Registration Registration Registration <br /> dynamic, that is, when the listener configuration, Do not need to configure stat ...
-
Block Oracle paragraph (reprint)
Starting today, begin reading the second oracle document b10743, "conceps"; do not know can give me a new harvest. The master was oracle's Michele Cyran characters written by people such as cow, a really good book. Alas English not well ...
-
An example of the use of TKPROF
First, view and edit parameters SQL> show parameter max_dump_file_size NAME TYPE VALUE ------------------------------------ ----------- --- --------------------------- max_dump_file_size string UNLIMITED SQL> show parameter user_dump_dest NAME TYPE
Leave a Reply