<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[loryliu的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/loryliu</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; loryliu]]></copyright><item><title><![CDATA[(转)tar 解压.zip文件报错解决一例： gzip: stdin has more than one entry--rest ignored]]></title><link>https://blog.youkuaiyun.com/loryliu/article/details/87295634</link><guid>https://blog.youkuaiyun.com/loryliu/article/details/87295634</guid><author>loryliu</author><pubDate>Thu, 14 Feb 2019 20:18:54 +0800</pubDate><description><![CDATA[
1 tar -vxtf adtxxxx.zip

结果报错提示


gzip: stdin has more than one entry--rest ignored
tar: Child returned status 2
tar: Error is not recoverable: exiting now

百思不得其解，还以为自己半瓶子用错了，搜了几个其他配合的参数也不管用。

最后终于发...]]></description><category></category></item><item><title><![CDATA[emca fails with "Database instance is unavailable" though available]]></title><link>https://blog.youkuaiyun.com/loryliu/article/details/79247982</link><guid>https://blog.youkuaiyun.com/loryliu/article/details/79247982</guid><author>loryliu</author><pubDate>Sat, 03 Feb 2018 16:48:02 +0800</pubDate><description><![CDATA[﻿﻿
Fix
| Friday, November 23, 2012



Share




FacebookLinkedInTwitterGoogle PlusEmailComment





emca fails with "Database instance is unavailable" though available

By: 
Giri M]]></description><category></category></item><item><title><![CDATA[IBM developerWorks 上 《Linux环境进程间通信》系列文章链接]]></title><link>https://blog.youkuaiyun.com/loryliu/article/details/78060163</link><guid>https://blog.youkuaiyun.com/loryliu/article/details/78060163</guid><author>loryliu</author><pubDate>Fri, 22 Sep 2017 10:27:50 +0800</pubDate><description><![CDATA[﻿﻿
 分类：
linux文件系统（61） 



作者同类文章X






1. 深刻理解 Linux 进程间通信（IPC）

http://www.ibm.com/developerworks/cn/linux/l-ipc/index.html




2. Linux 环境进程间通信（一）: 管道及有名管道

http://www.ibm.com]]></description><category></category></item><item><title><![CDATA[如何查看所有分区的文件系统类型？]]></title><link>https://blog.youkuaiyun.com/loryliu/article/details/77096565</link><guid>https://blog.youkuaiyun.com/loryliu/article/details/77096565</guid><author>loryliu</author><pubDate>Fri, 11 Aug 2017 13:41:01 +0800</pubDate><description><![CDATA[file -s /dev/sdb1
parted /dev/sdb1]]></description><category></category></item><item><title><![CDATA[Differences and Similarities Between Index Coalesce and Shrink Space]]></title><link>https://blog.youkuaiyun.com/loryliu/article/details/70918597</link><guid>https://blog.youkuaiyun.com/loryliu/article/details/70918597</guid><author>loryliu</author><pubDate>Fri, 28 Apr 2017 16:35:53 +0800</pubDate><description><![CDATA[Differences and Similarities Between Index Coalesce and Shrink Space February 6, 2008 Posted by Richard Foote in

Index Coalesce, 
Index Shrink, 
Oracle General, 
Oracle Indexes, 
Performance Tu]]></description><category></category></item><item><title><![CDATA[Oracle RDBMS: Extracting the Table, Index & View Definitions (DDL) and Indexed Columns]]></title><link>https://blog.youkuaiyun.com/loryliu/article/details/70255324</link><guid>https://blog.youkuaiyun.com/loryliu/article/details/70255324</guid><author>loryliu</author><pubDate>Thu, 20 Apr 2017 10:06:36 +0800</pubDate><description><![CDATA[https://blogs.oracle.com/mandalika/entry/oracle_extracing_the_table_index
(Reproducing a 30 month old blog post from my other blog at blogger. Source URL:
    http://technopark02.blogspot.com/2007/0]]></description><category></category></item><item><title><![CDATA[dba_source存储的内容解释]]></title><link>https://blog.youkuaiyun.com/loryliu/article/details/65934941</link><guid>https://blog.youkuaiyun.com/loryliu/article/details/65934941</guid><author>loryliu</author><pubDate>Sat, 25 Mar 2017 10:19:24 +0800</pubDate><description><![CDATA[什么是dba_source字典视图： 存储所有函数、过程、程序包和Java源的完整的文本，对于你了解一个数据库对象的源代码很有用。存储过程在该视图中是以行为单位进行存储的。dba_source视图中存储的是行为单位拆分的存储过程等对象
如下找到的内容:select * from dba_source where name='SQLPROF_ATTR' and owner='SYS'; owner]]></description><category></category></item><item><title><![CDATA[sql bind capture相关文档]]></title><link>https://blog.youkuaiyun.com/loryliu/article/details/64441149</link><guid>https://blog.youkuaiyun.com/loryliu/article/details/64441149</guid><author>loryliu</author><pubDate>Tue, 21 Mar 2017 14:46:10 +0800</pubDate><description><![CDATA[How To Create a Database SQL Trace Based On Capture Bind Variable For A Session Alone (文档 ID 434437.1)
Not Every Bind Values Captured in  v$sql_bind_capture
 (文档 ID 1370816.1)
