<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[itde1的专栏]]></title><description><![CDATA[我们社会的偶然性特别多，仅仅凭自己努力不能获得成功，所以很多人把成果当作神助。在社会的各个领域都可能存在不公平的竞争，因此只能寻求庇护。]]></description><link>https://blog.youkuaiyun.com/itde1</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; itde1]]></copyright><item><title><![CDATA[前滚和回滚的区别 .]]></title><link>https://blog.youkuaiyun.com/itde1/article/details/49534957</link><guid>https://blog.youkuaiyun.com/itde1/article/details/49534957</guid><author>itde1</author><pubDate>Sat, 31 Oct 2015 17:50:13 +0800</pubDate><description><![CDATA[http://blog.youkuaiyun.com/haiross/article/details/17003543
http://www.itpub.net/thread-1713569-3-1.html
经典论坛]]></description><category></category></item><item><title><![CDATA[oracle9]]></title><link>https://blog.youkuaiyun.com/itde1/article/details/49428361</link><guid>https://blog.youkuaiyun.com/itde1/article/details/49428361</guid><author>itde1</author><pubDate>Mon, 26 Oct 2015 19:08:12 +0800</pubDate><description><![CDATA[查看SQL历史执行信息：
SELECT SQL_ST.SQL_ID,PLAN_HASH_VALUE,TO_CHAR(ST.BEGIN_INTERVAL_TIME, 'YYYY-MM-DD HH24:MI:SS') RUN_DATE,ST.SNAP_ID,ST.INSTANCE_NUMBER INS,
       SX.SQL_TEXT,ROUND(SQL_ST.ELAPSED_TIME_DE]]></description><category></category></item><item><title><![CDATA[oracle 8]]></title><link>https://blog.youkuaiyun.com/itde1/article/details/49281585</link><guid>https://blog.youkuaiyun.com/itde1/article/details/49281585</guid><author>itde1</author><pubDate>Tue, 20 Oct 2015 19:34:39 +0800</pubDate><description><![CDATA[锁定查询系列...
----------------------------------------
Q: 如何查询哪些进程相互锁定？
A: 执行以下SQL语句
set pages 800
set lines 150
column blocking format a30
column blocked format a30
select 'INST_ID:'||l1.inst_id|]]></description><category></category></item><item><title><![CDATA[oracle 7]]></title><link>https://blog.youkuaiyun.com/itde1/article/details/49281577</link><guid>https://blog.youkuaiyun.com/itde1/article/details/49281577</guid><author>itde1</author><pubDate>Tue, 20 Oct 2015 19:34:02 +0800</pubDate><description><![CDATA[expdp/impdp 杀导出导入后台进程：
--查询后台进程：
SET lines 200
COL owner_name FORMAT a10;
COL job_name FORMAT a20
COL state FORMAT a11
COL operation LIKE state
COL job_mode LIKE state


-- locate Data Pump ]]></description><category></category></item><item><title><![CDATA[oracle 7]]></title><link>https://blog.youkuaiyun.com/itde1/article/details/49281541</link><guid>https://blog.youkuaiyun.com/itde1/article/details/49281541</guid><author>itde1</author><pubDate>Tue, 20 Oct 2015 19:32:34 +0800</pubDate><description><![CDATA[查看磁盘空间&磁盘监控脚本
select name,usable_file_mb/1024 from v$asm_diskgroup;

select 'Diskgroup capacity alert:' alert_reason,i.instance_name,substr(d.name,1,10),d.total_mb,d.free_mb,d.state,d.USABLE_FILE_M]]></description><category></category></item><item><title><![CDATA[oracle 6]]></title><link>https://blog.youkuaiyun.com/itde1/article/details/49281517</link><guid>https://blog.youkuaiyun.com/itde1/article/details/49281517</guid><author>itde1</author><pubDate>Tue, 20 Oct 2015 19:29:26 +0800</pubDate><description><![CDATA[监控事务回滚进度：
select n.USED_UBLK*x.VALUE/1024/1024 ,s.*
  from gv$transaction n, gv$session s,
       v$parameter   x
 where n.INST_ID = s.INST_ID  
   and n.ADDR = s.TADDR   
   and x.name = 'db_bl]]></description><category></category></item><item><title><![CDATA[oracle 4]]></title><link>https://blog.youkuaiyun.com/itde1/article/details/49281507</link><guid>https://blog.youkuaiyun.com/itde1/article/details/49281507</guid><author>itde1</author><pubDate>Tue, 20 Oct 2015 19:28:01 +0800</pubDate><description><![CDATA[临时表空间使用率：
