ORACLE 9i-23ai – Page 51

安装gc遭遇oui-25031 web cache configuration assistant faild!

2011-11-16 by weejar zhang

环境linux rhel 5 , grid constol 102011 问题 oui-25031:some of the configuration assistants failed. 窗口确认后发现是web cache configuration assistant faild! 原因 OEM (10.2.0.1) on RHEL5 is not supported please check the certification from metalink 解决%E

ORA-01877: string is too long for internal buffer 排查

2011-11-112011-11-11 by weejar zhang

SQL> select BUILD_DATE,dump(build_date) from jmjk_jilin_th_mhk.ehealth_arch_basicinfo where BUILD_DATe>sysdate
2 ;
ERROR:
ORA-01877: string is too long for internal buffer

where is null 走索引

2011-11-07 by weejar zhang

普通了b树索引是对null不可能走索引的，不讨论cluster table,但是可以通过建立复合索引来使where is null 走索引,

What is “save undo”?

2011-11-04 by weejar zhang

save undo is undo saved for offlined tablespaces. It is also known as deferred rollback

如何看待sql执行计划里的cost

2011-11-03 by weejar zhang

cost 内部记算方法oracle也不会公开，oracle内部用来比较各个执行计划所耗费的代价的值，从而使优化器可以选择最好的执行计划。不同语句的cost值不具有可比性，只能对同一个语句的不同执行计划的cost值进行比较。

trace create user command, who is _next_user?

2011-11-02 by weejar zhang

接着上一篇的问题，再来分析一下用户表,用10046跟踪一下create user

drop tablespace ORA-01561案例

2011-11-02 by weejar zhang

今天遇到了一个奇怪的问题，有一个表空间无法删除，开始删除提示表空间内有对象，加上INCLUDING CONTENTS选项级连删除又报
ORA-01561: failed to remove all objects in the tablespace specified，查一些系统视图该对象还不存在

events errorstack 分析job失败一例

2011-11-01 by weejar zhang

早接到电话说从sqlserver同步过来的数据在oracle 应用没查到，我查询同步job发现失败了，job所调用的procedure 生成了错误编号ORA-02291
procedre中代码较多，决定用errorstack快速定位一下sql

ORA-01461: can bind a LONG value only for insert into a LONG column解决

2011-10-31 by weejar zhang

ERROR at line 1:
ORA-01461: can bind a LONG value only for insert into a LONG column
ORA-06512: at line 4

ORA-01144: File size (4194304 blocks) exceeds maximum of 4194303 blocks

2011-10-27 by weejar zhang

Operating system dependent. Limited by maximum operating system file size; typically 2^22 or 4 MB blocks

ORA-01652: unable to extend temp segment by 8192 in tablespace

2011-10-27 by weejar zhang

今天发现了这个问题，分析记录一下问题是这样子的，有一个表记录7亿，要在表上建索引，临时表空间已分配32G，DB DEFAULT BLOCK SIZE 8K，建索引时报了这个错误

exp,imp 产生错误数据46588.21 bug

2011-10-27 by weejar zhang

exp,imp到其他9i数据库里出现部分数据变成了 46588.21 ,只因为指定了buffer

性能诊断之视图V$SESSION_LONGOPS

2011-10-26 by weejar zhang

该视图记录任何的是操作时间超过6秒的，但是要注意并不是所有的超过6秒的记录都会在这里

解决行迁移案例

2011-10-21 by weejar zhang

table_name chain_cnt sta
———————– ———– ——-
ICME_SIMULATE_QA_STATUS 501443 YES

DML returning into 用法，使用操作前的值

2011-10-21 by weejar zhang

The RETURNING INTO clause allows us to return column values for rows affected by DML statements. The following test table is used to demonstrate this clause.