SESSION_CACHED_CURSORS that can be set that will help i...]]>
								blog
								lsq_008
								Fri, 20 Jun 2008 10:20:35 GMT
							
							
								
								http://space.itpub.net/10972173/viewspace-351926
								Hypercharge Oracle data load speed
These notes document techniques for improving the speed of Oracle import (imp or impdp) and Oracle SQL*L...]]>
								blog
								lsq_008
								Fri, 20 Jun 2008 08:14:12 GMT
							
							
								
								http://space.itpub.net/10972173/viewspace-344523
								SELECT LPAD( MONTH, 20-(20-LENGTH(MONTH))/2 ) MONTH,"Sun", "Mon", "Tue",
"Wed", "Thu", "Fri", "Sat"
FROM (SELECT TO_CHAR(dt,'fmMonthfm YYYY') MONTH,TO_CHAR(dt+1,'iw') week,
MAX(DECODE(TO_CHAR(dt,'d'),'1',LPAD(TO_CHAR(dt,'fmdd'),2))) "Sun",<...]]>
								blog
								lsq_008
								Thu, 12 Jun 2008 15:06:46 GMT
							
							
								
								http://space.itpub.net/10972173/viewspace-343059
								为了进行此次测试，需要加hints来指定驱动表，如下解释：
ORDERED
The ORDERED hint causes Oracle to join tables in the order in which they appear in the FROM clause.
...]]>
								blog
								lsq_008
								Sat, 07 Jun 2008 19:07:23 GMT
							
							
								
								http://space.itpub.net/10972173/viewspace-312651
								1.最大保护模式配置。
1.1确认是否有standby log。

SQL> SELECT * FROM V$LOGFILE WHERE TYPE = 'STANDBY';
 
no rows selected
1.2停止...]]>
								blog
								lsq_008
								Tue, 27 May 2008 18:21:18 GMT
							
							
								
								http://space.itpub.net/10972173/viewspace-310307
								1. 创建2个测试表，一个表的数据按照顺序存放，另一个随机存放。

sys@TEST>create table colocated(x int,y varchar2(80...]]>
								blog
								lsq_008
								Mon, 26 May 2008 10:45:50 GMT
							
							
								
								http://space.itpub.net/10972173/viewspace-310116
								1.dataguardcreate">scott@TEST>create table s_tabl...]]>
								blog
								lsq_008
								Sat, 17 May 2008 11:25:32 GMT
							
							
								
								http://space.itpub.net/10972173/viewspace-274657
								1. 测试表test，执行一个查询，在empno列上创建了唯一索引，在没有做分析时，使用RBO生成执行计划：

scott@TEST>select...]]>
								blog
								lsq_008
								Sat, 17 May 2008 11:07:44 GMT
							
							
								
								http://space.itpub.net/10972173/viewspace-274656
								1. 在一个大表上创建唯一索引
scott@TEST>create unique index idx_test on test(empno) ...]]>
								blog
								lsq_008
								Sat, 17 May 2008 08:56:10 GMT
							
							
								
								http://space.itpub.net/10972173/viewspace-265307
								1. oracle提供了一个过程，能够将对象keep到shared_pool中。如下：

SQL> exec dbms_shared_pool.keep('STANDARD');
 
PL/SQL procedure successfully completed. 

								blog
								lsq_008
								Tue, 13 May 2008 14:34:08 GMT
							
							
								
								http://space.itpub.net/10972173/viewspace-265143
								part 1： 与shared pool相关的参数

1.  shared_pool_size :该参数设置了共享池的总大小，单位是字节。
2. shared_pool_reserved_size: 该参数设定为较大对象使用的保留共享池大小。
3.shared_pool_reserved_min_alloc: ...]]>
								blog
								lsq_008
								Mon, 12 May 2008 13:29:54 GMT
							
							
								
								http://space.itpub.net/10972173/viewspace-265031
								9i环境下测试如下：
sys@TEST>select * from v$version;
 
BANNER
------------------------------------...]]>
								blog
								lsq_008
								Sun, 11 May 2008 15:52:53 GMT
							
							
								
								http://space.itpub.net/10972173/viewspace-263437
								1.以oracle用户身份，备份源数据库，脚本如下：
run{
allocate channel c1 type disk
format '/oracle/rman_bk/lev_0_%d_%T%s%p%u.bak';
BACKUP  database ;
sql 'alter system switch logfile';
}
								blog
								lsq_008
								Fri, 09 May 2008 12:42:29 GMT
							
							
								
								http://space.itpub.net/10972173/viewspace-260373
								先来一段oracle document里对此参数的一段解释：

Specifies whether or not Export uses the SET TRANSACTION READ ONLY statement to ensure that the data ...]]>
								blog
								lsq_008
								Mon, 05 May 2008 15:42:45 GMT
							
							
								
								http://space.itpub.net/10972173/viewspace-260076
								    昨天，看到老婆手机里有一条短信，我半开玩笑半认真的追问了老婆几句，结果把她惹怒了，抓起手机就给摔到床上，摔了一下似乎不过瘾，又抓起来往地上摔，嘴里还振振有词，曰“再也不用手机了！！！”（注：这是不可能的，我可怜...]]>
								blog
								lsq_008
								Sun, 04 May 2008 21:17:07 GMT