db_validation
col BYTES/1024/1024/1024 for 9999999999999999;
col AUTOEXTENSIBLE for a10;
col FILE_NAME for a60;
col MAXBYTES for 99999999999999999999;
select FILE_NAME,TABLESPACE_NAME,BYTES/1024/1024/1024,AUTOEXTENSIBLE,MAXBYTES/1024/1024/1024 from dba_temp_files;
select FILE_NAME,TABLESPACE_NAME,BYTES/1024/1024/1024,AUTOEXTENSIBLE,MAXBYTES/1024/1024/1024 from dba_data_files;
show parameter memory_max_target;
show parameter memory_target;
show parameter sga_max_size;
show parameter sga_target;
show parameter pga_aggregate_target;
show parameter optimizer_adaptive_features;
show parameter nls_length_semantics;
SELECT 1 FROM NLS_DATABASE_PARAMETERS DBPARMS, NLS_SESSION_PARAMETERS CURRENTPARMS WHERE
DBPARMS.PARAMETER = 'NLS_CHARACTERSET' AND CURRENTPARMS.PARAMETER = 'NLS_LENGTH_SEMANTICS' AND
((DBPARMS.VALUE IN ('AL32UTF8','UTF8') AND (CURRENTPARMS.VALUE = 'CHAR')) OR (DBPARMS.VALUE NOT
IN ('AL32UTF8','UTF8') AND (CURRENTPARMS.VALUE = 'BYTE')));
show parameter max_string_size;
show parameter db_recovery_file_dest_size;
show parameter Use_large_pages;
COL CLIENT_NAME FORMAT a31;
SELECT CLIENT_NAME, STATUS FROM DBA_AUTOTASK_CLIENT WHERE CLIENT_NAME = 'auto optimizer stats collection';
show parameter processes
show parameter open_cur
col PROPERTY_NAME for a30;
col PROPERTY_VALUE for a30;
col DESCRIPTION for a20;
show parameter db_block_size
select * from database_properties
where PROPERTY_NAME in ('NLS_CHARACTERSET',
'NLS_NCHAR_CHARACTERSET');
show parameter cpu;
show parameter resource_Manager_plan;
select flashback_on from v$database;
select force_logging from v$database;
select dbtimezone from dual;
col COMP_NAME for a40;
col status for a20;
select COMP_NAME,STATUS from dba_registry;
select * from all_db_links;
select * from dba_db_links;
TABLESPACE CREATION:
CREATE BIGFILE TABLESPACE TESTTBS DATAFILE '+DATAC1' SIZE 10M AUTOEXTEND ON NEXT 500M MAXSIZE UNLIMITED;
CREATE BIGFILE UNDO TABLESPACE UNDOTBS3 DATAFILE '+DATAC1' SIZE 200M AUTOEXTEND ON NEXT 500M MAXSIZE 200G;
ALTER SYSTEM SET UNDO_TABLESPACE=UNDOTBS4 SCOPE=BOTH SID='dbname';
DROP TABLESPACE UNDOTBS2 INCLUDING CONTENTS AND DATAFILES;
srvctl setenv database -d CNPMWAFT -t 'TZ=America/Los_Angeles'
