Use the following scripts to validate your database:
Script | Description |
---|---|
SGA (Memory) Validation | Requires 8 GB for larger systems. Script: SQL> SELECT * FROM v$sgainfo; SQL> show sga |
Check archive log mode | For ERDB, the database should be in non-archive mode. Script: SQL> SELECT log_mode FROM v$database; |
Processes Init Parameter | Requires a minimum of 300. Script: SQL> show parameter process |
Temp Tablespace Validation | Requires a minimum of 2 files with file size set at the OS maximum, typically 32 GB. Larger systems should have 3 files for the temp tablespace. Script: SQL> select TABLESPACE_NAME, FILE_ID, BYTES_USED, BYTES_FREE from V$TEMP_SPACE_HEADER; |
UNDO Tablespace Validation | Set the datafile to be autoextensible. Set the maxbytes to the OS maximum, typically 32 GB. Requires a minimum of 2 files; 3 to 5 files for larger systems. Script: SQL> select s.tablespace_name, f.file_name, f.maxbytes, f.autoextensible from dba_data_files f inner join dba_tablespaces s on s.tablespace_name = f.tablespace_name where s.tablespace_name like '%UNDO%'; |
Tablespaces for ODS | Set the datafile to be autoextensible. Set the maxbytes to the OS maximum, typically 32 GB. Requires a minimum of 2 files; 3 to 5 files for larger systems. Script: SQL> select s.tablespace_name, f.file_name, f.maxbytes, f.autoextensible from dba_data_files f inner join dba_tablespaces s on s.tablespace_name = f.tablespace_name where s.tablespace_name like '%ODS%' |
Related Topics |
Legal Notices
Copyright © 1999, 2014,
Oracle and/or its affiliates. All rights reserved.
Last Published Friday, January 31, 2014