A Rollback Segment is a database object containing before-images of data written to the database. Rollback segments are used to: Undo changes when a transaction is rolled back. You can find the largest assortment Indoor Equipment at ERIKS. Choose from more than 500.000 articles and order right away.
DD03M is an SAP View used to store Generated Table for View data. Below is the documentation, technical details of each fields, ABAP code etc. How to tune rolleback segments in an Oracle database. To identify contention for rollback segments first find out the number of times that processes had to wait for the rollback segment header and blocks. Oracle Training from Don Burleson The best on site ' Oracle training classes' are just a phone call away!You can get personalized Oracle training by Donald Burleson, right at your shop!
Field | Data Element | Data Type | length (Decimals) | Check table | Description | Conversion Routine |
TABNAME | TABNAME | CHAR | 30 | DD02L | Table Name | |
FIELDNAME | FIELDNAME | CHAR | 30 | Field Name | ||
FLDSTAT | AS4LOCAL | CHAR | 1 | Activation Status of a Repository Object | ||
ROLLNAME | ROLLNAME | CHAR | 30 | Data element (semantic domain) | ||
ROLLSTAT | AS4LOCAL | CHAR | 1 | Activation Status of a Repository Object | ||
DOMNAME | DOMNAME | CHAR | 30 | Domain name | ||
DOMSTAT | AS4LOCAL | CHAR | 1 | Activation Status of a Repository Object | ||
TEXTSTAT | AS4LOCAL | CHAR | 1 | Activation Status of a Repository Object | ||
DDLANGUAGE | DDLANGUAGE | LANG | 1 | Language Key | ISOLA | |
POSITION | TABFDPOS | NUMC | 4 | Position of the field in the table | ||
KEYFLAG | KEYFLAG | CHAR | 1 | Identifies a key field of a table | ||
MANDATORY | MANDATORY | CHAR | 1 | Flag: Field is required (not blank) | ||
CHECKTABLE | CHECKTABLE | CHAR | 30 | Check table name of the foreign key | ||
ADMINFIELD | ADMINFIELD | CHAR | 1 | Nesting depth for includes | ||
INTTYPE | INTTYPE | CHAR | 1 | ABAP data type (C,D,N,...) | ||
INTLEN | INTLEN | NUMC | 6 | Internal Length in Bytes | ||
REFTABLE | REFTABLE | CHAR | 30 | Table for reference field | ||
PRECFIELD | PRECFIELD | CHAR | 30 | Name of included table | ||
REFFIELD | REFFIELD | CHAR | 30 | Reference field for currency and qty fields | ||
CONROUT | CONROUT | CHAR | 10 | Check or generating module for fields | ||
ROUTPUTLEN | DDLENG | NUMC | 6 | Length (No. of Characters) | ||
MEMORYID | MEMORYID | CHAR | 20 | TPARA | Set/Get parameter ID | |
LOGFLAG | LOGFLAG | CHAR | 1 | Indicator for writing change documents | ||
HEADLEN | HEADLEN | NUMC | 2 | Maximum length of heading | ||
SCRLEN1 | SCRLEN_S | NUMC | 2 | Max. length for short field label | ||
SCRLEN2 | SCRLEN_M | NUMC | 2 | Max. length for medium field label | ||
SCRLEN3 | SCRLEN_L | NUMC | 2 | Max. length for long field label | ||
DTELGLOBAL | GLOBALFLAG | CHAR | 1 | Flag for private DD objects (not used) | ||
DTELMASTER | MASTERLANG | LANG | 1 | Original Language in Repository objects | ISOLA | |
RESERVEDTE | RESERVEDTE | CHAR | 4 | SDIC: Reserve for data elements (not used) | ||
DATATYPE | DATATYPE_D | CHAR | 4 | Data Type in ABAP Dictionary | DTYPE | |
LENG | DDLENG | NUMC | 6 | Length (No. of Characters) | ||
OUTPUTLEN | OUTPUTLEN | NUMC | 6 | Output Length | ||
DECIMALS | DECIMALS | NUMC | 6 | Number of Decimal Places | ||
LOWERCASE | LOWERCASE | CHAR | 1 | Lowercase letters allowed/not allowed | ||
SIGNFLAG | SIGNFLAG | CHAR | 1 | Flag for sign in numerical fields | ||
LANGFLAG | LANGFLAG | CHAR | 1 | Flag for language-dependent values(not used) | ||
VALEXI | VALEXI | CHAR | 1 | Existence of fixed values | ||
ENTITYTAB | ENTITYTAB | CHAR | 30 | DD02L | Value table | |
CONVEXIT | CONVEXIT | CHAR | 5 | Conversion Routine | ||
MASK | AS4MASK | CHAR | 20 | Template (not used) | ||
MASKLEN | MASKLEN | NUMC | 4 | Template length (not used) | ||
ACTFLAG | ACTFLAG | CHAR | 1 | Activation flag | ||
DOMMASTER | MASTERLANG | LANG | 1 | Original Language in Repository objects | ISOLA | |
RESERVEDOM | RESERVEDOM | CHAR | 4 | Reserve for domains (not used) | ||
DOMGLOBAL | GLOBALFLAG | CHAR | 1 | Flag for private DD objects (not used) | ||
DDTEXT | AS4TEXT | CHAR | 60 | Short Description of Repository Objects | ||
REPTEXT | REPTEXT | CHAR | 55 | Heading | ||
SCRTEXT_S | SCRTEXT_S | CHAR | 10 | Short Field Label | ||
SCRTEXT_M | SCRTEXT_M | CHAR | 20 | Medium Field Label | ||
SCRTEXT_L | SCRTEXT_L | CHAR | 40 | Long Field Label |
Key field |
Non-key field |
A Rollback Segment is a database object containing before-images of data written to the database.
Rollback segments are used to:
- Undo changes when a transaction is rolled back
- Ensure other transactions do not see uncommitted changes made to the database
- Recover the database to a consistent state in case of failures
Instead of creating Rollback Segments, users running Oracle 10g or greater should use Undo Segments instead. |
Roll Stats 4d6
Create[edit]
Use the CREATE ROLLBACK SEGMENT command:
When done, edit your INIT.ORA file and add the newly created rollback segment to the ROLLBACK SEGMENTS parameter.
Monitor[edit]
Roll Stats Dnd 5e
A list of rollback segments can be selected from DBA_ROLLBACK_SEGS:
To monitor rollback segment activity, query the v$rollname and v$rollstat/v$undostat views:
Also see[edit]
- System Managed Undo (SMU)
Roll Stats Avrae
Glossary of Terms | ||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | # |