<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[cuichanmai5324的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/cuichanmai5324</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; cuichanmai5324]]></copyright><item><title><![CDATA[linux kill 多个进程]]></title><link>https://blog.youkuaiyun.com/cuichanmai5324/article/details/100480310</link><guid>https://blog.youkuaiyun.com/cuichanmai5324/article/details/100480310</guid><author>cuichanmai5324</author><pubDate>Fri, 12 Jul 2019 19:00:06 +0800</pubDate><description><![CDATA[比如kill vi 进程ps -ef|grep vi|grep -v grep|cut -c 9-15|xargs kill -9
                                                ...]]></description><category></category></item><item><title><![CDATA[mysql脚本传递参数]]></title><link>https://blog.youkuaiyun.com/cuichanmai5324/article/details/100480312</link><guid>https://blog.youkuaiyun.com/cuichanmai5324/article/details/100480312</guid><author>cuichanmai5324</author><pubDate>Fri, 12 Jul 2019 12:33:04 +0800</pubDate><description><![CDATA[mysql 没有传递参数的 &amp; 符号，但是可以设置自定义变量，mysql -u root -p -e "set @1:='tabname'; source test.sql;"把语句放在 test.sql 里，同时以 @...]]></description><category></category></item><item><title><![CDATA[perl 获取 日期 yyyy-mm-dd]]></title><link>https://blog.youkuaiyun.com/cuichanmai5324/article/details/100480324</link><guid>https://blog.youkuaiyun.com/cuichanmai5324/article/details/100480324</guid><author>cuichanmai5324</author><pubDate>Wed, 03 Jul 2019 15:36:08 +0800</pubDate><description><![CDATA[#!/usr/local/bin/perl  use   strict;  use   warnings;  my   ($year,$mon,$day)=(localtime)[5,4,3];  $year+=1900;  $...]]></description><category></category></item><item><title><![CDATA[诊断和解决 "Library Cache Pin" Waits一例 (转)]]></title><link>https://blog.youkuaiyun.com/cuichanmai5324/article/details/100480309</link><guid>https://blog.youkuaiyun.com/cuichanmai5324/article/details/100480309</guid><author>cuichanmai5324</author><pubDate>Mon, 01 Jul 2019 21:12:06 +0800</pubDate><description><![CDATA[=========================================================== 作者: xhailiang(http://xhailiang.itpub.net)发表于:2006.11.0...]]></description><category></category></item><item><title><![CDATA[rman复制 数据库 ORA-01405 错误]]></title><link>https://blog.youkuaiyun.com/cuichanmai5324/article/details/100480304</link><guid>https://blog.youkuaiyun.com/cuichanmai5324/article/details/100480304</guid><author>cuichanmai5324</author><pubDate>Sun, 30 Jun 2019 16:33:05 +0800</pubDate><description><![CDATA[RMAN&gt; duplicate target database to testerdb;Starting Duplicate Db at 27-OCT-04using target database controlfile...]]></description><category></category></item><item><title><![CDATA[如何创建plan_table,plustrace 角色]]></title><link>https://blog.youkuaiyun.com/cuichanmai5324/article/details/100480303</link><guid>https://blog.youkuaiyun.com/cuichanmai5324/article/details/100480303</guid><author>cuichanmai5324</author><pubDate>Sun, 30 Jun 2019 11:30:04 +0800</pubDate><description><![CDATA[SQL&gt; connect / as sysdba --创建 plan table SQL&gt; @?rdbmsadminutlxplan SQL&gt; create public synonym plan_table...]]></description><category></category></item><item><title><![CDATA[回滚段管理]]></title><link>https://blog.youkuaiyun.com/cuichanmai5324/article/details/100480321</link><guid>https://blog.youkuaiyun.com/cuichanmai5324/article/details/100480321</guid><author>cuichanmai5324</author><pubDate>Fri, 28 Jun 2019 21:48:06 +0800</pubDate><description><![CDATA[select a.NAME, b.EXTENTS,b.OPTSIZE,b.XACTS,b.WAITSfrom v$rollname a,v$rollstat bwhere a.USN=b.USN --求回滚段正在处理的事务sel...]]></description><category></category></item><item><title><![CDATA[format sql from v$sqltext]]></title><link>https://blog.youkuaiyun.com/cuichanmai5324/article/details/100480323</link><guid>https://blog.youkuaiyun.com/cuichanmai5324/article/details/100480323</guid><author>cuichanmai5324</author><pubDate>Tue, 25 Jun 2019 07:03:10 +0800</pubDate><description><![CDATA[select d.piece piece,decode(substr(upper(ltrim(sqltext,' ')),1,4),                             'SELE', ltrim(sqlte...]]></description><category></category></item><item><title><![CDATA[man 5]]></title><link>https://blog.youkuaiyun.com/cuichanmai5324/article/details/100480301</link><guid>https://blog.youkuaiyun.com/cuichanmai5324/article/details/100480301</guid><author>cuichanmai5324</author><pubDate>Mon, 24 Jun 2019 08:42:05 +0800</pubDate><description><![CDATA[查看 配置文件说明 man -5 /etc/ssh/sshd_config
                                                            
               ...]]></description><category></category></item><item><title><![CDATA[sqlplus 小技巧]]></title><link>https://blog.youkuaiyun.com/cuichanmai5324/article/details/100480298</link><guid>https://blog.youkuaiyun.com/cuichanmai5324/article/details/100480298</guid><author>cuichanmai5324</author><pubDate>Wed, 19 Jun 2019 17:30:06 +0800</pubDate><description><![CDATA[set serveroutput on format wrappedSET SQLBLANKLINES ONsql&gt;select deptno,2 empno,3 ename4 from emp5 where6 #desc...]]></description><category></category></item><item><title><![CDATA[rman 异地恢复]]></title><link>https://blog.youkuaiyun.com/cuichanmai5324/article/details/100480296</link><guid>https://blog.youkuaiyun.com/cuichanmai5324/article/details/100480296</guid><author>cuichanmai5324</author><pubDate>Tue, 18 Jun 2019 17:09:06 +0800</pubDate><description><![CDATA[$ORACLE_SID=prod1$rmanRMAN&gt; startup nomount;startup failed: ORA-01078: failure in processing system parametersL...]]></description><category></category></item><item><title><![CDATA[远程安装gnome]]></title><link>https://blog.youkuaiyun.com/cuichanmai5324/article/details/100480295</link><guid>https://blog.youkuaiyun.com/cuichanmai5324/article/details/100480295</guid><author>cuichanmai5324</author><pubDate>Tue, 18 Jun 2019 10:15:05 +0800</pubDate><description><![CDATA[以centos4.2为例子，#yum grouplist  显示系统已经安装的组件，和可以安装的组件如果系统安装之初采用最小化安装，没有安装xwindow，那么#yum groupinstall "X Window System...]]></description><category></category></item><item><title><![CDATA[出现bad interpreter:No such file or directory的原因及解决]]></title><link>https://blog.youkuaiyun.com/cuichanmai5324/article/details/100480320</link><guid>https://blog.youkuaiyun.com/cuichanmai5324/article/details/100480320</guid><author>cuichanmai5324</author><pubDate>Sat, 15 Jun 2019 13:57:07 +0800</pubDate><description><![CDATA[程序是在一个网站上看到的，我保存下来，大致修改了一下。上传到linux主机运行     chmod +x back     ./back    错误提示如下：    bash: ./back : bad interpreter...]]></description><category></category></item><item><title><![CDATA[null 在排序中的位置定义]]></title><link>https://blog.youkuaiyun.com/cuichanmai5324/article/details/100480293</link><guid>https://blog.youkuaiyun.com/cuichanmai5324/article/details/100480293</guid><author>cuichanmai5324</author><pubDate>Wed, 12 Jun 2019 10:09:08 +0800</pubDate><description><![CDATA[select *from emporder by ename desc nulls first(last)
                                                           ...]]></description><category></category></item><item><title><![CDATA[Database Logoff Trigger as a Data Collector(使用 LogOff触发器收集OWI信息)]]></title><link>https://blog.youkuaiyun.com/cuichanmai5324/article/details/100480300</link><guid>https://blog.youkuaiyun.com/cuichanmai5324/article/details/100480300</guid><author>cuichanmai5324</author><pubDate>Tue, 11 Jun 2019 20:06:06 +0800</pubDate><description><![CDATA[1、创建记录表 create table system.session_event_history   initrans 4 as select b.sid,       b.serial#,       b.username,...]]></description><category></category></item><item><title><![CDATA[oracle10g 时间戳和scn转换]]></title><link>https://blog.youkuaiyun.com/cuichanmai5324/article/details/100480317</link><guid>https://blog.youkuaiyun.com/cuichanmai5324/article/details/100480317</guid><author>cuichanmai5324</author><pubDate>Fri, 07 Jun 2019 20:21:06 +0800</pubDate><description><![CDATA[SELECT current_scn, SCN_TO_TIMESTAMP(current_scn) FROM v$database; select timestamp_to_scn(to_date('20061214 17:18...]]></description><category></category></item><item><title><![CDATA[vi 删除宝典]]></title><link>https://blog.youkuaiyun.com/cuichanmai5324/article/details/100480294</link><guid>https://blog.youkuaiyun.com/cuichanmai5324/article/details/100480294</guid><author>cuichanmai5324</author><pubDate>Thu, 30 May 2019 19:42:03 +0800</pubDate><description><![CDATA[删除操作 :%s/r//g 删除DOS方式的回车^M :%s= *$== 删除行尾空白 :%s/^(.*)n1/1$/ 删除重复行 :%s/^.{-}pdf/new.pdf/ 只是删除第一个pdf :%s/&lt;!--_.{-...]]></description><category></category></item><item><title><![CDATA[solairs 调用历史命令]]></title><link>https://blog.youkuaiyun.com/cuichanmai5324/article/details/100480287</link><guid>https://blog.youkuaiyun.com/cuichanmai5324/article/details/100480287</guid><author>cuichanmai5324</author><pubDate>Mon, 27 May 2019 07:45:06 +0800</pubDate><description><![CDATA[今天用vmware虚拟安装了solaris 10 x86安装过程比较顺利,但是solaris不能像linux那样用调用历史命令但是可以通过下面的设置实现kshset -o vi也可写在用户的.profile中~~~esc+k~~...]]></description><category></category></item><item><title><![CDATA[把sga控制在memory]]></title><link>https://blog.youkuaiyun.com/cuichanmai5324/article/details/100480297</link><guid>https://blog.youkuaiyun.com/cuichanmai5324/article/details/100480297</guid><author>cuichanmai5324</author><pubDate>Sun, 26 May 2019 15:54:06 +0800</pubDate><description><![CDATA[为了防止sga使用swap分区，可以设置参数lock_sga=true
                                                            
                 ...]]></description><category></category></item><item><title><![CDATA[mts]]></title><link>https://blog.youkuaiyun.com/cuichanmai5324/article/details/100480325</link><guid>https://blog.youkuaiyun.com/cuichanmai5324/article/details/100480325</guid><author>cuichanmai5324</author><pubDate>Thu, 23 May 2019 11:39:04 +0800</pubDate><description><![CDATA[select count(*) from v$shared_server =1如果系统可以重新启动，请注释掉初始化参数里面的 dispatchers = ... 这一行如果不能，参考下面如果你在client 通过 tnsname...]]></description><category></category></item></channel></rss>