面对一个全新的环境,作为一个Oracle DBA,首先应该了解什么?

eric.youbin

总结的不错

番茄爱蛋汤

不错不错。。。。。。。。

sql_xep

学习之　　谢分享

jinxino_o

帮助很大,非常感谢

duiego

mark

fwei_fengwei

个人感觉在RDA的基础上还需要一下的信息需要收集：

select username,account_status,default_tablespace,temporary_tablespace,profile,to_char(created,'yyyy-mm-dd hh24:mi:ss')
from dba_users order by created;

select * from dba_profiles order by 1;

select job_name,to_char(start_date,'yyyy-mm-dd hh24:mi:ss'),enabled from Dba_Scheduler_Jobs order by 3,2;

select * from v$controlfile_record_section;

col comp_id for a30
col comp_name for a30
col version for a30
col status for a30
select comp_id,comp_name,version,status from dba_registry order by 4;

select * from dba_sys_privs where grantee='<user_name>';
select * from dba_tab_privs where grantee='<user_name>';
select * from dba_role_privs where grantee='<user_name>';

select * from dba_role_privs order by grantee;
select * from role_sys_privs order by role;
select * from role_tab_privs order by role;


conn system -- 测试 system 密码

lixunpeng

把有用的都摘抄啦！

xingfei80

感谢分享，赞！

tianjusanren

好东西，收藏了

myseasky2007

搞清楚这个环境是单机还是集群？
可以查视图，比较简单
SELECT value cluster_database FROM v$parameter WHERE name='cluster_database';