NOLOGGING is supported in only a subset of the locations that support LOGGING. Only the following operations support the NOLOGGING mode:
DML:
1. Direct-path INSERT (serial or parallel) resulting either from an INSERT or a
MERGE statement. NOLOGGING is not applicable to any UPDATE operations
resu[……]
Logic standby delay when query with for update clause
今天遇到一个奇怪的问题，3个logic standby 中有一个delay 查看任何日志都没有发现错误，有一个transaction在apply一个SQL，这条SQL没有任何问题，SQL所涉及到的表也没有任何问题
当时的apply情况如下：
SID USERNAME MACHINE EVENT PARAM W WT SQL ST LT LOGON_TIME
—— ———- —[……]
Scripts:xplan_extended_display_cursor
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)
收到开发人员报告，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
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
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 失效及处理
分区表中 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)
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
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([……]