Lists

技术文章列表

Name	Web address	Description

第八章 ORACLE 索引 INDEXES (一）	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!988.entry	ORACLE深入

第七章 Redo and Undo （二）	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!934.entry	ORACLE深入

第七章Redo and Undo （一）	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!933.entry	ORACLE深入

oracle10 linux9 修改listener监听端口遇到ORA-28547错误	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!926.entry

DBA需要的技能如何成为ORACLE DBA	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!917.entry

第六章Transactions	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!914.entry	oracle深入

DATAFILE的extents的回收resize	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!905.entry

ORACLE10G修改主机名后的EM(Enterprise Manager)启动问题	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!899.entry

第五章 Locking and Latching	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!904.entry	ORACLE深入

第四章 Oracle Processes	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!902.entry	ORACLE深入

第三章内存结构	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!896.entry	ORACLE深入

第二章 Files	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!895.entry	ORACLE深入

安装ORACLE10 ora-22303 ora-00604 ora-04031	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!890.entry

排列组合	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!891.entry

第一章ORACLE DBA常用语句和脚本(2)	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!886.entry	ORACLE深入

第一章ORACLE DBA常用语句和脚本(1)	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!884.entry	ORACLE深入

一个SQL得到两个日期之间的时分秒	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!880.entry

ORACLE 判断字符型能否转换成日期型 ORA-01847 ORA-01843	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!879.entry

DB2实现ORACLE的CONNECT BY PRIOR START WITH功能	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!870.entry

ORACLE DBA EXP QUERY=	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!760.entry

SQL0668N 原因码为 "1"，所以不允许操作 SQLSTATE=57016 ORACLE一次失败的导入到DB2	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!754.entry

DB2 ORACLE 常用函数异同	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!753.entry

ORACLE 用MTK工具导入到DB2	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!751.entry

ORACLE 得到一年中的第几周的开始和结束日期	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!746.entry

oracle SQL导数据过程中SEQUENCE的问题	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!743.entry

DB2函数大全	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!739.entry

Oracle 9i and DB2 v8.1 limits	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!724.entry

TEMPORARY tablespace 一次ORA-01114 ORA-27063 问题解决	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!718.entry

ORACLE和DB2 对象和数据类型的异同	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!714.entry

同一字段按不同方向排序	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!717.entry

ORACLE DB2 SEQUENCE区别	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!713.entry

SQL SERVER 以前的某个程序安装已在安装计算机上创建挂起的文件操作。运行安装程序之前必须重新启动计算机!	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!709.entry

ORACLE INSERT 语句补遗	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!705.entry

bitmap indexes 的结构分析 (三）	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!681.entry	再看看SQL的执行路经

bitmap indexes 的结构分析(二)	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!678.entry	oracle dump bitmap indexes

bitmap indexes 的结构分析(一）	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!675.entry	索引结构分析

HP-UX ORACLE9 关闭与启动问题ORA-27300 ORA-27301 ORA-27302 ORA-27123 ORA-00600 HP-UX Error: 22: Invalid arg	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!671.entry

PARALLEL QUERY	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!669.entry

奇怪的现象	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!666.entry

升级到9.2.0.4.0，exp出现的问题	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!623.entry

一个TABLESPACE 多个DATAFILE	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!665.entry

ORA-01034 ORA-27121 13: Permission denied	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!642.entry

full outer join	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!631.entry

workarea_size_policy 和 sort_area_size	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!628.entry

PROCEDURE 存储过程	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!575.entry

DBMS_LOCK包测试ORACLE LOCK	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!590.entry

ORACLE性能调整三	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!501.entry	ORACLE性能调整系列

ORACLE性能调整二	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!500.entry	ORACLE性能调整系列

ORACLE性能调整一	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!498.entry	ORACLE性能调整系列

成就DBA职业生涯	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!548.entry

ORACLE 关连更新 update select	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!556.entry

ORACLE IMP 字段不同的表	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!555.entry

ORACLE 内存管理之六 SGA Multiple Block Sizes,Large Pool	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!514.entry	ORACLE 内存管理

ORACLE内存管理之五 SGA variable pool,shared_pool,large_pool,java_pool	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!513.entry	ORACLE内存管理

ORACLE 内存管理之四 SGA	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!512.entry	ORACLE内存管理

ORACLE内存管理之三 PGA v$sql_workarea_histogram v$pga_target_advice	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!511.entry	ORACLE内存管理

ORACLE 内存管理之二 PGA v$pgastat	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!510.entry	ORACLE 内存管理

ORACLE内存管理之一 ORACLE PGA	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!509.entry	ORACLE内存管理

oracle process,ORA-03113,ORA-01034,ORA-00020	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!503.entry

一个语句实现DOS登陆ORACLE并输出	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!497.entry

v$sql v$sqlarea v$sqltext	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!496.entry

数据类型内部结构存储	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!470.entry

ORA-03237: Initial Extent of specified size cannot be allocated in tablespace	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!464.entry

ORACLE CPU过高的一次调整过程	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!443.entry

PROCEDURE行变列与输出	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!433.entry

ACCESS导入到ORACLE	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!345.entry

SELECT FOR UPDATE 相关的知识	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!318.entry

CVS安装及权限分配	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!313.entry

CVS简介	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!312.entry

DB2基础概念	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!304.entry

constraints 三个需要注意的地方	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!278.entry

Unicode 编码规范	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!273.entry

TRIGGER之我见	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!244.entry

Tables总结	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!240.entry

修改sequence的开始值与其他	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!243.entry

cost of dual	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!234.entry	DUAL的缺点及解决方法

数据库安全系列一密码安全	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!187.entry	数据库安全系列

数据库安全系列二网络安全	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!193.entry	数据库安全系列

数据库安全系列三其他安全	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!205.entry	数据库安全系列

autotrace后结果为0	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!182.entry

BIND VARIABLE	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!175.entry

PRO*C	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!173.entry	PRO*C入门

数据库安全性相关脚本	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!172.entry

TEMPORARY表空间和文件	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!165.entry

32位&64位	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!164.entry

PL/SQL	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!151.entry

v$fixed_table表研究	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!148.entry	固定表

COUNT(*) 与count(i)	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!146.entry

ORACLE访问数据的方法	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!145.entry	ORACLE访问数据的方法

AUTOTRACE设置的问题SP2-0618	http://sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!144.entry	AUTOTRACE设置的问题SP2-0618