Using 
 DBMS_XPLAN.D]]></description><category></category></item><item><title><![CDATA[dba_outlines里的signature理解]]></title><link>https://blog.youkuaiyun.com/loryliu/article/details/61413913</link><guid>https://blog.youkuaiyun.com/loryliu/article/details/61413913</guid><author>loryliu</author><pubDate>Sat, 11 Mar 2017 11:06:22 +0800</pubDate><description><![CDATA[官方文档里的解释：
SIGNATURE RAW(16)  Signature uniquely identifying theoutline SQL text
在11.2.0.4里测试，该signature是忽略sql的大小写及每个单词之间多余的空格。
（测试方式如下：
SQL> alter session set create_stored_outlines =test;
SQL> s]]></description><category></category></item><item><title><![CDATA[How do adaptive cursor sharing and SQL Plan Management interact?]]></title><link>https://blog.youkuaiyun.com/loryliu/article/details/59110703</link><guid>https://blog.youkuaiyun.com/loryliu/article/details/59110703</guid><author>loryliu</author><pubDate>Wed, 01 Mar 2017 16:39:30 +0800</pubDate><description><![CDATA[How do adaptive cursor sharing and SQL Plan Management interact?     
By Allison on 
Feb 11, 2013

We've received a lot of questions about how adaptive cursor sharing (ACS) and SQL plan management]]></description><category></category></item><item><title><![CDATA[How do I force a query to use bind-aware cursor sharing?]]></title><link>https://blog.youkuaiyun.com/loryliu/article/details/59110609</link><guid>https://blog.youkuaiyun.com/loryliu/article/details/59110609</guid><author>loryliu</author><pubDate>Wed, 01 Mar 2017 16:37:19 +0800</pubDate><description><![CDATA[How do I force a query to use bind-aware cursor sharing?     
By Allison on 
Feb 13, 2012

no_BIND_AWARE是恰恰相反的作用
Way back in our 
original post on adaptive cursor sharing, a commenter asked if t]]></description><category></category></item><item><title><![CDATA[Oracle 11g 针对SQL性能的新特性（一）- Adaptive Cursor Sharing]]></title><link>https://blog.youkuaiyun.com/loryliu/article/details/59110539</link><guid>https://blog.youkuaiyun.com/loryliu/article/details/59110539</guid><author>loryliu</author><pubDate>Wed, 01 Mar 2017 16:33:44 +0800</pubDate><description><![CDATA[Oracle 11g 针对SQL性能的新特性（一）- Adaptive Cursor Sharing     
By Roger Song-Oracle on 
十月 03, 2011

    Oracle 11g对SQL执行计划的生成过程做了很多改变，我们经常看到有客户抱怨，数据库在升级到11g以后，执行计划变得很不稳定，甚至难以预测。实际上，Oracle在最新版本中致力于让优化器变得]]></description><category></category></item><item><title><![CDATA[linux less命令简介]]></title><link>https://blog.youkuaiyun.com/loryliu/article/details/57404927</link><guid>https://blog.youkuaiyun.com/loryliu/article/details/57404927</guid><author>loryliu</author><pubDate>Sun, 26 Feb 2017 10:59:29 +0800</pubDate><description><![CDATA[less命令可以对文件或其它输出进行分页显示，与moe命令相似，但是比more命令要强大许多。
在 less 中导航命令类似于 vi，如下：
1 搜索
当使用命令 less file-name 打开一个文件后，可以使用下面的方式在文件中搜索。搜索时整个文本中匹配的部分会被高亮显示。
1) 向前搜索
/ ： 使用一个模式进行搜索，并定位到下一个匹配的文本
n ： 向前查找下一个匹配的文本]]></description><category></category></item><item><title><![CDATA[How to Edit a Stored Outline to Use the Plan from Another Stored Outline (文档 ID 730062.1)]]></title><link>https://blog.youkuaiyun.com/loryliu/article/details/57074458</link><guid>https://blog.youkuaiyun.com/loryliu/article/details/57074458</guid><author>loryliu</author><pubDate>Sat, 25 Feb 2017 09:35:54 +0800</pubDate><description><![CDATA[9876






















