<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[cuixiuyin9014的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/cuixiuyin9014</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; cuixiuyin9014]]></copyright><item><title><![CDATA[oracle等待事件类型wait_class说明]]></title><link>https://blog.youkuaiyun.com/cuixiuyin9014/article/details/100464373</link><guid>https://blog.youkuaiyun.com/cuixiuyin9014/article/details/100464373</guid><author>cuixiuyin9014</author><pubDate>Fri, 20 Oct 2017 10:15:51 +0800</pubDate><description><![CDATA[Oracle 的等待事件是衡量数据库运行状况的重要依据及指标。

主要有两种类别的等待事件，即空闲（ idle ）等待事件和非空闲（ non-idle ）等待事件。

1，空闲等待事件
是指 Oracle 正等待某种工...]]></description><category></category></item><item><title><![CDATA[Active Session History (ASH) performed an emergency flush]]></title><link>https://blog.youkuaiyun.com/cuixiuyin9014/article/details/100464372</link><guid>https://blog.youkuaiyun.com/cuixiuyin9014/article/details/100464372</guid><author>cuixiuyin9014</author><pubDate>Fri, 15 Jan 2016 10:06:33 +0800</pubDate><description><![CDATA[1，问题描述：

SQL&gt; select * from v$version;

BANNER
-----------------------------------------------------------...]]></description><category></category></item><item><title><![CDATA[Oracle oradebug命令使用说明]]></title><link>https://blog.youkuaiyun.com/cuixiuyin9014/article/details/100464371</link><guid>https://blog.youkuaiyun.com/cuixiuyin9014/article/details/100464371</guid><author>cuixiuyin9014</author><pubDate>Fri, 13 Nov 2015 15:56:56 +0800</pubDate><description><![CDATA[一，Oradebug 命令 帮助文档
SQL&gt; oradebug help
HELP      [command]         Describe one or all commands
...]]></description><category></category></item><item><title><![CDATA[Fatal NI connect error 12170  TNS-12535/TNS-00505 TNS:operation timed out]]></title><link>https://blog.youkuaiyun.com/cuixiuyin9014/article/details/100464444</link><guid>https://blog.youkuaiyun.com/cuixiuyin9014/article/details/100464444</guid><author>cuixiuyin9014</author><pubDate>Thu, 06 Aug 2015 09:57:16 +0800</pubDate><description><![CDATA[1，系统环境：
操作系统：Solaris 64位
数据库版本：11.2.0.4 64位

2，在检查数据库的alert日志的时候，发现大量的12170和TNS-12535的错误
*******************...]]></description><category></category></item><item><title><![CDATA[EXP-00091: Exporting questionable statistics 问题处理方法]]></title><link>https://blog.youkuaiyun.com/cuixiuyin9014/article/details/100464368</link><guid>https://blog.youkuaiyun.com/cuixiuyin9014/article/details/100464368</guid><author>cuixiuyin9014</author><pubDate>Mon, 27 Jul 2015 09:14:35 +0800</pubDate><description><![CDATA[1，环境：
操作系统：HP-UX SCUP15 B.11.31
数据库:oracle 10.2.0.5


2，问题说明：
在我们对Oracle做EXP的过程中，可能会经常遇到EXP－00091 Exporting ...]]></description><category></category></item><item><title><![CDATA[Linux系统性能调优之性能分析]]></title><link>https://blog.youkuaiyun.com/cuixiuyin9014/article/details/100464366</link><guid>https://blog.youkuaiyun.com/cuixiuyin9014/article/details/100464366</guid><author>cuixiuyin9014</author><pubDate>Fri, 01 May 2015 16:42:06 +0800</pubDate><description><![CDATA[1.性能分析的目的
1）找出系统性能瓶颈（包括硬件瓶颈和软件瓶颈）；
2）提供性能优化的方案（升级硬件？改进系统系统结构？）；
3）达到合理的硬件和软件配置；
4）使系统资源使用达到最大的平衡。（一般情况下系统良好运行的...]]></description><category></category></item><item><title><![CDATA[Netapp存储日常检查及信息收集]]></title><link>https://blog.youkuaiyun.com/cuixiuyin9014/article/details/100464391</link><guid>https://blog.youkuaiyun.com/cuixiuyin9014/article/details/100464391</guid><author>cuixiuyin9014</author><pubDate>Fri, 01 May 2015 16:05:01 +0800</pubDate><description><![CDATA[一、netapp存储信息及配置检查

