Alter session set sql_trace=true;
Alter session set STATISTICS_LEVEL = ALL;
set echo off verify off termout off
set doc off
doc
— ———-[……]
January 9, 2012 maintain, oracle No comments scripts
Alter session set sql_trace=true;
Alter session set STATISTICS_LEVEL = ALL;
set echo off verify off termout off
set doc off
doc
— ———-[……]
January 8, 2012 maintain, oracle 2 comments structure
收到开发人员报告，oracle出现坏块，信息如下：
Hex dump of (file 7, block 1407500) in trace file /data/oracle/admin/orcl/bdump/orcl_p004_7383.trc
Corrupt block relativ[……]
January 6, 2012 oracle, RAC No comments RAC
Configuring Temporary Tablespaces for RAC Databases for Optimal Performance
Modified 04-AUG-2010 Type BULLETIN Status ARCHIVED
In this[……]
January 5, 2012 oracle, security No comments Oracle authentication
Oracle Wallet的使用
最近看到一封邮件，该网友提出了如下需求：
This is not exactly an Oracle question, but I am asking it here in case
someone has solved this. We hav[……]
January 4, 2012 maintain, oracle No comments structure
分区表中 local 索引的维护会在oracle 操作表分区的时候自动进行，需要注意的是global 索引，当global索引所在表执行alter table 涉及下列操作时，会导至该索引失效，需要重新建立：
——————————-[……]
January 2, 2012 11g, Internals, oracle No comments oradebug
11g Oracle 加强了oradebug 可以使用oradebug doc命令查看internal trace command,下面简述各种命令的输出，由于是undocumented,所以很多东西有待研究
Contents
ORADEBUG DOC
ORADEBUG DOC E[……]
创建需要redefinition的表,结构同源表
— Create table
create table yhd_so_temp
(id NUMBER(18) not null,
end_user_id[……]
December 29, 2011 11g, maintain, oracle No comments structure
how to create very big index
我们总会碰到各种case 需要建立索引 有些索引大至1T,这些索引的创建是个非常棘手的问题,oracle 11g 在建立partition index时,给出了不错的解决方案
Let’s now re-create th[……]
December 28, 2011 oracle, replication No comments dataguard
table缺少primary key 导致logic standby delay 一例
早上在主库做如下操作：
[oracle@racdg1 ~]$ sqlplus ‘/as sysdba’
SQL*Plus: Release 10.2.0.5.0 – Production o[……]
看到一篇不错的文章 转载下
Nuno Souto (Noons) also asked a really interesting question on my Differences between Unique and Non-Unique Indexes blog entry (c[……]