User Tools

Site Tools


oracle

ORACLE Index

List Tablespaces

select tablespace_name, file_name, bytes, autoextensible from dba_data_files;

Add More Space

alter database datafile '/full/path/to/system01.dbf' autoextend on next 128m maxsize 8192m;
alter tablespace SYSTEM add datafile '/full/path/to/system02.dbf' size 512m;

Check status

select status from v$instance;
select status from v$archive_dest;
list backup;
validate database;

RAC

Resources

crsctl status resource -t

Node Status

crsctl check crs

Cluster Status

crsctl check cluster -all

ASMCMD

$ asmcmd
ASMCMD> help {command}
ASMCMD> ls
ASMCMD> lsdsk
ASMCMD> lsdg
ASMCMD> lsdsk -k
ASMCMD> iostat -t 10
oracle.txt · Last modified: 2017/10/20 09:58 by Jan Forman