https://blog.youkuaiyun.com/wph001zh-cnhttps://blog.youkuaiyun.com/https://blog.youkuaiyun.com/wph001/article/details/51307263https://blog.youkuaiyun.com/wph001/article/details/51307263wph001Tue, 03 May 2016 19:56:30 +0800https://blog.youkuaiyun.com/wph001/article/details/50306109https://blog.youkuaiyun.com/wph001/article/details/50306109wph001Tue, 15 Dec 2015 00:34:35 +0800https://blog.youkuaiyun.com/wph001/article/details/50296465https://blog.youkuaiyun.com/wph001/article/details/50296465wph001Mon, 14 Dec 2015 16:20:58 +0800https://blog.youkuaiyun.com/wph001/article/details/50264787https://blog.youkuaiyun.com/wph001/article/details/50264787wph001Fri, 11 Dec 2015 15:49:38 +0800 http://www.w3.org/1999/xhtml">  function printfunc(){            pdf.setPageMode("none");]]>https://blog.youkuaiyun.com/wph001/article/details/50264755https://blog.youkuaiyun.com/wph001/article/details/50264755wph001Fri, 11 Dec 2015 15:47:41 +0800https://blog.youkuaiyun.com/wph001/article/details/50263137https://blog.youkuaiyun.com/wph001/article/details/50263137wph001Fri, 11 Dec 2015 14:11:41 +0800https://blog.youkuaiyun.com/wph001/article/details/40454713https://blog.youkuaiyun.com/wph001/article/details/40454713wph001Sat, 25 Oct 2014 17:55:31 +0800https://blog.youkuaiyun.com/wph001/article/details/9196483https://blog.youkuaiyun.com/wph001/article/details/9196483wph001Fri, 28 Jun 2013 14:05:33 +0800https://blog.youkuaiyun.com/wph001/article/details/9120705https://blog.youkuaiyun.com/wph001/article/details/9120705wph001Tue, 18 Jun 2013 15:02:21 +0800https://blog.youkuaiyun.com/wph001/article/details/5995222https://blog.youkuaiyun.com/wph001/article/details/5995222wph001Mon, 08 Nov 2010 14:02:00 +0800https://blog.youkuaiyun.com/wph001/article/details/5971722https://blog.youkuaiyun.com/wph001/article/details/5971722wph001Thu, 28 Oct 2010 14:07:00 +08001.STATSPACK 的安装
  执行$ORACLE_HOME/rdbms/admin/spcreate.sql文件.
  安装statspack将创建perfstat用户,会提示输入perfstat的默认表空间和缺省表空间.
2.手动收集统计信息
  执行 STATSPACK.snap
3.自动收集统计信息
  执行$ORACLE_HOME/rdbms/admin/spauto.sql,使用dbms_job,自动收集统计信息,每小时]]>https://blog.youkuaiyun.com/wph001/article/details/5971712https://blog.youkuaiyun.com/wph001/article/details/5971712wph001Thu, 28 Oct 2010 14:06:00 +0800https://blog.youkuaiyun.com/wph001/article/details/5971705https://blog.youkuaiyun.com/wph001/article/details/5971705wph001Thu, 28 Oct 2010 14:04:00 +0800--建立散列分区表
create table t_emp(
empno int,
empname varchar2(20))
partition by hash(empno)
(partition part1 tablespace t1,
 partition part2 tablespace t2);
--插入数据
  insert into t_emp  select empno,ename from scott]]>https://blog.youkuaiyun.com/wph001/article/details/5971703https://blog.youkuaiyun.com/wph001/article/details/5971703wph001Thu, 28 Oct 2010 14:04:00 +0800--建立散列分区表
create table t_emp(
empno int,
empname varchar2(20))
partition by hash(empno)
(partition part1 tablespace t1,
 partition part2 tablespace t2);
--插入数据
  insert into t_emp  select empno,ename from scott]]>https://blog.youkuaiyun.com/wph001/article/details/5971693https://blog.youkuaiyun.com/wph001/article/details/5971693wph001Thu, 28 Oct 2010 14:03:00 +0800https://blog.youkuaiyun.com/wph001/article/details/5971682https://blog.youkuaiyun.com/wph001/article/details/5971682wph001Thu, 28 Oct 2010 14:00:00 +0800https://blog.youkuaiyun.com/wph001/article/details/5971673https://blog.youkuaiyun.com/wph001/article/details/5971673wph001Thu, 28 Oct 2010 13:58:00 +0800 10000  and (type='PACKAGE' or type='PACKAGE BODY' or type='FUNCTION' or type='PROCEDURE')  and KEPT='NO';   --连接高速缓冲]]>https://blog.youkuaiyun.com/wph001/article/details/5708552https://blog.youkuaiyun.com/wph001/article/details/5708552wph001Fri, 02 Jul 2010 10:16:00 +0800(H)最近比较烦，~~，~~，总觉得英文帮助有一些零乱，我想我还是不习惯： 从系统维护到编程人员； (Z)最近比较烦，~~，~~，总觉得模块一个比一个缓慢 ，朋友常常有意无意调侃：也许有一天我应该去微软； (L)最近比较烦，~~，~~ ，我写的程序怎么也编译不完，那个代码得有一半要设中断，AI-U，写一段没有 BUG的程序越来越难； (H)最近比较烦，~~，~~，客户的需求没有我想的简单，受尽了他们的责难，现在的我总觉得难堪； (Z)AI!最近比较烦，~~，~~，非法操作和蓝屏是接二连三，我问盖]]>https://blog.youkuaiyun.com/wph001/article/details/5708342https://blog.youkuaiyun.com/wph001/article/details/5708342wph001Fri, 02 Jul 2010 09:19:00 +0800