OracleDBA面對全新工作環境應該了解什么

 SELECT * FROM v$version; 

 SELECT * FROM dba_registry_database; 

 SELECT dbid, name, open_mode, database_role, platform_name FROM v$instance; 

 SELECT dbms_utility.port_string FROM dual; 

 ver VARCHAR2(100); 

 compat VARCHAR2(100); 

 dbms_utility.db_version(ver, compat); 

 dbms_output.put_line('Version: ' || ver ||' Compatible: ' || compat); 

SELECT * FROM dba_registry 

 inst_tab dbms_utility.instance_table; 

 inst_cnt NUMBER; 

 IF dbms_utility.is_cluster_database then 

 dbms_utility.active_instances(inst_tab, inst_cnt); 

 dbms_output.put_line('-' || inst_tab.FIRST); 

 dbms_output.put_line(TO_CHAR(inst_cnt)); 

 else 

 dbms_output.put_line('Not A Clustered Database'); 

 end IF; 

 SELECT protection_mode, protection_level, remote_archive, 

 database_role, dataguard_broker,guard_status 

 conn / AS sysdba 

 archive log list; 

 SELECT log_mode FROM v$database; 

 SELECT flashback_on FROM v$database; 

 SELECT force_logging,supplemental_log_data_min, supplemental_log_data_pk, 

 supplemental_log_data_ui,supplemental_log_data_fk, supplemental_log_data_all 

 SELECT * FROM v$controlfile; 

 SELECT l.GROUP#, lf.type, lf.member, l.bytes, l.status LOG_STATUS, 

 lf.STATUS LOGFILE_STATUS 

 FROM v$log l, v$logfile lf 

 WHERE l.GROUP# = lf.group# 

 ORDER BY 1,3; 

 SHOW parameter spfile 

 CREATE spfile FROM pfile... 

 CREATE pfile FROM spfile; 

 CREATE spfile FROM memory; 

 CREATE pfile FROM memory; --記得這個好像是11g才有的語法吧 

 SELECT instance_name, host_name, STATUS, archiver, 

 database_status, instance_role, active_state 

 FROM v$instance; 

 SELECT name, value FROM gv$parameter WHERE name = 'resource_limit'; 

 SELECT profile, resource_name, LIMIT FROM dba_profiles ORDER BY 1,2; 

 SELECT username, profile FROM dba_users WHERE account_status='OPEN' ORDER BY 1; 

 SELECT d.username, u.account_status 

 FROM dba_users_with_defpwd d, dba_users u 

 WHERE d.username = u.username AND account_status = 'OPEN' 

 ORDER BY 2,1; 

 SELECT filename, STATUS, bytes FROM v$block_change_tracking; 

 SELECT * FROM database_properties; 

 SELECT owner, object_type, COUNT(*) 

 FROM dba_objects 

 WHERE STATUS = 'INVALID' 

 GROUP BY owner, object_type;