<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[congwei2965的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/congwei2965</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; congwei2965]]></copyright><item><title><![CDATA[ASM的安装配置]]></title><link>https://blog.youkuaiyun.com/congwei2965/article/details/100374396</link><guid>https://blog.youkuaiyun.com/congwei2965/article/details/100374396</guid><author>congwei2965</author><pubDate>Thu, 03 Dec 2015 15:56:06 +0800</pubDate><description><![CDATA[一、首先创建需要的用户和用户组，以及配置环境变量

使用root用户执行：
/usr/sbin/groupadd -g 501 oinstall
/usr/sbin/groupadd -g 502 dba
/usr/s...]]></description><category></category></item><item><title><![CDATA[oracleasm enable显示失败]]></title><link>https://blog.youkuaiyun.com/congwei2965/article/details/100374442</link><guid>https://blog.youkuaiyun.com/congwei2965/article/details/100374442</guid><author>congwei2965</author><pubDate>Wed, 02 Dec 2015 14:58:42 +0800</pubDate><description><![CDATA[安装完ASM相应组件后，执行/etc/Init.d/oracleasm enable后显示失败。查看日志

[root@oracle log]# more /var/log/oracleasm 
Disk "VOL1"...]]></description><category></category></item><item><title><![CDATA[使用sqlload导入外部数据]]></title><link>https://blog.youkuaiyun.com/congwei2965/article/details/100374392</link><guid>https://blog.youkuaiyun.com/congwei2965/article/details/100374392</guid><author>congwei2965</author><pubDate>Fri, 20 Nov 2015 15:49:09 +0800</pubDate><description><![CDATA[被导入的表
SQL&gt; desc emp_enc
Name Type     Nullable Default Comments
----- ------------ -------- ------- --...]]></description><category></category></item><item><title><![CDATA[11g wallet使用]]></title><link>https://blog.youkuaiyun.com/congwei2965/article/details/100374425</link><guid>https://blog.youkuaiyun.com/congwei2965/article/details/100374425</guid><author>congwei2965</author><pubDate>Wed, 18 Nov 2015 16:29:36 +0800</pubDate><description><![CDATA[使用DBA权限创建

[oracle@oracle wallet]$ cd $ORACLE_HOME/network/admin
添加下面路径到sqlnet.ora里
[oracle@oracle admin]$ vi ...]]></description><category></category></item><item><title><![CDATA[SQL处理的主要步骤]]></title><link>https://blog.youkuaiyun.com/congwei2965/article/details/100374386</link><guid>https://blog.youkuaiyun.com/congwei2965/article/details/100374386</guid><author>congwei2965</author><pubDate>Tue, 10 Nov 2015 17:29:11 +0800</pubDate><description><![CDATA[SQL语句在处理中要经过几个步骤，分别是分析、绑定和执行。Oracle使用游标（专用SQL区）来存储分析过的语句以及与当前处理的语句有关的其他信息。
Oracle自动为所有SQL语句打开一个游标。

  分析...]]></description><category></category></item><item><title><![CDATA[使用index_stats视图查看索引效率]]></title><link>https://blog.youkuaiyun.com/congwei2965/article/details/100374390</link><guid>https://blog.youkuaiyun.com/congwei2965/article/details/100374390</guid><author>congwei2965</author><pubDate>Tue, 10 Nov 2015 10:41:55 +0800</pubDate><description><![CDATA[使用INDEX_STATS查看索引使用空间的效率，如果表（和索引）数据进行多次的删除操作，那么大的索引随着时间的推移有变得不平衡的趋势。
注意，只有使用过ANALYZE后，才会对INDEX_STATS进行填充
SQL&gt;...]]></description><category></category></item><item><title><![CDATA[备份表，并清空原表]]></title><link>https://blog.youkuaiyun.com/congwei2965/article/details/100374389</link><guid>https://blog.youkuaiyun.com/congwei2965/article/details/100374389</guid><author>congwei2965</author><pubDate>Fri, 06 Nov 2015 17:19:14 +0800</pubDate><description><![CDATA[declare
 v_cnt number(1);
