<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[cuiqiang1269的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/cuiqiang1269</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; cuiqiang1269]]></copyright><item><title><![CDATA[利用Oracle 10g SQL优化器（STA）优化语句[转]]]></title><link>https://blog.youkuaiyun.com/cuiqiang1269/article/details/100438658</link><guid>https://blog.youkuaiyun.com/cuiqiang1269/article/details/100438658</guid><author>cuiqiang1269</author><pubDate>Fri, 01 Jul 2011 16:33:48 +0800</pubDate><description><![CDATA[&lt;!-- 
jackjw | 04 十一月, 2008 16:03

利用Oracle 10g SQL优化器（STA）优化语句
SQL优化器(SQL Tuning Advisor STA)是Oracle10g中推...]]></description><category></category></item><item><title><![CDATA[有关物化视图及查询重写功能]]></title><link>https://blog.youkuaiyun.com/cuiqiang1269/article/details/100438704</link><guid>https://blog.youkuaiyun.com/cuiqiang1269/article/details/100438704</guid><author>cuiqiang1269</author><pubDate>Thu, 30 Jun 2011 13:32:25 +0800</pubDate><description><![CDATA[物化视图的创建及刷新方式介绍网上有很多，就不重复了，这里主要通过实验来验证查询重写功能。
SQL&gt; desc hr.employees;Name...]]></description><category></category></item><item><title><![CDATA[建站知识2-mysql配置]]></title><link>https://blog.youkuaiyun.com/cuiqiang1269/article/details/100438652</link><guid>https://blog.youkuaiyun.com/cuiqiang1269/article/details/100438652</guid><author>cuiqiang1269</author><pubDate>Thu, 23 Jun 2011 22:57:47 +0800</pubDate><description><![CDATA[RPM安装Mysql 
mysql需要perl(DBI)和perl-DBD-MySQL的支持，因此先安装perl-DBI及perl-DBD-MySQL
perl-DBI安装

[root@linux-a ~]# rpm ...]]></description><category></category></item><item><title><![CDATA[建站知识1-环境搭建[转]]]></title><link>https://blog.youkuaiyun.com/cuiqiang1269/article/details/100438654</link><guid>https://blog.youkuaiyun.com/cuiqiang1269/article/details/100438654</guid><author>cuiqiang1269</author><pubDate>Thu, 23 Jun 2011 22:56:13 +0800</pubDate><description><![CDATA[LAMP就是Linux+Apache+MySql+PHP搭建的动态网站环境，是目前互联网上非常流行的一个网页服务组合。
网上有很多教程搭建LAMP环境，基本上都是编译安装的，其实对新手来说只需要了解LAMP环境的一些特性，RM...]]></description><category></category></item><item><title><![CDATA[数据文件故障恢复一例]]></title><link>https://blog.youkuaiyun.com/cuiqiang1269/article/details/100438682</link><guid>https://blog.youkuaiyun.com/cuiqiang1269/article/details/100438682</guid><author>cuiqiang1269</author><pubDate>Thu, 16 Jun 2011 23:44:08 +0800</pubDate><description><![CDATA[收到用户反映无法查询，查询返回一个有关无法访问数据文件的报错。
环境solaris10+oracle10204 rac。
系统log看到很多IO类错误：
Jun 16 11:50:30 sspu-sso scsi: [ID...]]></description><category></category></item><item><title><![CDATA[绑定变量的实验小语句]]></title><link>https://blog.youkuaiyun.com/cuiqiang1269/article/details/100438644</link><guid>https://blog.youkuaiyun.com/cuiqiang1269/article/details/100438644</guid><author>cuiqiang1269</author><pubDate>Mon, 06 Jun 2011 14:02:38 +0800</pubDate><description><![CDATA[var x varchar2(15)exec :x:='fadsf';select :x from dual;select aa from lzl where cc=:x注意：当绑定的变量大于20字节，将产生子游标。
     ...]]></description><category></category></item><item><title><![CDATA[oracle 简单存储过程]]></title><link>https://blog.youkuaiyun.com/cuiqiang1269/article/details/100438649</link><guid>https://blog.youkuaiyun.com/cuiqiang1269/article/details/100438649</guid><author>cuiqiang1269</author><pubDate>Mon, 06 Jun 2011 13:50:28 +0800</pubDate><description><![CDATA[SQL&gt; create procedure lzlpre as  2 begin 3 for i in 1..2 loop  4 insert into lzltemp sele...]]></description><category></category></item><item><title><![CDATA[oracle plsql简易循环]]></title><link>https://blog.youkuaiyun.com/cuiqiang1269/article/details/100438681</link><guid>https://blog.youkuaiyun.com/cuiqiang1269/article/details/100438681</guid><author>cuiqiang1269</author><pubDate>Mon, 06 Jun 2011 13:28:50 +0800</pubDate><description><![CDATA[beginfor i in 1..9 loop insert into lzltemp select * from lzl where manager_id=201;end loop;commit;end;/
