ITPub博客

Controlling Execution Plan Evolution Using SQL Plan Managementhttp://www.oracle.com/technology/obe/11gr1_db/manage/spm/spm.htmparameter: optimizer_capture_sql_plan_baselines[@more@]

Improving Application Performance with Result Cachehttp://www.oracle.com/technology/obe/11gr1_db/perform/rescache/res_cache.htm参考文章http://www.ningoo.net/html/2007/oracle11g_new_feature_server_result_cache.htmlhttp://www.ningoo.net/html/2007/oracle11g_new_feature_server_result_cache2.htmlhttp://www.ningoo.net/html/2007/oracle11g_new_feature_server_result_cache3.html[@more@]共享SQL和执行计划-》共享SQL执行后的结果Server Result Cache通过在SGA中分配一个缓冲区来保存查询结果，Oracle引入了一个新的初

http://www.oracle.com/technology/obe/11gr1_db/manage/spa/spa_guide.htm1. Set up the env, create database objects and loads the dataThen run some sql on the just created dataCreate a SQL Tuning Set for the workload you just ran2. "Guided Workflow"2.1 "Create SQL Performance Analyzer Task based on SQL Tuning Set"2.2 "Replay SQL Tuning Set in initial Env"2.3 Do some change2.4 "Replay SQL Tuning Set in Changed Env"2.5 "Compare"2.6 "View Report&q

http://www.oracle.com/technology/obe/11gr1_db/manage/dbreplay/dbreplay.htm1. Create a directory for the capture2. "Capture Workload"3. Run some scripts immediately to create the workload4. "Capture Workload" -> stop capture, export the AWR data5. "Preprocess Captured Workload"6. "Replay Workload", start the replay client"wrc REPLAYDIR=<capture directory path> USERID=system PASSWORD=<system password>"7. View the Reports[@more@]

http://xsb.itpub.net/post/419/60493http://logzgh.itpub.net/post/3185/25925http://swallow0175.itpub.net/post/21573/243707[@more@]

Backup and RecoveryFlashback[@more@]Backup and Recoveryhttp://www.oracle.com/technology/obe/10gr2_db_single/ha/rman/rman_otn.htmPerform backup1. Configure the flashback recovery tableenable archive mode, enable flashback on, edit the flashback retention timeSQL>shutdown immediate;SQL>startup mount;SQL>alter database archivelog;SQL>alter database flashback onSQL>alter database open;2. Enable block change tracking3. Test disck backup4. Backup the database5. Review backup reports6. E

http://epub.itpub.net/5/1.htm[@more@]Oracle备份与恢复案例By Piner 一. 理解什么是数据库恢复 当我们使用一个数据库时，总希望数据库的内容是可靠的、正确的，但由于计算机系统的故障（硬件故障、软件故障、网络故障、进程故障和系统故障）影响数据库系统的操作，影响数据库中数据的正确性，甚至破坏数据库，使数据库中全部或部分数据丢失。因此当发生上述故障后，希望能重构这个完整的数据库，该处理称为数据库恢复。恢复过程大致可以分为复原(Restore)与恢复(Recover)过程。 数据库恢复可以分为以下两类： 1.1实例故障的一致性恢复