ITPub博客

日志文件维护相关资料见下:http://docs.oracle.com/cd/E11882_01/server.112/e26088/statements_1004.htm#i2135589----添加日志文件组,一个组可包含多个日志文件,且大小内容相同SQL> alter database add log...

---学习并行知识并测试SQL> create table t_parallel(a int,b int);Table created.SQL> set time on11:34:20 SQL> set timing on11:34:25 SQL> insert into t_parallel select level,level from dual connec...

http://docs.oracle.com/cd/E11882_01/server.112/e25513/dynviews_2085.htm http://docs.oracle.com/cd/E11882_01/server.112/e25513/dynviews_3091.htm#REFRN30344

1,压缩的概念    1,仅用于heap-organized表    2,尤其适用于数据仓库,此类情形的insert和update操作很小量    3,在11G测试,压缩表可以EXP和IMP  &n...

  1  create table t_partition(a int,b int)  2  partition by range(a)  3  (partition p1 values less than (10),  4   partition p2 values less than (m...

SQL> create table t_index(a int,b int);Table created. SQL> create index idx_t_index on t_index(a);Index created.  SQL> select index_name,logging,status from user_indexes where t...

   前几日在文章:http://space.itpub.net/9240380/viewspace-751897,为生产某表构建了分区类型及本地分区索引和唯一索引.今天上司通知构建的索引与要求不一致.  -----直接在plsql devel...

http://blog.csdn.net/tianlesoftware/article/details/5664019

exp-00056 ORA-8103 错误解决方法 ----------------------------某客户的一个表在进行分析和建索引一段时间时，均报ORA-8103错误。让我们先看看ORA-8103错误是个什么样的错误？[oracle@xty ~]$ ...

http://docs.oracle.com/cd/E11882_01/server.112/e25513/stats002.htm#i375475

http://hi.baidu.com/shenxueer_7614/item/351536176ffc920a8ebde4bc

http://www.itpub.net/forum.php?mod=viewthread&tid=1475582

http://blog.csdn.net/tianlesoftware/article/details/6700080

http://blog.csdn.net/binhe521/article/details/4509951

http://blog.csdn.net/tianlesoftware/article/details/6670962

http://blog.csdn.net/tianlesoftware/article/details/7734344

http://blog.csdn.net/tianlesoftware/article/details/6573988

http://space.itpub.net/7199859/viewspace-179647

逻辑读的准确定义：9N8F~~` dqITPUB个人空间E~leb 我们都知道,数据块是oracle最基本的读写单位,但用户所需要的数据,并不是整个块,而是块中的行,或列.当用户发出SQL语句时,此语句被解析执行完毕，就开始了...

http://logzgh.itpub.net/post/3185/42513