The Size of the Data Base For 172.26.58.
101
Oracle is Present on this Server
Get redo log member info:
We can see here that how may redo log member present in the server with status and size :
Get DDL of all tablespaces (Data Definitions Language):
CREATE TABLESPACE "SYSTEM" DATAFILE
'/u01/app/oracle/oradata/ORCL/system01.dbf' SIZE 524288000
AUTOEXTEND ON NEXT 10485760 MAXSIZE 32767M
LOGGING FORCE LOGGING ONLINE PERMANENT BLOCKSIZE 8192
EXTENT MANAGEMENT LOCAL AUTOALLOCATE DEFAULT
NOCOMPRESS SEGMENT SPACE MANAGEMENT MANUAL
ALTER DATABASE DATAFILE
'/u01/app/oracle/oradata/ORCL/system01.dbf' RESIZE 1174405120
CREATE TABLESPACE "SYSAUX" DATAFILE
'/u01/app/oracle/oradata/ORCL/sysaux01.dbf' SIZE 419430400
AUTOEXTEND ON NEXT 10485760 MAXSIZE 32767M
LOGGING FORCE LOGGING ONLINE PERMANENT BLOCKSIZE 8192
EXTENT MANAGEMENT LOCAL AUTOALLOCATE DEFAULT
NOCOMPRESS SEGMENT SPACE MANAGEMENT AUTO
ALTER DATABASE DATAFILE
'/u01/app/oracle/oradata/ORCL/sysaux01.dbf' RESIZE 5064622080
CREATE UNDO TABLESPACE "UNDOTBS1" DATAFILE
'/u01/app/oracle/oradata/ORCL/undotbs01.dbf' SIZE 26214400
AUTOEXTEND ON NEXT 5242880 MAXSIZE 32767M
BLOCKSIZE 8192
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
ALTER DATABASE DATAFILE
'/u01/app/oracle/oradata/ORCL/undotbs01.dbf' RESIZE 33879490560
CREATE TEMPORARY TABLESPACE "TEMP" TEMPFILE
'/u01/app/oracle/oradata/ORCL/temp01.dbf' SIZE 7171211264
AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1048576
CREATE TABLESPACE "USERS" DATAFILE
'/u01/app/oracle/oradata/ORCL/users01.dbf' SIZE 5242880
AUTOEXTEND ON NEXT 1310720 MAXSIZE 32767M
LOGGING ONLINE PERMANENT BLOCKSIZE 8192
EXTENT MANAGEMENT LOCAL AUTOALLOCATE DEFAULT
NOCOMPRESS SEGMENT SPACE MANAGEMENT AUTO
CREATE BIGFILE TABLESPACE "MAGE_DATA" DATAFILE
'/vilmage/datafiles/mage_data.dbf' SIZE 1048576000
AUTOEXTEND ON NEXT 1048576000 MAXSIZE 512000M
LOGGING ONLINE PERMANENT BLOCKSIZE 8192
EXTENT MANAGEMENT LOCAL AUTOALLOCATE DEFAULT
NOCOMPRESS SEGMENT SPACE MANAGEMENT AUTO
ALTER DATABASE DATAFILE
'/vilmage/datafiles/mage_data.dbf' RESIZE 15728640000
CREATE BIGFILE TABLESPACE "MAGE_INDX" DATAFILE
'/vilmage/datafiles/mage_indx.dbf' SIZE 1048576000
AUTOEXTEND ON NEXT 1048576000 MAXSIZE 102400M
LOGGING ONLINE PERMANENT BLOCKSIZE 8192
EXTENT MANAGEMENT LOCAL AUTOALLOCATE DEFAULT
NOCOMPRESS SEGMENT SPACE MANAGEMENT AUTO
ALTER DATABASE DATAFILE
'/vilmage/datafiles/mage_indx.dbf' RESIZE 25165824000
CREATE TABLESPACE "MAGE_ARCH_DATA" DATAFILE
'/vilmage/datafiles/mage_arch_data.dbf' SIZE 104857600
AUTOEXTEND ON NEXT 104857600 MAXSIZE 1048576000
LOGGING ONLINE PERMANENT BLOCKSIZE 8192
EXTENT MANAGEMENT LOCAL AUTOALLOCATE DEFAULT
NOCOMPRESS SEGMENT SPACE MANAGEMENT AUTO
CREATE TABLESPACE "MAGE_ARCH_INDX" DATAFILE
'/vilmage/datafiles/mage_arch_indx.dbf' SIZE 104857600
AUTOEXTEND ON NEXT 104857600 MAXSIZE 1048576000
LOGGING ONLINE PERMANENT BLOCKSIZE 8192
EXTENT MANAGEMENT LOCAL AUTOALLOCATE DEFAULT
NOCOMPRESS SEGMENT SPACE MANAGEMENT AUTO
Cheked installed SQL patches in DB :
set lines 2000
select patch_id,status,description from dba_registry_sqlpatch;
CPU memory info of DB server:
OPatch Vesion :
The Size of the Data Base For 172.26.58.21
Oracle is Present on this Server
Get redo log member info
Checked installed SQL patches in DB :
set lines 2000
select patch_id,status,description from dba_registry_sqlpatch;
CPU memory info of DB server:
