Database Configuration Summary
Global Database Name: | BASE |
Database Configuration Type: | Single Instance |
SID: | BASE |
Management Option Type: | Database Control |
Storage Type: | File System |
Memory Configuration Type: | Automatic Memory Management |
Database Configuration Details
Database Components
Component | Selected |
---|---|
Oracle JVM | true |
Oracle Text | true |
Oracle XML DB | true |
Oracle Multimedia | true |
Oracle OLAP | true |
Oracle Spatial | true |
Oracle Label Security | true |
Sample Schemas | false |
Enterprise Manager Repository | true |
Oracle Application Express | true |
Oracle Warehouse Builder | true |
Oracle Database Vault | false |
Oracle Database Extensions for .NET | true |
Initialization Parameters
Name | Value |
---|---|
audit_file_dest | {ORACLE_BASE}\admin\{DB_UNIQUE_NAME}\adump |
audit_trail | db |
compatible | 11.2.0.0.0 |
control_files | ("{ORACLE_BASE}\oradata\{DB_UNIQUE_NAME}\control01.ctl", "{ORACLE_BASE}\flash_recovery_area\{DB_UNIQUE_NAME}\control02.ctl") |
db_block_size | 8KB |
db_domain | |
db_name | BASE |
db_recovery_file_dest | {ORACLE_BASE}\flash_recovery_area |
db_recovery_file_dest_size | 4977MB |
diagnostic_dest | {ORACLE_BASE} |
dispatchers | (PROTOCOL=TCP) (SERVICE={SID}XDB) |
memory_target | 503MB |
nls_language | RUSSIAN |
nls_territory | RUSSIA |
open_cursors | 300 |
processes | 150 |
remote_login_passwordfile | EXCLUSIVE |
undo_tablespace | UNDOTBS1 |
Character Sets
Name | Value |
---|---|
Database Character Set | CL8MSWIN1251 |
National Character Set | AL16UTF16 |
Control Files
Name |
---|
{ORACLE_BASE}\oradata\{DB_UNIQUE_NAME}\control01.ctl |
{ORACLE_BASE}\flash_recovery_area\{DB_UNIQUE_NAME}\control02.ctl |
Tablespaces
Name | Type | Extent Management |
---|---|---|
SYSAUX | PERMANENT | LOCAL |
SYSTEM | PERMANENT | LOCAL |
TEMP | TEMPORARY | LOCAL |
UNDOTBS1 | PERMANENT , UNDO | LOCAL |
USERS | PERMANENT | LOCAL |
Data Files
Name | Tablespace | Size(M) |
---|---|---|
{ORACLE_BASE}\oradata\{DB_UNIQUE_NAME}\sysaux01.dbf | SYSAUX | 600 |
{ORACLE_BASE}\oradata\{DB_UNIQUE_NAME}\system01.dbf | SYSTEM | 700 |
{ORACLE_BASE}\oradata\{DB_UNIQUE_NAME}\temp01.dbf | TEMP | 20 |
{ORACLE_BASE}\oradata\{DB_UNIQUE_NAME}\undotbs01.dbf | UNDOTBS1 | 200 |
{ORACLE_BASE}\oradata\{DB_UNIQUE_NAME}\users01.dbf | USERS | 5 |
Redo Log Groups
Group | Size(K) |
---|---|
1 | 51200 |
2 | 51200 |
3 | 51200 |
Комментариев нет:
Отправить комментарий