用于测...]]></description><category></category></item><item><title><![CDATA[查看数据库表对象的对应块信息]]></title><link>https://blog.youkuaiyun.com/cuiqiang1269/article/details/100438648</link><guid>https://blog.youkuaiyun.com/cuiqiang1269/article/details/100438648</guid><author>cuiqiang1269</author><pubDate>Mon, 06 Jun 2011 12:35:51 +0800</pubDate><description><![CDATA[在使用BBED修改数据块，或者其他情况，需要查看数据库对象对应的物理文件及数据块时，可使用dbms_rowid函数进行查询。测试：
首先我这有一张10行的表
SQL&gt; desc lzlName...]]></description><category></category></item><item><title><![CDATA[审计用户失败的登陆行为]]></title><link>https://blog.youkuaiyun.com/cuiqiang1269/article/details/100438678</link><guid>https://blog.youkuaiyun.com/cuiqiang1269/article/details/100438678</guid><author>cuiqiang1269</author><pubDate>Tue, 24 May 2011 15:46:50 +0800</pubDate><description><![CDATA[接到用户一个需求，很简单，oracle默认用错误密码登陆10，会锁定账户。需要跟踪是哪个客户端发起的行为，造成数据库用户锁定了。
打开数据库的审计，将审计记录放在数据库内，以便查询管理。（个人习惯，放OS也可以，但是查起来不方...]]></description><category></category></item><item><title><![CDATA[查看oracle隐含参数脚本]]></title><link>https://blog.youkuaiyun.com/cuiqiang1269/article/details/100438641</link><guid>https://blog.youkuaiyun.com/cuiqiang1269/article/details/100438641</guid><author>cuiqiang1269</author><pubDate>Sun, 22 May 2011 10:46:40 +0800</pubDate><description><![CDATA[set linesize 132column name format a30column value format a25select x.ksppinm name, y.ksppstvl value, y.kspps...]]></description><category></category></item><item><title><![CDATA[使用keep_pool缓存表优化一例]]></title><link>https://blog.youkuaiyun.com/cuiqiang1269/article/details/100438693</link><guid>https://blog.youkuaiyun.com/cuiqiang1269/article/details/100438693</guid><author>cuiqiang1269</author><pubDate>Fri, 20 May 2011 13:06:50 +0800</pubDate><description><![CDATA[查了挺久的问题了。
用户反应早上第一笔业务，查询缓慢，之后每笔业务均能1S内返回。
从现象上分析，应该是此业务所需的表数据不在SGA内，而采用物理读的方式进行第一次访问，造成效率比较低。由于此库上跑了好几套业务，无法从全局确...]]></description><category></category></item><item><title><![CDATA[在Word中为标题样式添加自动编号功能【转】]]></title><link>https://blog.youkuaiyun.com/cuiqiang1269/article/details/100438638</link><guid>https://blog.youkuaiyun.com/cuiqiang1269/article/details/100438638</guid><author>cuiqiang1269</author><pubDate>Thu, 12 May 2011 16:52:50 +0800</pubDate><description><![CDATA[摘要：
本文可以帮助你在Office 2007中为Word标题样式添加和设置自动编号功能。
正文：
近日因工作需要，需要编制一份Word文档，并需要为标题提供编号，而系统默认的标题样式并没有自动编号的功能，系统默认的标题样...]]></description><category></category></item><item><title><![CDATA[redhat 5 安装gridcontrol 报错处理]]></title><link>https://blog.youkuaiyun.com/cuiqiang1269/article/details/100438691</link><guid>https://blog.youkuaiyun.com/cuiqiang1269/article/details/100438691</guid><author>cuiqiang1269</author><pubDate>Tue, 03 May 2011 14:48:51 +0800</pubDate><description><![CDATA[老规矩，备忘，5.4上报的2个错。
会报缺少一个系统包，5.4已经不使用该包，可用链接替换法。
ln -s /usr/lib/libgdbm.so.2.0.0 /usr/lib/libdb.so.2

