测试AIX从linux导入数据时 Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS阶段停留了很久：
ORA-39082: Object type ALTER_PROCEDURE:”USER_DA[……]
May 31, 2012 maintain, oracle 2 comments
测试AIX从linux导入数据时 Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS阶段停留了很久：
ORA-39082: Object type ALTER_PROCEDURE:”USER_DA[……]
May 14, 2012 maintain, oracle No comments
/* ************************************************************* */
/* Index Fragmentation Status (idsfrag.sql): */
/*[……]
April 26, 2012 maintain, oracle, RAC No comments 11g new feature, 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[……]
March 8, 2012 11g, maintain, oracle 1 comment 11g new feature
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[……]
昨天看了roger的一篇文章，如何在创建index 之前估算它的大小，这里有一种更简单的方法实现：
主要思路就是采用了dbms_space.create_index_cost这个包
–create a testing table named t
SQL> create tabl[……]
March 2, 2012 maintain, oracle No comments scripts
This script is monitoring sessions that are not commited :
— |—————————————————————————-|[……]
February 23, 2012 maintain, oracle No comments 11g
从10.2.0.5的库导入一张表的增量数据到11.2.0.3 impdp报出如下错误,对比两边表结构一致，tablespace有剩余空间 报错如下：
[oracle@localhost ~]$ impdp \’\/ as sysdba \’ directory=pump dum[……]
January 16, 2012 maintain, oracle No comments scripts
修改过的show_space 支持ASSM
create or replace
procedure show_space
( p_segname_1 in varchar2,
p_space in varchar2 def[……]
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
— ———-[……]
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 relativ[……]