测试AIX从linux导入数据时 Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS阶段停留了很久：
ORA-39082: Object type ALTER_PROCEDURE:”USER_DA[……]
Category: maintain
Scripts: report the index fragmentation status
/* ************************************************************* */
/* Index Fragmentation Status (idsfrag.sql): */
/*[……]
11gR2 rac ora.asm error (ASM)
ASM – ora.asm error
11.2.0.3 RAC CRS 无法启动
[ohasd(25286)]CRS-2112:The OLR service started on node db-41.
2012-04-25 14:46:13.120
[ohas[……]
Create a database link with the new host:port/service syntax
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 (finall[……]
创建index之前如何确定其大小
昨天看了roger的一篇文章，如何在创建index 之前估算它的大小，这里有一种更简单的方法实现：
主要思路就是采用了dbms_space.create_index_cost这个包
–create a testing table named t
SQL> create tabl[……]
Scripts:sess_uncommited_transactions.sql
This script is monitoring sessions that are not commited :
— |—————————————————————————-|[……]
11.2.0.3 datapump got ORA-38500
从10.2.0.5的库导入一张表的增量数据到11.2.0.3 impdp报出如下错误,对比两边表结构一致，tablespace有剩余空间 报错如下：
[oracle@localhost ~]$ impdp \’\/ as sysdba \’ directory=pump dum[……]
Scripts:show_space
修改过的show_space 支持ASSM
create or replace
procedure show_space
( p_segname_1 in varchar2,
p_space in varchar2 def[……]
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
— ———-[……]
Oracle 坏块处理(final)
收到开发人员报告，oracle出现坏块，信息如下：
Hex dump of (file 7, block 1407500) in trace file /data/oracle/admin/orcl/bdump/orcl_p004_7383.trc
Corrupt block relativ[……]