set pages 800
set lines 150
set feedback off
--Total Used
SELECT   A.tablespace_name tablespace, D.mb_total,
         SUM (A.used_blocks * D.block_size)/1024/1024 mb_used,
         D.]]></description><category></category></item><item><title><![CDATA[oracle 3]]></title><link>https://blog.youkuaiyun.com/itde1/article/details/49281489</link><guid>https://blog.youkuaiyun.com/itde1/article/details/49281489</guid><author>itde1</author><pubDate>Tue, 20 Oct 2015 19:27:13 +0800</pubDate><description><![CDATA[查询表空间大小：
SELECT A.TABLESPACE_NAME,
       A.FILENUMBER,
       ROUND(A.TBSCURRENTSIZEINMB/1024, 2) TOTAL_SIZE_G,
       ROUND(B.SEGMENTSIZEINMB/1024, 2) USED_SIZE_G,
       ROUND((A.TBSCURRENTSIZ]]></description><category></category></item><item><title><![CDATA[oracle 2]]></title><link>https://blog.youkuaiyun.com/itde1/article/details/49281477</link><guid>https://blog.youkuaiyun.com/itde1/article/details/49281477</guid><author>itde1</author><pubDate>Tue, 20 Oct 2015 19:25:28 +0800</pubDate><description><![CDATA[停止OS重启时候自动启动CRS(root)：
crsctl disable crs
[root@XXX]# ./crsctl disable crs
CRS-4621: Oracle High Availability Services autostart is disabled.


停止CRS（root）：
/data/oracle/app/11.2.0/grid/bin/crs]]></description><category></category></item><item><title><![CDATA[oracle 命令1]]></title><link>https://blog.youkuaiyun.com/itde1/article/details/49130617</link><guid>https://blog.youkuaiyun.com/itde1/article/details/49130617</guid><author>itde1</author><pubDate>Wed, 14 Oct 2015 22:15:49 +0800</pubDate><description><![CDATA[RMAN恢复进度：
set numwidth 30;
set pagesize 50000;
set lines 200;
alter session set nls_date_format = 'DD-MON-RRRR HH24:MI:SS';
select status,checkpoint_change#,checkpoint_time, resetlogs_change#, re]]></description><category></category></item><item><title><![CDATA[test]]></title><link>https://blog.youkuaiyun.com/itde1/article/details/49126347</link><guid>https://blog.youkuaiyun.com/itde1/article/details/49126347</guid><author>itde1</author><pubDate>Wed, 14 Oct 2015 15:57:43 +0800</pubDate><description><![CDATA[RMAN恢复进度]]></description><category></category></item><item><title><![CDATA[删除归档]]></title><link>https://blog.youkuaiyun.com/itde1/article/details/49102723</link><guid>https://blog.youkuaiyun.com/itde1/article/details/49102723</guid><author>itde1</author><pubDate>Tue, 13 Oct 2015 19:18:16 +0800</pubDate><description><![CDATA[一、直接使用RMAN删除archivelog
RMAN>crosscheck  archivelog all;
RMAN>delete noprompt archivelog until time 'sysdate-3';
删除三天前的归档日志,不经过提示、直接删除。
或者
RMAN>delete archivelog all completed before 'sysdate-3'; ]]></description><category></category></item><item><title><![CDATA[查询，创建，扩充表空间&&impdp--------表空间大全]]></title><link>https://blog.youkuaiyun.com/itde1/article/details/10766515</link><guid>https://blog.youkuaiyun.com/itde1/article/details/10766515</guid><author>itde1</author><pubDate>Sat, 31 Aug 2013 20:27:18 +0800</pubDate><description><![CDATA[查询，创建，扩充表空间&&impdp--------表空间大全]]></description><category></category></item><item><title><![CDATA[Oracle 数据泵使用详解]]></title><link>https://blog.youkuaiyun.com/itde1/article/details/10163171</link><guid>https://blog.youkuaiyun.com/itde1/article/details/10163171</guid><author>itde1</author><pubDate>Wed, 21 Aug 2013 21:59:50 +0800</pubDate><description><![CDATA[数据泵使用EXPDP和IMPDP时应该注意的事项：

EXP和IMP是客户端工具程序，它们既可以在客户端使用，也可以在服务端使用。

EXPDP和IMPDP是服务端的工具程序，他们只能在ORACLE服务端使用，不能在客户端使用。

IMP只适用于EXP导出的文件，不适用于EXPDP导出文件；IMPDP只适用于EXPDP导出的文件，而不适用于EXP导出文件。

