ORACLE数据库管理员的职责

ORACLE数据库管理员的职责(10) init<sid>.ora
controlfile
redo log file
archiving
sort area size
tablespace(system,temporary,tablespace fragment)
datafiles(autoextend,location)
object(number of extent,next extent,index)
rollback segment
logging &tracing(alert.log,max_dump_file_size,sqlnet)
(4). 检查无效的数据库对象
SELECT owner, object_name, object_type FROM dba_objects
WHERE status=’INVALID’。
(5). 检查不起作用的约束
SELECT owner, constraint_name, table_name,
constraint_type, status
FROM dba_constraints
WHERE status = 'DISABLED’ AND constraint_type = 'P'
(6). 检查无效的trigger
SELECT owner, trigger_name, table_name, status
FROM dba_triggers
WHERE status = 'DISABLED’
每月的工作
(1). Analyze Tables/Indexes/Cluster
analyze table <name> estimate statistiCS sample 50 percent;