摘要：
文章来自：互联网答案本人愚见 1. How many memory layers are in the shared pool？ Answer：1 1.libary cache 2.dictionary cache2 libary cache contain 1.shared sql area 2.private sql area 3.pl/sql procedure and package 4.control structure2. How do you find out from the RMAN catalog if a particular archive log has bee... 阅读全文
摘要：
文章转自：http://czmmiao.iteye.com/blog/1292412database 概况信息检查 # 检查 database 基本信息 1 select * from v$version; 2 select name ,open_mode,log_mode from v$database; 3 select instance_number,instance_name ,status from gv$instance; 4 show parameter cpu_count 5 show parameter block_size 6 select group#,thr... 阅读全文