![](https://img-blog.csdnimg.cn/20201014180756925.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
技术
文章平均质量分 79
bowshy
只想找到你
展开
-
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 · 1358 阅读 · 0 评论 -
plsql本地编译与解释执行性能差异对比
fibonacci函数测试 create or replace function fib(n number) return number is begin if(n return n; else return fib(n-1)+fib(n-2); end if; end; / 1. 解释执行 SQL> select name ,plsql_code_type from原创 2014-01-14 23:09:20 · 1336 阅读 · 0 评论 -
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 · 630 阅读 · 0 评论 -
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 · 2131 阅读 · 0 评论 -
复合索引建立原则: 列值选择性好的放在最前面
复合索引建立原则: 列值选择性好的放在最前面 所谓列值选择性好,指的是该列中值大部分不一样,只有少部分重复,我们就称之为列值选择性好,如主键,唯一键等. 表CHANNEL_CARD中字段lan_id只有11个不同值,serv_id基本都不同,如果建复合索引时建立为 lan_id,serv_id 与 serv_id,lan_id两种不同顺序,效率是完全不一样的. SQL> set原创 2014-01-02 22:33:31 · 2266 阅读 · 0 评论 -
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 · 2837 阅读 · 0 评论 -
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 · 2732 阅读 · 0 评论 -
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 · 1254 阅读 · 0 评论 -
053-016
16.Because of a logical corruption in your production database, you wanted to perform Tablespace Point in Time Recovery (TSPITR). But before you start the recovery, you queried the TS_PITR_OBJECTS_原创 2013-12-08 22:48:22 · 677 阅读 · 0 评论 -
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 · 1042 阅读 · 0 评论 -
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 · 666 阅读 · 0 评论 -
只对部分行建立索引
只对部分行建立索引 创建大表: 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 · 825 阅读 · 0 评论 -
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 · 2269 阅读 · 0 评论