Cloning an Oracle Home
Cloning an Oracle home involves creating a copy of the Oracle home and then configuring it for a new environment. If you are performing multiple Oracle Database installations, then you may want to use this method to create each Oracle home, because copying files fro[……]
This script is monitoring sessions that are not commited :
— |—————————————————————————-|
— | Copyright (c) 1998-2012 Jeffrey M. Hunter. All rights reserved. |
— |————————————————————–[……]
Rebootless Node Fencing
In versions before 11.2.0.2 Oracle Clusterware tried to prevent a split-brain with a fast reboot (better: reset) of the server(s) without waiting for ongoing I/O operations or synchronization of the file systems. This mechanism has been changed in version 11.2.0.2 (fi[……]
昨天看了roger的一篇文章，如何在创建index 之前估算它的大小，这里有一种更简单的方法实现：
主要思路就是采用了dbms_space.create_index_cost这个包
–create a testing table named t
SQL> create table t as select * from dba_objects;
Table created.
SQL> declare
begin
for i in 1..10 loop
insert /*+ APPEND */ into t select * from t;
commit;[……]
Create a database link with the new host:port/service syntax
Submitted by tanelpoder on Mon, 2012-03-05 15:57
Share
I just noticed that (finally) in 11.2 this syntax is supported:
SQL> CREATE DATABASE LINK demo_x2
2 CONNECT TO tanel IDENTIFIED BY password
3 USING ‘exadb03:1521/DEM[……]
昨天的logic standby 事故处理：
夜里12点左右 2台logic standby 全部停止日志apply 查看logic standby 相关进程发现:
1.select spid, type, status from v$logstdby_process no rows returns
2.2012-03-12 23:36:16 update “PROD_DATA2″.”PM_SUPPLIER” set xxx…..
ORA-01403: no data found
报出如下错误，这种错误一般是由于standby 端的表数据与[……]
11g Release 2 RMAN Backup Compression
Oracle 11g Release 2 introduced compression algorithm levels which can be used for compressing table data, Data Pump exports and RMAN backups as well.
The compression levels are BASIC, LOW, MEDIUM and HIGH and each affords a trade off related to backup throu[……]
该script 显示各个cursor占用的heap大小
——————————————————————————–
—
— File name: curheaps.sql
— Purpose: Show main cursor data block heap sizes and their contents
— (heap0 and heap6)
—
— Author: Tanel Poder
— C[……]
基于windows 2008平台升级rac 11.2.0.2.0->11.2.0.3.0
OS环境windows 2008 x64 数据库环境oracle 11g rac ,version 11.2.0.2.0 64bit
SQL> conn / as sysdba
已连接。
SQL> select * from v$version;
BANNER
——————————————————————————–
Oracle Database 11g Enterpris[……]
Limitations of DRIVING_SITE Hint
Applies to:
Oracle Server – Enterprise Edition – Version: 9.2.0.1 to 11.2.0.2
This problem can occur on any platform.
Symptoms
For optimization of distributed queries Oracle provides the DRIVING_SITE hint.
The Oracle? Database Administrator’s G[……]