1.查看存储控制器版本
&gt; version
NetApp Release 8.0.5 7-Mode: Sun Jan 20 21:53:54 PST 2013

2.查看存...]]></description><category></category></item><item><title><![CDATA[Oracle内部视图：X$BH与X$LE]]></title><link>https://blog.youkuaiyun.com/cuixiuyin9014/article/details/100464367</link><guid>https://blog.youkuaiyun.com/cuixiuyin9014/article/details/100464367</guid><author>cuixiuyin9014</author><pubDate>Tue, 31 Mar 2015 15:32:27 +0800</pubDate><description><![CDATA[X$LE:Defined in the KCL layer - [K]ernel [C]ache [L]ock - [L]ock [E]lement

Column     Type       ...]]></description><category></category></item><item><title><![CDATA[ORA-01017 ORA-02063 WHILE CONNECTING FROM 10G TO 11G VIA PUBLIC DBLINK]]></title><link>https://blog.youkuaiyun.com/cuixiuyin9014/article/details/100464431</link><guid>https://blog.youkuaiyun.com/cuixiuyin9014/article/details/100464431</guid><author>cuixiuyin9014</author><pubDate>Wed, 11 Feb 2015 17:04:02 +0800</pubDate><description><![CDATA[测试平台介绍：

服务器1：ora10g  10.2.0.1
服务器2：ora11g  11.2.0.1
 
测试1：在ora11g上建立dblink访问ora10g上的表t1。
 
[oracle@o...]]></description><category></category></item><item><title><![CDATA[数据库Patchsets 补丁号码快速参考]]></title><link>https://blog.youkuaiyun.com/cuixiuyin9014/article/details/100464361</link><guid>https://blog.youkuaiyun.com/cuixiuyin9014/article/details/100464361</guid><author>cuixiuyin9014</author><pubDate>Wed, 24 Dec 2014 15:38:46 +0800</pubDate><description><![CDATA[11.2.0.4
				
			
		
		
			
				Description
			
			
				PSU
			
			
				...]]></description><category></category></item><item><title><![CDATA[Linux CPU实时监控命令mpstat介绍]]></title><link>https://blog.youkuaiyun.com/cuixiuyin9014/article/details/100464365</link><guid>https://blog.youkuaiyun.com/cuixiuyin9014/article/details/100464365</guid><author>cuixiuyin9014</author><pubDate>Wed, 05 Nov 2014 10:34:13 +0800</pubDate><description><![CDATA[1,简介
   mpstat是Multiprocessor Statistics的缩写，是实时系统监控工具。其报告是CPU的一些统计信息，这些信息存放在/proc/stat文件中。在多CPUs系统里，其不但能查看所有...]]></description><category></category></item><item><title><![CDATA[Oracle 11gR2中HR用户安装说明]]></title><link>https://blog.youkuaiyun.com/cuixiuyin9014/article/details/100464363</link><guid>https://blog.youkuaiyun.com/cuixiuyin9014/article/details/100464363</guid><author>cuixiuyin9014</author><pubDate>Tue, 04 Nov 2014 10:31:55 +0800</pubDate><description><![CDATA[1,脚本放在这个目录下
$ORACLE_HOME/demo/schema/human_resources      
hr_analz.sql 
hr_code.sql 
hr_comnt.sql ...]]></description><category></category></item><item><title><![CDATA[复合索引中前导列对sql查询的影响]]></title><link>https://blog.youkuaiyun.com/cuixiuyin9014/article/details/100464359</link><guid>https://blog.youkuaiyun.com/cuixiuyin9014/article/details/100464359</guid><author>cuixiuyin9014</author><pubDate>Tue, 21 Oct 2014 15:59:50 +0800</pubDate><description><![CDATA[[oracle@ora10g ~]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Oct 21 14:35:56 2014
Copyri...]]></description><category></category></item><item><title><![CDATA[profile对密码的限制]]></title><link>https://blog.youkuaiyun.com/cuixiuyin9014/article/details/100464290</link><guid>https://blog.youkuaiyun.com/cuixiuyin9014/article/details/100464290</guid><author>cuixiuyin9014</author><pubDate>Tue, 21 Oct 2014 15:12:04 +0800</pubDate><description><![CDATA[今天在登录测试系统时，发现下面的报错。

