<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/clg10028</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; clg10028]]></copyright><item><title><![CDATA[awr报告]]></title><link>https://blog.youkuaiyun.com/clg10028/article/details/100223244</link><guid>https://blog.youkuaiyun.com/clg10028/article/details/100223244</guid><author>clg10028</author><pubDate>Wed, 13 Mar 2019 17:03:43 +0800</pubDate><description><![CDATA[AWR报告








10g以后的数据库中内置了工作负载信息库




   由Memory Monitor(MMON)进程自动捕获工作负载数据




  ...]]></description><category></category></item><item><title><![CDATA[安装11g grid时报错，Failed to create keys in the OLR, rc = 127]]></title><link>https://blog.youkuaiyun.com/clg10028/article/details/100223248</link><guid>https://blog.youkuaiyun.com/clg10028/article/details/100223248</guid><author>clg10028</author><pubDate>Thu, 13 Jul 2017 11:01:23 +0800</pubDate><description><![CDATA[安装11.2.0.4 rac 的grid集群时，到执行/u01/app/11.2.0/grid/root.sh脚本时，报错如下：


	
Performing root user operation for Oracle...]]></description><category></category></item><item><title><![CDATA[linux 安装oracle时swap空间不足]]></title><link>https://blog.youkuaiyun.com/clg10028/article/details/100223268</link><guid>https://blog.youkuaiyun.com/clg10028/article/details/100223268</guid><author>clg10028</author><pubDate>Thu, 13 Jul 2017 09:49:47 +0800</pubDate><description><![CDATA[Linux下增加swap分区大小




	方法一、通过swap文件增加：


	1、创建交换文件



	[root@SOA ~]#dd if=/dev/zero of=/tmp/mem.swa...]]></description><category></category></item><item><title><![CDATA[修改memory内存参数，导致数据库启不来]]></title><link>https://blog.youkuaiyun.com/clg10028/article/details/100223243</link><guid>https://blog.youkuaiyun.com/clg10028/article/details/100223243</guid><author>clg10028</author><pubDate>Thu, 05 Nov 2015 15:59:42 +0800</pubDate><description><![CDATA[这几天新装完一个rac 11g的数据库，安装完成后修改memory内存参数。
重新启动时，遇到如下错误：


	ORA-00845: MEMORY_TARGET not supported on this system...]]></description><category></category></item><item><title><![CDATA[RAC中修改用户组和权限]]></title><link>https://blog.youkuaiyun.com/clg10028/article/details/100223241</link><guid>https://blog.youkuaiyun.com/clg10028/article/details/100223241</guid><author>clg10028</author><pubDate>Wed, 30 Sep 2015 11:33:59 +0800</pubDate><description><![CDATA[usermod -g oinstall -G dba,oper,asmadmin,asmdba,asmoper oracle
usermod -g oinstall -G dba,oper,asmadmin,asmdba,as...]]></description><category></category></item><item><title><![CDATA[查看oracle数据库表空间所在数据文件的高水位]]></title><link>https://blog.youkuaiyun.com/clg10028/article/details/100223242</link><guid>https://blog.youkuaiyun.com/clg10028/article/details/100223242</guid><author>clg10028</author><pubDate>Tue, 29 Sep 2015 13:14:10 +0800</pubDate><description><![CDATA[SELECT *
   FROM (SELECT /*+ ordered use_hash(a,b,c) */
      a.file_id,
      a.file_name,
...]]></description><category></category></item><item><title><![CDATA[查看某表正在被用户使用，连接]]></title><link>https://blog.youkuaiyun.com/clg10028/article/details/100223240</link><guid>https://blog.youkuaiyun.com/clg10028/article/details/100223240</guid><author>clg10028</author><pubDate>Fri, 25 Sep 2015 13:52:18 +0800</pubDate><description><![CDATA[select s.*
from v$locked_object l, dba_objects o, v$session s, v$process p
where l.object_id = o.object_id
and ...]]></description><category></category></item><item><title><![CDATA[Linux下解压命令大全 解压缩 tar bz2 zip tar.gz gz]]></title><link>https://blog.youkuaiyun.com/clg10028/article/details/100223237</link><guid>https://blog.youkuaiyun.com/clg10028/article/details/100223237</guid><author>clg10028</author><pubDate>Thu, 24 Sep 2015 15:59:35 +0800</pubDate><description><![CDATA[.tar
解包：tar xvf FileName.tar
打包：tar cvf FileName.tar DirName
（注：tar是打包，不是压缩！）
———————————————
.gz
解压1：gun...]]></description><category></category></item><item><title><![CDATA[ora-01078报错]]></title><link>https://blog.youkuaiyun.com/clg10028/article/details/100223235</link><guid>https://blog.youkuaiyun.com/clg10028/article/details/100223235</guid><author>clg10028</author><pubDate>Tue, 08 Sep 2015 11:58:23 +0800</pubDate><description><![CDATA[今天早上，把安装数据库时候创建的ORCL实例给删除了，建立了个DB数据库。结果出现：


	ORA-01078 &amp; LRM-00109


	解决方案一：


	
		SQL&gt; conne...]]></description><category></category></item><item><title><![CDATA[expdp导出时遇到ora-12899，ora-02374，ora-02372]]></title><link>https://blog.youkuaiyun.com/clg10028/article/details/100223246</link><guid>https://blog.youkuaiyun.com/clg10028/article/details/100223246</guid><author>clg10028</author><pubDate>Tue, 08 Sep 2015 09:18:27 +0800</pubDate><description><![CDATA[ORA-02374: conversion error loading table "MPJ"."SM_MMS_MTDB"
