ITPub博客

View不占存储空间，只在数据字典中存了定义它的sql.  CREATE VIEW a AS SELECT XXXXFROM XXXWHERE XXXWITH CHECK OPTION CONSTRAINT XXX;Check option：对这个视图的insert/update不能产生该视图查询不...

http://tech.sina.com.cn/roll/2007-12-04/1547508948.shtml  

Oracle物化视图：创建最简单物化视图本文来自Svn中文网[www.svn8.com]转发请保留本站地址：http://www.svn8.com/sql/Oracle/2010062338719.html   Oracle物化视图：创建最简单物化视图  物...

使用SQL_TRACE进行数据库诊断（转载）作者：eygle |<SCRIPT. src="http://www.eygle.com/English.js" type=text/javascript.</SCRIPT. English Version 【转载时请以超链接形式标明文章出处和作者信息及本声明】...

    【IT168 技术文档】Oracle的优化器有两种优化方式,即基于规则的优化方式(Rule-Based Optimization，简称为RBO)和基于代价的优化方式(Cost-Based Optimization，简称为CBO)，在Oracle8及以后的版...

 分区的好处：1．可访问性增强，一个坏分区不会影响其他分区2．DDL可针对单个分区3．OLTP系统中可降低对共享资源的集中访问，DML分散在多个段中。4．在数据仓库中，查询性能增强。 一个表或者索引...

Normal 0 7.8 磅 0 2 false false false MicrosoftInternetExplorer4 <style. /* Style. Definitions */ table.MsoNor...

3 indexes and index-organized tables  索引总是建在table or table cluster上，可以减少磁盘i/o，提高数据访问速度。如果一个heap-organized表没有索引，那么查数据就一定会全表扫描。  如下情况可...

Normal 0 7.8 磅 0 2 false false false MicrosoftInternetExplorer4 <style. /* Style. Definitions */ table.MsoNor...

http://download.oracle.com/docs/cd/E11882_01/server.112/e16508/toc.htm介绍Schema: 一组逻辑数据结构，和一个user name同名，被它拥有。table：描述一个entity。index:提高数据retrieval性能。transaction...

http://download.oracle.com/docs/cd/E11882_01/server.112/e16508/toc.htm[@more@] Normal 0 7.8 磅 0 2 false false false MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:普通表格; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-mar

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实例故障的一致性恢复