Database Scripts For Validations

Previous TopicNext TopicContents

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 Star

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 '%STAR%';

Related Topics

Checklist for P6 Analytics and the Star Database

Pre-installation for an Oracle Platform

Pre-installation for a Microsoft SQL Server Platform

Pre-installation for Configuring the ETL Server

Pre-installation for the Star Database

Installation: Installer And Configuration

Installation: Running The Processes

Post-installation: After The Processes Complete



Legal Notices
Copyright © 1999, 2014, Oracle and/or its affiliates. All rights reserved.

Last Published Friday, January 31, 2014