VMCD.ORG

Scripts:xplan_extended_display_cursor

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
— ———————————————————————————————-
—
— Script: xplan_extended_display_cursor.sql
—
— V[……]

Oracle 坏块处理(final)

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[……]

Configuring Temporary Tablespaces for RAC Databases for Optimal Performance

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[……]

Secure External Password Store using wallet

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[……]

分区表中的index 失效及处理

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[……]

11g Oradebug Infrastructure (Internal only)

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[……]

2012

January 1, 2012 system No comments

2012 is coming .happy new year and everything will be better and better[……]

在线重定义一例

December 29, 2011 maintain, oracle 1 comment structure

创建需要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([……]

How to create very big index

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[……]