Louis workspace – Page 22

分区表中的index 失效及处理

Updated on December 22, 2014 by Louis Liu

分区表中 local 索引的维护会在oracle 操作表分区的时候自动进行，需要注意的是global 索引，当global索引所在表执行alter table 涉及下列操作时，会导至该索引失效，需要重新建立：

———————————————————————-

一、测试环境

[oracle@testdb ~]$ sqlplus ‘/as sysdba’

SQL*Plus: Release 11.2.0.2.0 Production on Wed Jan[……]

Secure External Password Store using wallet

Updated on December 22, 2014 by Louis Liu

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

Configuring Temporary Tablespaces for RAC Databases for Optimal Performance

Updated on December 22, 2014 by Louis Liu

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

Oracle 坏块处理(final)

Updated on December 22, 2014 by Louis Liu

收到开发人员报告，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[……]

Scripts:xplan_extended_display_cursor

Updated on December 22, 2014 by Louis Liu

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

Logic standby delay when query with for update clause

Updated on December 22, 2014 by Louis Liu

今天遇到一个奇怪的问题，3个logic standby 中有一个delay 查看任何日志都没有发现错误，有一个transaction在apply一个SQL，这条SQL没有任何问题，SQL所涉及到的表也没有任何问题
当时的apply情况如下：

SID USERNAME MACHINE EVENT PARAM W WT SQL ST LT LOGON_TIME
—— ———- —[……]

[转] Know More about Oracle PGA Memory

Updated on December 22, 2014 by Louis Liu

Question :

1. How can we know available PGA and temporary tablespace before we issue a huge operation?
2. Can we estimate PGA and temporary tablespace for a huge operation?
3. As we know, there is limitation for a user process. Can we set unlimited and how to do it?

We say:

PROPOSED SOLUT[……]

Oracle 9i 单节点文件系统升级到 10g RAC

Updated on December 22, 2014 by Louis Liu

最近做了一次Oracle 9i 升级到10g RAC 的测试，现做如下简要记录：
1.查看目前数据库版本

SQL> select * from v$version;

BANNER
—————————————————————-
Oracle9i Enterprise Edition Release 9.2.0.4.0 – Production
PL/SQL Release 9.2.0.4.0 – Production
CORE 9.2.0.3.0 Production[……]

10g Flashback Version Query & Flashback Transaction Query

Updated on December 22, 2014 by Louis Liu

Flashback Version Query:
—————————-

Using undo data stored in the database, one can now view the changes to one or more rows along with all the metadata of the changes. Flashback version query allows the versions of a specific row to be tracked during a window of time using the[……]