begin
 select count(1) into v_cnt from user_tables where lower(table_name)='t_batch...]]></description><category></category></item><item><title><![CDATA[在系统上查看网卡设备]]></title><link>https://blog.youkuaiyun.com/congwei2965/article/details/100374420</link><guid>https://blog.youkuaiyun.com/congwei2965/article/details/100374420</guid><author>congwei2965</author><pubDate>Mon, 02 Nov 2015 09:52:27 +0800</pubDate><description><![CDATA[lsdev –Cc adapter |grep en


ent0  Available 02-08 2-Port 10/100/1000 Base-TX PCI-X Adapter (14108902)
en...]]></description><category></category></item><item><title><![CDATA[history保留时间戳]]></title><link>https://blog.youkuaiyun.com/congwei2965/article/details/100374378</link><guid>https://blog.youkuaiyun.com/congwei2965/article/details/100374378</guid><author>congwei2965</author><pubDate>Mon, 02 Nov 2015 09:48:29 +0800</pubDate><description><![CDATA[很多人都会用到history这个命令，这个命令的意思就是列出来当前用户的所有操作（默认如此），但是很多发行版的默认的history是没有用户和操作时间的，这个对于需要查看原来的操作内容的时候就提供了麻烦，man 了下histor...]]></description><category></category></item><item><title><![CDATA[sudo使用]]></title><link>https://blog.youkuaiyun.com/congwei2965/article/details/100374436</link><guid>https://blog.youkuaiyun.com/congwei2965/article/details/100374436</guid><author>congwei2965</author><pubDate>Mon, 02 Nov 2015 09:47:17 +0800</pubDate><description><![CDATA[visudo编辑sudo


	


	


	


	test ALL=(root)
/usr/sbin/useradd //新增加用户行


	……后面省略
...]]></description><category></category></item><item><title><![CDATA[实时查询最耗CPU资源的SQL语句]]></title><link>https://blog.youkuaiyun.com/congwei2965/article/details/100374418</link><guid>https://blog.youkuaiyun.com/congwei2965/article/details/100374418</guid><author>congwei2965</author><pubDate>Fri, 30 Oct 2015 11:49:27 +0800</pubDate><description><![CDATA[1. 先通过top命令查看产用资源较多的spid号


	2.查询当前耗时的会话ID，用户名，sqlID等：
select sid,serial#,machine,username,program,sql_hash...]]></description><category></category></item><item><title><![CDATA[ORACLE 11g 自动收集统计信息]]></title><link>https://blog.youkuaiyun.com/congwei2965/article/details/100374398</link><guid>https://blog.youkuaiyun.com/congwei2965/article/details/100374398</guid><author>congwei2965</author><pubDate>Mon, 26 Oct 2015 10:15:30 +0800</pubDate><description><![CDATA[统计信息是表及索引的基础信息，生成执行计划时，通过一系列参数来计算成本，这就是CBO用获得最低成本的计划的依据之一  如果统计信息准确则可以生成较好的计划，如果统计信息不准确 生成的计划就不一定是最优的
在Oracle的1...]]></description><category></category></item><item><title><![CDATA[expdp/impdp使用方法]]></title><link>https://blog.youkuaiyun.com/congwei2965/article/details/100374371</link><guid>https://blog.youkuaiyun.com/congwei2965/article/details/100374371</guid><author>congwei2965</author><pubDate>Sun, 06 Apr 2014 19:58:02 +0800</pubDate><description><![CDATA[①、expdp与impdp参数说明
[oracle@redhat4 ~]$ expdp help=y

Export: Release 10.2.0.1.0 - 64bit Production on Tuesday, 0...]]></description><category></category></item><item><title><![CDATA[rman恢复的基本知识]]></title><link>https://blog.youkuaiyun.com/congwei2965/article/details/100374439</link><guid>https://blog.youkuaiyun.com/congwei2965/article/details/100374439</guid><author>congwei2965</author><pubDate>Sun, 06 Apr 2014 11:44:17 +0800</pubDate><description><![CDATA[1、口令文件的恢复
口令文件的路径:$ORACLE_HOME/dbs目录下
 cd$ORACLE_HOME/dbs
