- Create the owner and assign the required privileges as shown below. Execute the following statement, where DBUSER is the name of the user to create, and tsname is the tablespace for UIM.
- Panacea for an Oracle Applications Database Administrator with Real Application Cluster and Data Guard.
DBA-Village contains news, tips, scripts and much more information for Oracle Database Administrators.
| Column | Datatype | Description |
|---|---|---|
USN | NUMBER | Rollback segment number |
LATCH | NUMBER | Latch for the rollback segment |
EXTENTS | NUMBER | Number of extents in the rollback segment |
RSSIZE | NUMBER | Size (in bytes) of the rollback segment. This value differs by the number of bytes in one database block from the value of the BYTES column of the *_SEGMENTS view.See Also:Oracle Database Administrator's Guide |
WRITES | NUMBER | Number of bytes written to the rollback segment |
XACTS | NUMBER | Number of active transactions |
GETS | NUMBER | Number of header gets |
WAITS | NUMBER | Number of header waits |
OPTSIZE | NUMBER | Optimal size of the rollback segment |
HWMSIZE | NUMBER | High-watermark of the rollback segment size |
SHRINKS | NUMBER | Number of times the size of a rollback segment decreases |
WRAPS | NUMBER | Number of times rollback segment is wrapped |
EXTENDS | NUMBER | Number of times rollback segment size is extended |
AVESHRINK | NUMBER | Average shrink size |
AVEACTIVE | NUMBER | Current size of active extents, averaged over time. |
STATUS | VARCHAR2(15) | Rollback segment status:
|
CUREXT | NUMBER | Current extent |
CURBLK | NUMBER | Current block |
V$rollstat
| 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 | ||
Rollstate
| Key field |
| Non-key field |