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 relative dba: 0x01d57a0c (file 7, block 1407500)
Fractured block found during crash/instance recovery
Data in bad block:
type: 6 format: 2 rdba: 0x01d57a0[……]
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 Document
Purpose
Scope and Application
Configuring Temporary Tablespaces for RAC Databases for Optimal Performance
References
Applies t[……]
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 have alot of jobs that log into our Oracle
databases. Some of them use ops$oracle accounts. In the future we are not
allowed to use ops$oracle and need[……]
January 4, 2012 maintain, oracle No comments structure
分区表中 local 索引的维护会在oracle 操作表分区的时候自动进行，需要注意的是global 索引，当global索引所在表执行alter table 涉及下列操作时，会导至该索引失效，需要重新建立：
———————————————————————-
一、测试环境
[oracle@testdb ~]$ sqlplus ‘/as sysdba’
SQL*Plus: Release 11.2.0.2.0 Production on Wed Jan[……]
January 2, 2012 11g, Internals, oracle No comments oradebug
11g Oracle 加强了oradebug 可以使用oradebug doc命令查看internal trace command,下面简述各种命令的输出，由于是undocumented,所以很多东西有待研究
Contents
ORADEBUG DOC
ORADEBUG DOC EVENT
ORADEBUG DOC EVENT NAME
ORADEBUG DOC EVENT NAME
ORADEBUG DOC EVENT SCOPE
ORADEBUG DOC EVENT SCOPE SQL
ORADEBUG DOC EVENT FILTER
ORADEBUG D[……]
January 1, 2012 system No comments
2012 is coming .happy new year and everything will be better and better[……]
创建需要redefinition的表,结构同源表
— Create table
create table yhd_so_temp
(id NUMBER(18) not null,
end_user_id NUMBER(18),
order_amount NUMBER(11,2),
order_code CHAR(12),
order_status NUMBER([……]
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 the index as a globally partitioned index, with one partition defined to contain all values of interest and another partition defined to contain the vas[……]
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 on Wed Dec 28 11:23:14 2011
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Relea[……]
看到一篇不错的文章 转载下
Nuno Souto (Noons) also asked a really interesting question on my Differences between Unique and Non-Unique Indexes blog entry (comment 4) that I thought it worthy of a separate blog entry to do the answer justice. The question was:
“Isn’t it still the case that unique indexe[……]