ITPub博客

使用Oracle Database 11g可以创建新类型的Interval分区表，Interval类型分区表，可以根据加载数据，自动创建指定间隔的分区。比如创建按月分区的分区表：create table sales  (  sales_id    number,  sales_dt    date  )  partition by range (sales_dt...

Read-Only Tables in Oracle Database 11g Release 1In previous Oracle releases, tables could be made to appear read-only to other users by only granting the SELECT object privilege to them, but the tables remained read-write for the owner. Oracle 11g allows tables to be marked as read-onl...

在官网看到了这段信息，讲的很细。 贴过来。 Logical Storage Structureshttp://download.oracle.com/docs/cd/E11882_01/server.112/e16508/logical.htm#CNCPT7668         Oracle Database manages the logical storage space in the data files ...

目录(?)[-]一Data Recovery AdvisorDRA 说明DRA 说明自动诊断工作流RMAN中使用DRA 步骤列出数据故障修复建议执行修复分类和关闭故障DRA相关的视图预防性检查...

SQL> connect / as sysdbaConnected.SQL> alter system set memory_target=0;System altered.SQL> alter system set memory_max_target=0;alter system set memory_max_target=0                *ERROR at line 1:ORA-02095: ...

Oracle数据库一致性读的原理

GGSCI (mail) 9> info allProgram     Status      Group       Lag at Chkpt  Time Since ChkptMANAGER     RUNNING              &n...

GGSCI (mail.cnkint.com) 8> add checkpointtable ogg.checkpoint;ERROR: OCI Error ORA-00911: invalid character (status = 911). Creating checkpoint table ogg.checkpoint;, SQL <CREATE TABLE ogg.checkpoint; (  group_name VARCHAR2(8) NOT NULL,  group_key NUMBER(19) NOT NULL,  seqno NUMBER(1...

Oracle 11g 之前默认的用户时是没有密码过期的限制的，在Oracle 11g 中默认的profile启用了密码过期时间是180天经常会遇到使用sqlplus登陆oracle数据库时提示“ORA-28002: 7天之后口令将过期”等情况。，如果超过180天用户密码未做修改则该用户无法登录，提示“ORA-2800Oracle 11g 之前默认的用户时是没有密码过期...

INFO: Linking 'Enterprise Edition Options 11.2.0.4.0 'INFO: Linking 'Enterprise Edition Options 11.2.0.4.0 'INFO: 7/5/14 11:28:43 PM CST: Starting install Link Phase of component Enterprise Edition OptionsINFO: Linking 'Oracle Database 11g 11.2.0.4.0 'INFO: Linking 'Oracle Database 11g 11.2.0.4....

在oracle11g中，数据库的审计功能是默认开启的（这和oracle10g的不一样，10g默认是关闭的），oracle11gR2的官方文档上写的是错的，当上说default是none，而且是审计到DB级别的，这样就会往aud$表里记录统计信息。 问题处理方法：1.如果审计不是必须的，可以关掉审计功能；SQL> alter system set aud...

All installer requirements met.Preparing to launch Oracle Universal Installer from /tmp/OraInstall2014-06-11_09-27-20AM. Please wait ...[oracle@vmac1 clusterware]$ Oracle Universal Installer, Version 10.2.0.1.0 ProductionCopyright (C) 1999, 2005, Oracle. All rights reserved.Exception java.lang....

[oracle@vmac1 ~]$  /g01/app/grid/product/11.2.0/bin/srvctl  add database -d racdb -o /s01/app/oracle/product/11.2.0 -c RACPRCS-1007 : Server pool racdb already existsPRCR-1086 : server pool ora.racdb is already registered[root@vmac1 ~]# /g01/app/grid/product/11.2.0/bin/crsctl delete s...

查看当前表决磁盘文件列表[grid@vmac1 ~]$ crsctl query css votedisk##  STATE    File Universal Id                File Name Disk group--  -----    -----------------   &n...

SQL>  create diskgroup OCR_DG normal redundancy   2  failgroup OCR_DG_001 disk '/dev/asm-diskg'  3  failgroup OCR_DG_002  disk '/dev/asm-diskh'   4  REGULAR failgroup  OCR_DG_003 disk '/dev/asm-diski'; create diskgroup OCR_DG normal redundancy*...

之前记录了10g RAC的手工关闭和启动，现在经常接触的11g R2的RAC，因为版本差别很大，所以关闭的方式区别也大，具体是11g RAC更简单了。先转一段具体描述：在Oracle 11gR2 下的RAC，架构发生了变化。CRS的信息也是放在ASM 实例里的，所以要关asm必须关闭crs。如果还使用了acfs的话，一关crs那么acfs里的信息也...

SYS@ hanmi> r  1  SELECT /*+ rule*/  2  a.sid, b.owner, object_name, object_type  3  FROM v$lock a, all_objects b  4  WHERE TYPE = 'TM'  5* and a.id1 = b.object_id       SID OWNER      &nb...

参考:  http://www.itpub.net/thread-1761414-1-1.html   http://blog.itpub.net/7199859/viewspace-700920

想起来上次面试的时候那个面试官问我“你对优化方面了解多少”“ORACLE优化还是SQL优化”“SQL优化”“这个……不知道从何说起”“呵呵，那我问你问题好了，问问就知道你大概什么水平了”“呵呵，好吧”……结果好像不太理想，虽然最终还是拿到OFFER了，呵呵...

HMBARCODE@ hanmi> SELECT DBMS_METADATA.GET_DDL('TABLE','T_PMAX','HMBARCODE') FROM DUAL;DBMS_METADATA.GET_DDL('TABLE','T_PMAX','HMBARCODE')--------------------------------------------------------------------------------  CREATE TABLE "HMBARCODE"."T_PMAX"   (    "...