rm orapworcl
orapwd file=orapworcl password=oracle ...]]></description><category></category></item><item><title><![CDATA[Linux/Uninx下Oracle的oerr工具的使用]]></title><link>https://blog.youkuaiyun.com/congwei2965/article/details/100374399</link><guid>https://blog.youkuaiyun.com/congwei2965/article/details/100374399</guid><author>congwei2965</author><pubDate>Sun, 06 Apr 2014 10:42:09 +0800</pubDate><description><![CDATA[oerr是oracle在unix上的查找ora错误的小工具，极其方便。
命令格式为：
oerr ora 
错误编号
例如要查看ora-01190的描述：
[oracle@redhat4 ~]$ oerr ora 011...]]></description><category></category></item><item><title><![CDATA[rman备份的基本知识]]></title><link>https://blog.youkuaiyun.com/congwei2965/article/details/100374394</link><guid>https://blog.youkuaiyun.com/congwei2965/article/details/100374394</guid><author>congwei2965</author><pubDate>Sat, 05 Apr 2014 14:58:34 +0800</pubDate><description><![CDATA[1、检查数据库模式
SQL&gt; archive log list;
Database log mode       No Archive Mode
Automatic archival     ...]]></description><category></category></item><item><title><![CDATA[RMAN备份时出现ORA-19809: limit exceeded for recovery files]]></title><link>https://blog.youkuaiyun.com/congwei2965/article/details/100374429</link><guid>https://blog.youkuaiyun.com/congwei2965/article/details/100374429</guid><author>congwei2965</author><pubDate>Fri, 04 Apr 2014 16:36:35 +0800</pubDate><description><![CDATA[RMAN&gt; backup database plus archivelog delete input;
.
.
.
channel ORA_DISK_1: starting piece 1 at 04-APR-...]]></description><category></category></item><item><title><![CDATA[RMAN的"rman: can't open target"错误]]></title><link>https://blog.youkuaiyun.com/congwei2965/article/details/100374365</link><guid>https://blog.youkuaiyun.com/congwei2965/article/details/100374365</guid><author>congwei2965</author><pubDate>Fri, 04 Apr 2014 13:33:25 +0800</pubDate><description><![CDATA[在Linux上，安装完成之后，在测试RMAN时可能会遇到如下错误：
[oracle@redhat4 ~]$ rman target /
rman: can't open target

这是由于调用的是非Oracle的R...]]></description><category></category></item><item><title><![CDATA[AWR报告生成方法]]></title><link>https://blog.youkuaiyun.com/congwei2965/article/details/100509671</link><guid>https://blog.youkuaiyun.com/congwei2965/article/details/100509671</guid><author>congwei2965</author><pubDate>Sun, 30 Mar 2014 21:08:55 +0800</pubDate><description><![CDATA[AWR 是 Oracle 10g 后推出的新特性， 全称叫Automatic Workload Repository-自动负载信息库, AWR 是通过对比两次快照(snapshot)收集到的统计信息。
通过AWR报告，我们可...]]></description><category></category></item><item><title><![CDATA[Oracle诊断工具RDA在UNIX下的使用概述]]></title><link>https://blog.youkuaiyun.com/congwei2965/article/details/100374364</link><guid>https://blog.youkuaiyun.com/congwei2965/article/details/100374364</guid><author>congwei2965</author><pubDate>Fri, 28 Mar 2014 19:31:44 +0800</pubDate><description><![CDATA[RDA是Remote Diagnostic Agent 的简称，是oracle用来收集、分析数据库的工具，运行该工具不会改变系统的任何参数，RDA收集的相关数据非常全面，可以简化我们日常监控、分析数据库的工作，Oracle Su...]]></description><category></category></item></channel></rss>