Free Hosting

Free Web Hosting with PHP, MySQL, Apache, FTP and more.
Get your Free SubDOMAIN or or...
Create your account NOW at

Cheap Domains

Cheap Domains
starting at $2.99/year


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

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

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

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

exp,imp 产生错误数据46588.21 bug

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

粗谈 Load_average 负载

linux/unit 系统中查看cpu系统负载,都会先看一下这个参数,这个值在uptime 或ps 中都有



解决行迁移 案例

table_name chain_cnt sta
———————– ———– ——-

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

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.

详解dump block trace file,找出行链接

tab 0, row 0, @0x819
tl: 2061 fb: –H-F–N lb: 0x0 cc: 3
nrid: 0x0180005e.0
col 0: [ 2] c1 02

关于ORACLE 行链接与行迁移


event 10046 简单使用

Level 0 停用SQL跟踪,相当于SQL_TRACE=FALSE
Level 1 标准SQL跟踪,相当于SQL_TRACE=TRUE
Level 4 在level 1的基础上增加绑定变量的信息
Level 8 在level 1的基础上增加等待事件的信息

latch: cache buffers chains 案例

Top 5 Timed Events

Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class
CPU time 26,173 42.3
latch: cache buffers chains 21,954 4,041 184 6.5 Concurrency

关于深入shared pool

shared pool 由perm,libary cache,row catch(dictionary catch),reserved area(保留),free area 组成。

ROW_NUMBER() and SYS_CONNECT_BY_PATH in oracle 9i 合并列

合并列有很多方法,如聚焦函数、自定义函数利用游标分组、ROW_NUMBER() and SYS_CONNECT_BY_PATH 、还有10g后的wm_concat、及11G后新增函数..

oracle 10g owi增强 系统视图查询各命中率

owi (oracle wait interface)从oracle 7开始提供,开始是为了帮助oracle开发人员查询oracle性能,后来对外开放,帮助oracle用户的管理者和开发者分析数据库各模块的所需要时间