expdp或impdp]]></description><category></category></item><item><title><![CDATA[Oracle 数据泵详解]]></title><link>https://blog.youkuaiyun.com/itde1/article/details/10163129</link><guid>https://blog.youkuaiyun.com/itde1/article/details/10163129</guid><author>itde1</author><pubDate>Wed, 21 Aug 2013 21:56:50 +0800</pubDate><description><![CDATA[一、EXPDP和IMPDP使用说明
Oracle Database 10g引入了最新的数据泵(Data Dump)技术，数据泵导出导入(EXPDP和IMPDP)的作用
1）实现逻辑备份和逻辑恢复.
2）在数据库用户之间移动对象.
3）在数据库之间移动对象
4）实现表空间搬移.
 
二、数据泵导出导入与传统导出导入的区别
在10g之前,传统的导出和导入分别使用EXP工具和IMP工具,]]></description><category></category></item><item><title><![CDATA[ORACLE EXPDP命令使用详细]]></title><link>https://blog.youkuaiyun.com/itde1/article/details/10163003</link><guid>https://blog.youkuaiyun.com/itde1/article/details/10163003</guid><author>itde1</author><pubDate>Wed, 21 Aug 2013 21:47:19 +0800</pubDate><description><![CDATA[原文：http://blog.youkuaiyun.com/zftang/article/details/6387325
 
ORACLE EXPDP命令使用详细
相关参数以及导出示例：
 
1. DIRECTORY
指定转储文件和日志文件所在的目录
DIRECTORY=directory_object
Directory_object用于指定目录对象名称.需要注意,目录对象是使用CREATE]]></description><category></category></item><item><title><![CDATA[expdp\impdp及exp\imp]]></title><link>https://blog.youkuaiyun.com/itde1/article/details/10162955</link><guid>https://blog.youkuaiyun.com/itde1/article/details/10162955</guid><author>itde1</author><pubDate>Wed, 21 Aug 2013 21:44:38 +0800</pubDate><description><![CDATA[数据泵文件

原文：http://www.cnblogs.com/lanzi/archive/2011/01/06/1927731.html


expdp介绍
EXPDP命令行选项
1. ATTACH
该选项用于在客户会话与已存在导出作用之间建立关联.语法如下
ATTACH=[schema_name.]job_name
Schema_name用于指定方案名,job_name用]]></description><category></category></item><item><title><![CDATA[查看数据库日志,修改数据库tnsname]]></title><link>https://blog.youkuaiyun.com/itde1/article/details/10032755</link><guid>https://blog.youkuaiyun.com/itde1/article/details/10032755</guid><author>itde1</author><pubDate>Sat, 17 Aug 2013 18:51:09 +0800</pubDate><description><![CDATA[查看数据库日志
看文件大小：du -sh */du - sh m*
最大的最占空间的里面就有日志文件，一层一层的找。

关闭数据库：就是关闭crs
查看数据库相关进程：ps -ef|grep smon
修改数据库tnsname:
修改tnsname.ora
验证是否成功：sqlplus oracle_name/password@数据库名字
若返回连接成功或者密码错误都证明连接成功]]></description><category></category></item><item><title><![CDATA[Oracle打补丁]]></title><link>https://blog.youkuaiyun.com/itde1/article/details/9865151</link><guid>https://blog.youkuaiyun.com/itde1/article/details/9865151</guid><author>itde1</author><pubDate>Fri, 09 Aug 2013 22:07:38 +0800</pubDate><description><![CDATA[打补丁是个技术活。
1、阅读readme
2、先打GI的补丁：
     停掉ＧＩ，Ｈａｓ（high voilable server）
     以grid身份进入到grid的家目录，将OPatch解压到家目录（准确的说是安装目录，家目录和安装目录可以不同）。
     检查opatch版本和opatch lsinventory
     将补丁解压至家目录，(root)改变补丁的所有]]></description><category></category></item><item><title><![CDATA[. .profile（AIX系统）]]></title><link>https://blog.youkuaiyun.com/itde1/article/details/9865077</link><guid>https://blog.youkuaiyun.com/itde1/article/details/9865077</guid><author>itde1</author><pubDate>Fri, 09 Aug 2013 21:52:57 +0800</pubDate><description><![CDATA[linux下创建新的操作系统用户，创建完成后要写环境变量，如何快速的让环境变量生效？
如：oracle用户，修改家目录/home/oracle下的profile里面的环境变量，将ORACLE_HOME赋予一个新值，要想快速生效，可用 .  .profile（注：必须是在cd到本目录下）]]></description><category></category></item></channel></rss>