ORA-12899: value too large for column SUBJECT (actu...]]></description><category></category></item><item><title><![CDATA[设置列宽~]]></title><link>https://blog.youkuaiyun.com/clg10028/article/details/100223233</link><guid>https://blog.youkuaiyun.com/clg10028/article/details/100223233</guid><author>clg10028</author><pubDate>Tue, 21 Jul 2015 17:44:02 +0800</pubDate><description><![CDATA[列宽：col COLNAME format a30;


	行宽：set linesize 1000;

                                                      ...]]></description><category></category></item><item><title><![CDATA[oracle中exp/imp命令详解]]></title><link>https://blog.youkuaiyun.com/clg10028/article/details/100223232</link><guid>https://blog.youkuaiyun.com/clg10028/article/details/100223232</guid><author>clg10028</author><pubDate>Thu, 16 Jul 2015 11:07:56 +0800</pubDate><description><![CDATA[基本语法和实例：
 1、EXP:
 有三种主要的方式（完全、用户、表）
 1、完全：
 EXP SYSTEM/MANAGER BUFFER=64000 FILE=...]]></description><category></category></item><item><title><![CDATA[exp 导出时遇到exp-00091问题]]></title><link>https://blog.youkuaiyun.com/clg10028/article/details/100223230</link><guid>https://blog.youkuaiyun.com/clg10028/article/details/100223230</guid><author>clg10028</author><pubDate>Wed, 01 Jul 2015 18:02:46 +0800</pubDate><description><![CDATA[在我们做exp的过程中可能经常会遇到EXP-00091: Exporting questionable statistics.这样的EXP信息，其实它就是exp的error message，
它产生的原因是因为我们exp工具所...]]></description><category></category></item><item><title><![CDATA[oracle中查看表，表大小，表与用户，表与数据文件]]></title><link>https://blog.youkuaiyun.com/clg10028/article/details/100223231</link><guid>https://blog.youkuaiyun.com/clg10028/article/details/100223231</guid><author>clg10028</author><pubDate>Tue, 30 Jun 2015 14:44:51 +0800</pubDate><description><![CDATA[查询某张表的大小：
select sum(bytes)/1024/1024 "表大小(M)" from user_segments where segment_name='table_name';  --注，仅表数据的...]]></description><category></category></item><item><title><![CDATA[由于开启审计AUD$表导致system表空间满了~]]></title><link>https://blog.youkuaiyun.com/clg10028/article/details/100223234</link><guid>https://blog.youkuaiyun.com/clg10028/article/details/100223234</guid><author>clg10028</author><pubDate>Tue, 30 Jun 2015 11:06:27 +0800</pubDate><description><![CDATA[system表空间不足，增长很快。是由于开启了审计功能。       

 注：转载请注明出处及连接地址


~~~



 



于是进行详细的查询：

查看syste...]]></description><category></category></item><item><title><![CDATA[awr报告中execute to parse 不足40%]]></title><link>https://blog.youkuaiyun.com/clg10028/article/details/100223225</link><guid>https://blog.youkuaiyun.com/clg10028/article/details/100223225</guid><author>clg10028</author><pubDate>Thu, 25 Jun 2015 09:28:30 +0800</pubDate><description><![CDATA[一、
execute to parse=round(100*(1-prse/exe),2)

  round:“四舍六...]]></description><category></category></item><item><title><![CDATA[oracle重做日志组的三种状态：current,active,inactive]]></title><link>https://blog.youkuaiyun.com/clg10028/article/details/100223228</link><guid>https://blog.youkuaiyun.com/clg10028/article/details/100223228</guid><author>clg10028</author><pubDate>Tue, 23 Jun 2015 14:13:21 +0800</pubDate><description><![CDATA[oracle重做日志组的三种状态：current,active,inactive


	current:表示该日志组为当前日志组,oracle正在使用该日志组;


	active:当current redo组...]]></description><category></category></item><item><title><![CDATA[归档日志查看]]></title><link>https://blog.youkuaiyun.com/clg10028/article/details/100223226</link><guid>https://blog.youkuaiyun.com/clg10028/article/details/100223226</guid><author>clg10028</author><pubDate>Tue, 16 Jun 2015 17:31:43 +0800</pubDate><description><![CDATA[show parameter db_recovery;
show parameter db_recovery_file_dest; 查看其值


NAME            TYPE   ...]]></description><category></category></item><item><title><![CDATA[查看表空间，表空间路径，增加表空间]]></title><link>https://blog.youkuaiyun.com/clg10028/article/details/100223221</link><guid>https://blog.youkuaiyun.com/clg10028/article/details/100223221</guid><author>clg10028</author><pubDate>Thu, 11 Jun 2015 15:13:46 +0800</pubDate><description><![CDATA[select * from dba_tablespaces--查看表空间

select tablespace_name,file_id,bytes/1024/1024,file_name
　　 from d...]]></description><category></category></item><item><title><![CDATA[静态、动态监听的配置]]></title><link>https://blog.youkuaiyun.com/clg10028/article/details/100223229</link><guid>https://blog.youkuaiyun.com/clg10028/article/details/100223229</guid><author>clg10028</author><pubDate>Thu, 04 Jun 2015 13:15:08 +0800</pubDate><description><![CDATA[静态监听：
LISTENER =
 (DESCRIPTION_LIST =
  (DESCRIPTION =
   (ADDRESS = (PROTOCOL = TCP)(HOST = MPJ)(PORT =...]]></description><category></category></item></channel></rss>