bowshy-CSDN博客

原创 CALIBRATE_IO测试

在oracle 11g及更高版本中,参数 parallel_io_cap 被设置成true,oracle将限制并行度为IO子系统能支持的大小,使用前需先使用过程 dbms_resource_manager.calibrate_io计算出IO子系统的限制.以下为计算IO子系统限制过程:1. 先检查 FILESYSTEMIO_OPTIONS 参数,是否为ASYNCH 或 SETALL,若不,

2014-01-16 00:07:49 2308

原创 plsql本地编译与解释执行性能差异对比

fibonacci函数测试create or replace function fib(n number)return numberisbeginif(nreturn n;elsereturn fib(n-1)+fib(n-2);end if;end;/ 1. 解释执行SQL> select name ,plsql_code_type from

2014-01-14 23:09:20 1371

原创 oracle分析函数之rank学习记录

1. 构造演示数据create table students(id number(5),name varchar2(10),chinese number(3),math number(3),english number(3),class varchar2(10));insert into students(id,name,chinese,math,english,class) values

2014-01-11 23:11:06 657

原创复合索引建立原则: 列值选择性好的放在最前面

复合索引建立原则: 列值选择性好的放在最前面所谓列值选择性好,指的是该列中值大部分不一样,只有少部分重复,我们就称之为列值选择性好,如主键,唯一键等.表CHANNEL_CARD中字段lan_id只有11个不同值,serv_id基本都不同,如果建复合索引时建立为 lan_id,serv_id 与 serv_id,lan_id两种不同顺序,效率是完全不一样的.SQL> set

2014-01-02 22:33:31 2321

原创 RG120A-BB破解说明

朋友给了一个电信装宽带时买的无线猫,看起来很方便,既能当无线路由/器,又能当猫.直接安装到我家却用不起来.折腾了几天,终于在网上找到说明文档,一步步操作下来,终于解决.1. 管理界面http://192.168.1.1/main.htmltelecomadmin / nE7jA%5m2. 配置界面VCI、VPI是DSLAM识别各ATM终端的标志

2013-12-26 21:33:39 2431

原创 053-571

571.Which files are required for a full recovery of the database in ARCHIVELOG mode? (Choose three.) A. Database datafiles B. Online redo logs C. Archived redo logs D. Backup control file E.

2013-12-19 23:11:28 2161

原创 control_file_record_keep_time设置与RMAN保留策略的关系

The default value of CONTROL_FILE_RECORD_KEEP_TIME is 7 days. If you are not using a recovery catalog, then set the CONTROL_FILE_RECORD_KEEP_TIME value to slightly longer than the oldest file that y

2013-12-15 23:55:19 2780

原创 053-704

704. View the Exhibit and examine the data manipulation language (DML) operations that you performed on the NEWEMP table. Note that the first two updated are not listed by the Flashback Versions Que

2013-12-15 22:24:34 2873

原创 053-707

707. Because of a logical corruption in the EMPLOYES tables, you want to perform Tablespace Point-in-Time Recovery (TSPITR) to recover the table. Before you started the TSPITR process, you queried

2013-12-15 22:20:30 1288

原创 053-016

16.Because of a logical corruption in your production database, you wanted to perform Tablespace Pointin Time Recovery (TSPITR). But before you start the recovery, you queried the TS_PITR_OBJECTS_

2013-12-08 22:48:22 717

原创 053-017

17.The INV_HISTORY table is created using the command: SQL>CREATE TABLE INV_HISTORY (inv_no NUMBER(3), inv_date DATE, inv_amt NUMBER(10,2)) partition by range (inv_date) interval (numtoyminte

2013-12-08 22:47:12 1074

原创只对部分行建立索引

只对部分行建立索引创建大表: create table t_big (id int,flag varchar2(5));begin for j in 0..100 loop for i in 0..10000 loop execute immediate 'insert into t_big(id) values(:1) ' using i; end loop;

2013-12-08 22:45:58 851

原创 SQL优化学习建议

1.熟悉执行计划的各种操作，会看懂执行计划 2.熟悉表的数据分布，索引，分区等对执行计划的影响 3.熟悉各种SQL语句的写法，能等价改写各种SQL 4.能够利用业务特点改写和设计SQL 5.能利用ORACLE提供的各种工具，比如sql trace,dbms_xplan,sql tuning advisor,spm等优化sql推荐书籍:1. oracle性能诊断艺术

2013-12-08 22:45:04 705

原创 053-224

224.You need to create a partitioned table to store historical data and you issued the following command:CREATE TABLE purchase_interval PARTITION BY RANGE (time_id) INTERVAL (NUMTOYMINTERVAL(1,'

2013-12-08 22:39:58 1392

学习记录