<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[maypol的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/maypol</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; maypol]]></copyright><item><title><![CDATA[shell 脚本格式化输出]]></title><link>https://blog.youkuaiyun.com/maypol/article/details/8814607</link><guid>https://blog.youkuaiyun.com/maypol/article/details/8814607</guid><author>maypol</author><pubDate>Wed, 17 Apr 2013 16:28:35 +0800</pubDate><description><![CDATA[printf "%11s:%-10s%12s:%-1s%16s:%-14s\n"  "归属1"      ${strOwn}           "是否已激活"   ${bActiveFlag}       "网络类型"   ${strUserNetType}   
               
%11s 表示第一列占位11个字符,向右看齐
%-10s 表示第二列占位12个字符，向左看齐]]></description><category></category></item><item><title><![CDATA[ant 调用子任务]]></title><link>https://blog.youkuaiyun.com/maypol/article/details/8690527</link><guid>https://blog.youkuaiyun.com/maypol/article/details/8690527</guid><author>maypol</author><pubDate>Tue, 19 Mar 2013 10:32:59 +0800</pubDate><description><![CDATA[---]]></description><category></category></item><item><title><![CDATA[利用redolog日志查看删除的表结构]]></title><link>https://blog.youkuaiyun.com/maypol/article/details/8539405</link><guid>https://blog.youkuaiyun.com/maypol/article/details/8539405</guid><author>maypol</author><pubDate>Thu, 24 Jan 2013 18:30:33 +0800</pubDate><description><![CDATA[SQL> select member from v$logfile;
MEMBER
--------------------------------------------------------------------------------
/home/ora10g/oradata/orcl/redo03.log
/home/ora10g/oradata/orcl/redo02.log]]></description><category></category></item><item><title><![CDATA[oracle恢复已被commit删除的内容]]></title><link>https://blog.youkuaiyun.com/maypol/article/details/8539184</link><guid>https://blog.youkuaiyun.com/maypol/article/details/8539184</guid><author>maypol</author><pubDate>Thu, 24 Jan 2013 17:40:57 +0800</pubDate><description><![CDATA[*1.FLASHBACK QUERY*/ 
--闪回到15分钟前 
select *  from orders  as of timestamp (systimestamp - interval '15' minute)  where ...... 
这里可以使用DAY、SECOND、MONTH替换minute，例如： 
SELECT * FROM orders AS OF TIMESTA]]></description><category></category></item><item><title><![CDATA[数据库常用操作3]]></title><link>https://blog.youkuaiyun.com/maypol/article/details/8529989</link><guid>https://blog.youkuaiyun.com/maypol/article/details/8529989</guid><author>maypol</author><pubDate>Tue, 22 Jan 2013 14:52:05 +0800</pubDate><description><![CDATA[查数据库中表的任n行的记录:
select * from ( select rownum x ,tab.* from tab) where x in (2,3); 
查询出数据库中表大于1000的记录: 
select * from ( select rownum x ,tab.* from tab) where x>1000
如何插入'字
>select '''' from dual;]]></description><category></category></item><item><title><![CDATA[linux释放垃圾内存]]></title><link>https://blog.youkuaiyun.com/maypol/article/details/8528821</link><guid>https://blog.youkuaiyun.com/maypol/article/details/8528821</guid><author>maypol</author><pubDate>Tue, 22 Jan 2013 10:37:54 +0800</pubDate><description><![CDATA[echo 1 > /proc/sys/vm/drop_caches 
echo 2 > /proc/sys/vm/drop_caches 
echo 3 > /proc/sys/vm/drop_caches]]></description><category></category></item><item><title><![CDATA[svn命令下载操作]]></title><link>https://blog.youkuaiyun.com/maypol/article/details/8528778</link><guid>https://blog.youkuaiyun.com/maypol/article/details/8528778</guid><author>maypol</author><pubDate>Tue, 22 Jan 2013 10:31:27 +0800</pubDate><description><![CDATA[set USER=username 
set PASSWD=passwd 
set LOCAL_PATH=%CD% 

rem ***delete*** 
rd /q /s %LOCAL_PATH%\onetrack 

svn checkout --username %USER% --password %PASSWD% --no-auth-cache --force "http:/]]></description><category></category></item><item><title><![CDATA[HP设置终端可以删除字符]]></title><link>https://blog.youkuaiyun.com/maypol/article/details/8276788</link><guid>https://blog.youkuaiyun.com/maypol/article/details/8276788</guid><author>maypol</author><pubDate>Mon, 10 Dec 2012 10:07:19 +0800</pubDate><description><![CDATA[stty erase "^H" kill "^U" intr "^C" echoe]]></description><category></category></item><item><title><![CDATA[修改telnet连接数]]></title><link>https://blog.youkuaiyun.com/maypol/article/details/8269072</link><guid>https://blog.youkuaiyun.com/maypol/article/details/8269072</guid><author>maypol</author><pubDate>Fri, 07 Dec 2012 13:32:11 +0800</pubDate><description><![CDATA[vi /etc/xinetd.d/telnet 
       log_on_failure  += USERID
       instances               = 60
rcxinetd restart]]></description><category></category></item><item><title><![CDATA[虚拟机修改时间]]></title><link>https://blog.youkuaiyun.com/maypol/article/details/8268695</link><guid>https://blog.youkuaiyun.com/maypol/article/details/8268695</guid><author>maypol</author><pubDate>Fri, 07 Dec 2012 11:19:57 +0800</pubDate><description><![CDATA[root登录 

echo 1 > /proc/sys/xen/independent_wallclock 
或 sysctl xen.independent_wallclock = 1]]></description><category></category></item><item><title><![CDATA[扩容磁盘空间]]></title><link>https://blog.youkuaiyun.com/maypol/article/details/8260054</link><guid>https://blog.youkuaiyun.com/maypol/article/details/8260054</guid><author>maypol</author><pubDate>Wed, 05 Dec 2012 15:05:18 +0800</pubDate><description><![CDATA[lvdisplay
lvextend  -L 2048 /dev/datavg/lvora_user_512]]></description><category></category></item><item><title><![CDATA[oracle linux 常用]]></title><link>https://blog.youkuaiyun.com/maypol/article/details/8193890</link><guid>https://blog.youkuaiyun.com/maypol/article/details/8193890</guid><author>maypol</author><pubDate>Sat, 17 Nov 2012 15:17:53 +0800</pubDate><description><![CDATA[修改链接数
show parameter processes
alter system set processes=2000 scope=spfile;
查看连接个数

select count(*) from v$session where status='ACTIVE';


Too many open files in system
echo "9234560">/proc]]></description><category></category></item><item><title><![CDATA[oracle quota]]></title><link>https://blog.youkuaiyun.com/maypol/article/details/8193858</link><guid>https://blog.youkuaiyun.com/maypol/article/details/8193858</guid><author>maypol</author><pubDate>Sat, 17 Nov 2012 15:02:52 +0800</pubDate><description><![CDATA[创建用户导入数据
create user dldb identified by dldb default tablespace DLDATA
grant connect,resource,create view to dldb;
revoke unlimited tablespace from dldb
alter user dldb quota unlimited on DLDATA]]></description><category></category></item><item><title><![CDATA[oracle quota]]></title><link>https://blog.youkuaiyun.com/maypol/article/details/8193875</link><guid>https://blog.youkuaiyun.com/maypol/article/details/8193875</guid><author>maypol</author><pubDate>Sat, 17 Nov 2012 15:02:48 +0800</pubDate><description><![CDATA[创建用户导入数据
create user dldb identified by dldb default tablespace DLDATA
grant connect,resource,create view to dldb;
revoke unlimited tablespace from dldb
alter user dldb quota unlimited on DLDATA]]></description><category></category></item><item><title><![CDATA[awk 函数写法]]></title><link>https://blog.youkuaiyun.com/maypol/article/details/8193844</link><guid>https://blog.youkuaiyun.com/maypol/article/details/8193844</guid><author>maypol</author><pubDate>Sat, 17 Nov 2012 14:56:02 +0800</pubDate><description><![CDATA[tid=1235
filename=ab.txt
awk -F '#'  -v rea_id=${tenantid} -v real_filename=${filename}  '{            

    printf("insert into ab (a1, a2, d3, e4, f5, g6) values (")>>real_filename;
    #1-2]]></description><category></category></item><item><title><![CDATA[bat 截取字符串]]></title><link>https://blog.youkuaiyun.com/maypol/article/details/7948068</link><guid>https://blog.youkuaiyun.com/maypol/article/details/7948068</guid><author>maypol</author><pubDate>Wed, 05 Sep 2012 20:26:02 +0800</pubDate><description><![CDATA[@echo off
set str=123456789
echo 第一个字符为：%str:~0,1%
echo 头两个字符为：%str:~0,2%
echo 头5个字符为：%str:~0,5%
echo 去掉最后一个字符后的字符串为：%str:~0,-1%
echo 去掉最后3个字符后的字符串为：%str:~0,-3%
echo 第4个字符为：%str:~3,1%
echo 第4个及其之后的3个字]]></description><category></category></item><item><title><![CDATA[ant zip打包]]></title><link>https://blog.youkuaiyun.com/maypol/article/details/7700225</link><guid>https://blog.youkuaiyun.com/maypol/article/details/7700225</guid><author>maypol</author><pubDate>Thu, 28 Jun 2012 17:40:09 +0800</pubDate><description><![CDATA[basedir="../../../Common"
           excludes="**/target/**"
      />]]></description><category></category></item><item><title><![CDATA[ant cpoy语句]]></title><link>https://blog.youkuaiyun.com/maypol/article/details/7700205</link><guid>https://blog.youkuaiyun.com/maypol/article/details/7700205</guid><author>maypol</author><pubDate>Thu, 28 Jun 2012 17:33:27 +0800</pubDate><description><![CDATA[]]></description><category></category></item><item><title><![CDATA[ant并行执行打包任务]]></title><link>https://blog.youkuaiyun.com/maypol/article/details/7700169</link><guid>https://blog.youkuaiyun.com/maypol/article/details/7700169</guid><author>maypol</author><pubDate>Thu, 28 Jun 2012 17:24:42 +0800</pubDate><description><![CDATA[]]></description><category></category></item><item><title><![CDATA[maven库上传命令]]></title><link>https://blog.youkuaiyun.com/maypol/article/details/7674126</link><guid>https://blog.youkuaiyun.com/maypol/article/details/7674126</guid><author>maypol</author><pubDate>Mon, 18 Jun 2012 17:47:20 +0800</pubDate><description><![CDATA[mvn deploy:deploy-file-DgroupId=com.xx.ws -DartifactId=BusServiceCommon-Dversion=xxx-SNAPSHOT -Dpackaging=jar -Dname=BxxCommon-Dfile="E:\\jar包\WS\BusServiceCommon.jar"-Durl=http://xxx:8081/nexus/conte]]></description><category></category></item></channel></rss>