https://blog.csdn.net/web_guszh-cnhttps://blog.csdn.net/https://blog.csdn.net/web_gus/article/details/52300950https://blog.csdn.net/web_gus/article/details/52300950web_gusWed, 24 Aug 2016 15:34:36 +0800https://blog.csdn.net/web_gus/article/details/52242605https://blog.csdn.net/web_gus/article/details/52242605web_gusThu, 18 Aug 2016 16:55:56 +0800https://blog.csdn.net/web_gus/article/details/52238677https://blog.csdn.net/web_gus/article/details/52238677web_gusThu, 18 Aug 2016 10:49:14 +0800https://blog.csdn.net/web_gus/article/details/52216957https://blog.csdn.net/web_gus/article/details/52216957web_gusTue, 16 Aug 2016 09:16:28 +0800https://blog.csdn.net/web_gus/article/details/52163913https://blog.csdn.net/web_gus/article/details/52163913web_gusTue, 09 Aug 2016 16:32:36 +0800https://blog.csdn.net/web_gus/article/details/51957046https://blog.csdn.net/web_gus/article/details/51957046web_gusTue, 19 Jul 2016 16:28:31 +0800https://blog.csdn.net/web_gus/article/details/51910642https://blog.csdn.net/web_gus/article/details/51910642web_gusThu, 14 Jul 2016 16:39:03 +0800https://blog.csdn.net/web_gus/article/details/50462550https://blog.csdn.net/web_gus/article/details/50462550web_gusWed, 13 Jul 2016 09:54:03 +0800https://blog.csdn.net/web_gus/article/details/42739813https://blog.csdn.net/web_gus/article/details/42739813web_gusThu, 15 Jan 2015 12:54:42 +0800https://blog.csdn.net/web_gus/article/details/38487959https://blog.csdn.net/web_gus/article/details/38487959web_gusMon, 11 Aug 2014 10:14:40 +0800https://blog.csdn.net/web_gus/article/details/6303281https://blog.csdn.net/web_gus/article/details/6303281web_gusTue, 05 Apr 2011 19:55:00 +0800rman 保留窗 自动删除obsolute
rman 增量备份   trace文件
log_archive_local_first 加快本地归档
db_block_checksum db_block_checking
rman 检查数据损坏]]>https://blog.csdn.net/web_gus/article/details/6256796https://blog.csdn.net/web_gus/article/details/6256796web_gusThu, 17 Mar 2011 16:55:00 +0800暂停数据库的几种模式：
alter system enable restricted session;alter system disable restricted session;
alter system quiesce restricted;alter system unquiesce;
alter system suspend;alter system resume;

分区和并行执行
alter sessi]]>https://blog.csdn.net/web_gus/article/details/6254268https://blog.csdn.net/web_gus/article/details/6254268web_gusWed, 16 Mar 2011 17:50:00 +0800闪回版本查询 select rate, versions_starttime, versions_endtime from rates versions between timestamp to_date('12/1/2003 15:57:54','mm/dd/yyyy hh24:mi:ss') and to_date('12/1/2003 16:57:55','mm/dd/yyyy hh24:mi:ss')

回滚监视 v$session_longops(elapsed]]>https://blog.csdn.net/web_gus/article/details/6219111https://blog.csdn.net/web_gus/article/details/6219111web_gusWed, 02 Mar 2011 20:58:00 +0800从系统的listener.log日志中可以查询]]>https://blog.csdn.net/web_gus/article/details/6206870https://blog.csdn.net/web_gus/article/details/6206870web_gusFri, 25 Feb 2011 10:14:00 +0800用sqlplus连接oracle需要确定环境变量ORACLE_SID,否则连到的是另一个实例]]>https://blog.csdn.net/web_gus/article/details/6195948https://blog.csdn.net/web_gus/article/details/6195948web_gusSun, 20 Feb 2011 10:47:00 +0800tuning:memory io cpu
vmstat iostat top sar
para:lock_sga
cpu busy rate:90% ,os/usr 40/60
monitor usage]]>https://blog.csdn.net/web_gus/article/details/6195944https://blog.csdn.net/web_gus/article/details/6195944web_gusSun, 20 Feb 2011 10:46:00 +0800modes of locking:exclusive,share
types of locks:dml,ddl,internal
v$lock type tm:id1 -> table and meterailize log
v$lock type tx:id1 -> high 16 bit =xidusn(v$transaction) low 16 bit = xidslot(v$transaction)
v$lock v$transaction v$s]]>https://blog.csdn.net/web_gus/article/details/6195943https://blog.csdn.net/web_gus/article/details/6195943web_gusSun, 20 Feb 2011 10:45:00 +0800refresh types:complete(delete->insert rowid changed),fast(update,rowid not changed)
dbms_mview refresh
materialized view log: mlog$_xxx
query rewrites para:query_rewrite_enabled,query_rewrite_integrity, query rewrite privilige,hints]]>https://blog.csdn.net/web_gus/article/details/6195938https://blog.csdn.net/web_gus/article/details/6195938web_gusSun, 20 Feb 2011 10:44:00 +0800redefine a table online: dbms_redefinition
compressed index
reverse key index
index organized table:pctthreshold,including,overflow,mapping table]]>https://blog.csdn.net/web_gus/article/details/6195935https://blog.csdn.net/web_gus/article/details/6195935web_gusSun, 20 Feb 2011 10:44:00 +0800types:heap table ,cluster,index organized table,partition table
cluster:index cluster(<> between and),hash cluster(=)
partition:range,hash,list,composite
partition pruning
partition-wise join
ps:range(maxvalue新纪录如何整理，add part]]>