/home/...]]></description><category></category></item><item><title><![CDATA[exp与expdp全库导出数据对表空间、用户处理的测试]]></title><link>https://blog.youkuaiyun.com/cuiqiang1269/article/details/100438661</link><guid>https://blog.youkuaiyun.com/cuiqiang1269/article/details/100438661</guid><author>cuiqiang1269</author><pubDate>Thu, 21 Apr 2011 17:38:31 +0800</pubDate><description><![CDATA[有关传统导入导出，以及数据泵导入导出的说明，可以在命令后跟help=y看简单说明。详细说明在联机文档的ultity一本书里。
test1作为原始库，创建用户lzl，默认表空间lzltbs，在其上建表lzltable (no n...]]></description><category></category></item><item><title><![CDATA[sqlplus直接输出成html格式，很实用]]></title><link>https://blog.youkuaiyun.com/cuiqiang1269/article/details/100438744</link><guid>https://blog.youkuaiyun.com/cuiqiang1269/article/details/100438744</guid><author>cuiqiang1269</author><pubDate>Mon, 18 Apr 2011 21:20:14 +0800</pubDate><description><![CDATA[老是懒得写博客，就当备忘了
set linesize 200 set echo onset term off verify off feedback off pagesize 999 set markup html on en...]]></description><category></category></item><item><title><![CDATA[彻底解决rman恢复碰到ora-01152错]]></title><link>https://blog.youkuaiyun.com/cuiqiang1269/article/details/100438646</link><guid>https://blog.youkuaiyun.com/cuiqiang1269/article/details/100438646</guid><author>cuiqiang1269</author><pubDate>Wed, 23 Mar 2011 22:02:32 +0800</pubDate><description><![CDATA[说说碰到这个问题的背景。
使用NBU调脚本对oracle进行备份。脚本如下：
RUN {ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';ALLOCATE CHANNEL ch01 TYPE 'SB...]]></description><category></category></item><item><title><![CDATA[文件名自动添加日期]]></title><link>https://blog.youkuaiyun.com/cuiqiang1269/article/details/100438636</link><guid>https://blog.youkuaiyun.com/cuiqiang1269/article/details/100438636</guid><author>cuiqiang1269</author><pubDate>Mon, 21 Mar 2011 20:51:00 +0800</pubDate><description><![CDATA[老是忘语法，备忘
touch lzl`date +%m%d%y`.LOG
其中`为键盘1边上的键。date后记得有空格。
                                                   ...]]></description><category></category></item><item><title><![CDATA[使用连接符拼脚本]]></title><link>https://blog.youkuaiyun.com/cuiqiang1269/article/details/100438634</link><guid>https://blog.youkuaiyun.com/cuiqiang1269/article/details/100438634</guid><author>cuiqiang1269</author><pubDate>Mon, 21 Mar 2011 20:48:45 +0800</pubDate><description><![CDATA[老是忘了语法怎么写，备忘
SQL&gt; select 'alter package '||object_name||' compile' FROM dba_objects where object_type='PACKAG...]]></description><category></category></item><item><title><![CDATA[转载 导入导出的分析]]></title><link>https://blog.youkuaiyun.com/cuiqiang1269/article/details/100438692</link><guid>https://blog.youkuaiyun.com/cuiqiang1269/article/details/100438692</guid><author>cuiqiang1269</author><pubDate>Thu, 03 Mar 2011 23:58:53 +0800</pubDate><description><![CDATA[exp/imp 与 expdp/impdp 对比 及使用中的一些优化事项 收藏 
关于exp/imp 和 expdp/impdp， 之前整理的2篇Blog如下：

ORACLE 数据库逻辑备份 简单 EXP/IMP
...]]></description><category></category></item></channel></rss>