oracle@ora10g ~]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Oct 21 1...]]></description><category></category></item><item><title><![CDATA[AWR数据的导出与导入]]></title><link>https://blog.youkuaiyun.com/cuixiuyin9014/article/details/100464360</link><guid>https://blog.youkuaiyun.com/cuixiuyin9014/article/details/100464360</guid><author>cuixiuyin9014</author><pubDate>Mon, 22 Sep 2014 10:57:17 +0800</pubDate><description><![CDATA[有时候在生产系统上分析AWR不太方便，这就需要把生产系统的AWR信息收集下来，然后导入到其他的测试机器，进行进一步的分析。

一，导出AWR信息

SQL&gt; @?/rdbms/admin/awrextr.sql
...]]></description><category></category></item><item><title><![CDATA[在Linux x86-64平台上安装oracle 10gR2]]></title><link>https://blog.youkuaiyun.com/cuixiuyin9014/article/details/100464358</link><guid>https://blog.youkuaiyun.com/cuixiuyin9014/article/details/100464358</guid><author>cuixiuyin9014</author><pubDate>Mon, 01 Sep 2014 16:28:57 +0800</pubDate><description><![CDATA[一,检查硬件需求：

1，物理内存：至少1G的物理内存
2，SWAP分区：（swap分区与物理内存的关系）
  RAM                  Swap Space
...]]></description><category></category></item><item><title><![CDATA[sql优化工具SQLT]]></title><link>https://blog.youkuaiyun.com/cuixiuyin9014/article/details/100464357</link><guid>https://blog.youkuaiyun.com/cuixiuyin9014/article/details/100464357</guid><author>cuixiuyin9014</author><pubDate>Fri, 08 Aug 2014 15:11:04 +0800</pubDate><description><![CDATA[SQLT也叫SQLTXPLAIN，如果某一条SQL执行效率很低，也不知道从哪里下手，可以使用SQLT来收集和性能相关的各种信息(如:Execution plans, Cost-based Optimizer CBO...]]></description><category></category></item><item><title><![CDATA[数据库内存抖动]]></title><link>https://blog.youkuaiyun.com/cuixiuyin9014/article/details/100464348</link><guid>https://blog.youkuaiyun.com/cuixiuyin9014/article/details/100464348</guid><author>cuixiuyin9014</author><pubDate>Mon, 30 Jun 2014 14:44:21 +0800</pubDate><description><![CDATA[在数据库巡检的过程中，发现在AWR报告中（该报告的采集间隔为1小时），两个采集点的Buffer Cache和Shared Pool Size发生了较大变化：

	
		接着查询v$SGA_RESIZE_OPS视图：...]]></description><category></category></item><item><title><![CDATA[使用edit编辑缓冲区中的sql]]></title><link>https://blog.youkuaiyun.com/cuixiuyin9014/article/details/100464352</link><guid>https://blog.youkuaiyun.com/cuixiuyin9014/article/details/100464352</guid><author>cuixiuyin9014</author><pubDate>Mon, 23 Jun 2014 15:08:03 +0800</pubDate><description><![CDATA[1，查看sql缓冲区中缓存的sql语句
SQL&gt; l
 1* select * from dba_tables；

sqlplus刚开始使用edit命令时会如下所示：
SQL&gt; edit
Wrote f...]]></description><category></category></item><item><title><![CDATA[RMAN-06207 and RMAN-06208 deleting RMAN backups]]></title><link>https://blog.youkuaiyun.com/cuixiuyin9014/article/details/100464344</link><guid>https://blog.youkuaiyun.com/cuixiuyin9014/article/details/100464344</guid><author>cuixiuyin9014</author><pubDate>Wed, 18 Jun 2014 16:21:51 +0800</pubDate><description><![CDATA[问题描述，在RMAN备份日志中报如下错误：

RMAN-06207: WARNING: 3 objects could not be deleted for DISK channel(s) due
RMAN-06208: ...]]></description><category></category></item></channel></rss>