文档 ID 



…

 




 

































How to Edit a Stored Outline to Use the Plan from A]]></description><category></category></item><item><title><![CDATA[”parse count (total)" and "session cursor cache hits"关系的文章]]></title><link>https://blog.youkuaiyun.com/loryliu/article/details/56489414</link><guid>https://blog.youkuaiyun.com/loryliu/article/details/56489414</guid><author>loryliu</author><pubDate>Wed, 22 Feb 2017 17:19:43 +0800</pubDate><description><![CDATA[以下相关连接解释了两个参数的关系
 
http://t.askmaclean.com/thread-2229-1-1.html
https://antognini.ch/2013/08/the-broken-statistics-parse-count-total-and-session-cursor-cache-hits/
http://jonathanlewis.wordpress.c]]></description><category></category></item><item><title><![CDATA[Oracle 11g 针对SQL性能的新特性（三）- SQL Plan Management]]></title><link>https://blog.youkuaiyun.com/loryliu/article/details/55510552</link><guid>https://blog.youkuaiyun.com/loryliu/article/details/55510552</guid><author>loryliu</author><pubDate>Fri, 17 Feb 2017 15:04:25 +0800</pubDate><description><![CDATA[SQL Plan Management (SPM)

历史


SQL的执行效率，取决于它的执行计划是否高效。 优化器的算法是一个平衡，需要收集尽量少的信息，用尽量快的速度试图去得到一个最优的执行计划，这也决定了它不是万能的。 所以Oracle提供了一些辅助手段来“修复”优化器可能产生的错误，并不断改进这些方法。 

Oracle 8： hint
Oracle 8i&9: stor]]></description><category></category></item><item><title><![CDATA[Linux Find 命令精通指南]]></title><link>https://blog.youkuaiyun.com/loryliu/article/details/55503997</link><guid>https://blog.youkuaiyun.com/loryliu/article/details/55503997</guid><author>loryliu</author><pubDate>Fri, 17 Feb 2017 08:57:41 +0800</pubDate><description><![CDATA[http://www.oracle.com/technetwork/cn/topics/calish-find-096463-zhs.html
 
 
简单介绍这一无处不在的命令的强大的方面以及混乱的方面。
2008 年 7 月发布
Linux                                 find 命令是所有 Linux 命令中最有用的一个，同时也是最混乱的一个。它很]]></description><category></category></item><item><title><![CDATA[How does SQL Plan Management match SQL statements to SQL plan baselines?]]></title><link>https://blog.youkuaiyun.com/loryliu/article/details/55099924</link><guid>https://blog.youkuaiyun.com/loryliu/article/details/55099924</guid><author>loryliu</author><pubDate>Tue, 14 Feb 2017 15:23:23 +0800</pubDate><description><![CDATA[https://blogs.oracle.com/optimizer/entry/how_does_sql_plan_management
 
 
How does SQL Plan Management match SQL statements to SQL plan baselines?

By Maria Colgan-Oracle on 
Jan 09, 2013

Hap]]></description><category></category></item><item><title><![CDATA[PLAN_HASH_VALUE - How equal (and stable?) are your execution plans - part 1]]></title><link>https://blog.youkuaiyun.com/loryliu/article/details/55099776</link><guid>https://blog.youkuaiyun.com/loryliu/article/details/55099776</guid><author>loryliu</author><pubDate>Tue, 14 Feb 2017 15:19:22 +0800</pubDate><description><![CDATA[http://oracle-randolf.blogspot.tw/2009/07/planhashvalue-how-equal-and-stable-are.html
 
 
Oracle provides in recent releases the PLAN_HASH_VALUE information, which according to the documentation, i]]></description><category></category></item><item><title><![CDATA[Oracle Outlines – aka Plan Stability]]></title><link>https://blog.youkuaiyun.com/loryliu/article/details/54972505</link><guid>https://blog.youkuaiyun.com/loryliu/article/details/54972505</guid><author>loryliu</author><pubDate>Fri, 10 Feb 2017 17:20:16 +0800</pubDate><description><![CDATA[http://kerryosborne.oracle-guy.com/2008/12/oracle-outlines-aka-plan-stability/
Roughly 10 years ago, Oracle introduced a way to lock down execution plans. This was a response to the inherent unpredic]]></description><category></category></item></channel></rss>