<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[a5568327的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/a5568327</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; a5568327]]></copyright><item><title><![CDATA[centos7 初始化脚本 (有网络版)]]></title><link>https://blog.youkuaiyun.com/a5568327/article/details/104278396</link><guid>https://blog.youkuaiyun.com/a5568327/article/details/104278396</guid><author>a5568327</author><pubDate>Wed, 12 Feb 2020 14:29:44 +0800</pubDate><description><![CDATA[#!/bin/bash

get_char() {
  SAVEDSTTY=`stty -g`
  stty -echo
  stty cbreak
  dd if=/dev/tty bs=1 count=1 2&gt; /dev/null
  stty -raw
  stty echo
  stty $SAVEDSTTY
}

echo "按任意键开始执行初始化或按Ctrl + C 取消执行....]]></description><category></category></item><item><title><![CDATA[Centos7安装Redis4.0.14 (Yum安装)]]></title><link>https://blog.youkuaiyun.com/a5568327/article/details/103197055</link><guid>https://blog.youkuaiyun.com/a5568327/article/details/103197055</guid><author>a5568327</author><pubDate>Fri, 22 Nov 2019 11:27:24 +0800</pubDate><description><![CDATA[环境准备


#安装编译器.以及wget命令
yum -y install gcc-c++ wget

#使用wget 下载Redis,此处使用的版本是4.0.14
wget http://download.redis.io/releases/redis-4.0.14.tar.gz

安装Redis


#解压下载的Redis包.
tar -zxvf redis-4.0.14.tar.gz

#进...]]></description><category></category></item><item><title><![CDATA[Centos7.TPC-H生成数据导入MySQL.]]></title><link>https://blog.youkuaiyun.com/a5568327/article/details/103154224</link><guid>https://blog.youkuaiyun.com/a5568327/article/details/103154224</guid><author>a5568327</author><pubDate>Wed, 20 Nov 2019 21:44:44 +0800</pubDate><description><![CDATA[环境准备:

1.Centos系统.

2.安装Mysql5.7

3.从http://www.tpc.org/tpc_documents_current_versions/current_specifications.asp下载TPC-H的.zip文件.(本文使用的为TPC-H 2.18.0 版本).



4.将 .zip文件传至Centos.进行解压. (未找到unzip命令,可以使用yu...]]></description><category></category></item><item><title><![CDATA[微信公众平台开发遇到的问题记录.不定时更新.]]></title><link>https://blog.youkuaiyun.com/a5568327/article/details/78762756</link><guid>https://blog.youkuaiyun.com/a5568327/article/details/78762756</guid><author>a5568327</author><pubDate>Sun, 10 Dec 2017 00:35:54 +0800</pubDate><description><![CDATA[1.JS-SDK校验遇到的问题
   1.1 https://mp.weixin.qq.com/debug/cgi-bin/sandbox?t=jsapisign 在这个网站上 填写参数生成的 signature 和代码生成的 signature 是一致的.

但是就提示 config:invalid signature 
原因是因为担心乱码把url在ajax传到java后台时,encod]]></description><category></category></item><item><title><![CDATA[oracle 常用sql记录.]]></title><link>https://blog.youkuaiyun.com/a5568327/article/details/78423110</link><guid>https://blog.youkuaiyun.com/a5568327/article/details/78423110</guid><author>a5568327</author><pubDate>Thu, 02 Nov 2017 11:30:52 +0800</pubDate><description><![CDATA[以下是在实际开发,运维系统时可能用到的SQL.不定期更新.


1.查询已经删除的表
select object_name,original_name,partition_name,type,ts_name,createtime,droptime from recyclebin;

2.还原已经删除的表
flashback table 这里写表名 to before drop;]]></description><category></category></item><item><title><![CDATA[oracle系统表v$session、v$sql字段说明（转）]]></title><link>https://blog.youkuaiyun.com/a5568327/article/details/78423021</link><guid>https://blog.youkuaiyun.com/a5568327/article/details/78423021</guid><author>a5568327</author><pubDate>Thu, 02 Nov 2017 11:23:30 +0800</pubDate><description><![CDATA[1、查一下这些视图的定义你就能理解，它们的源都是一个。
SELECT view_definition FROM v$fixed_view_definition        WHERE view_name='GV$SQL';
SELECT view_definition FROM v$fixed_view_definition        WHERE view_name='GV$SQL_AR]]></description><category></category></item><item><title><![CDATA[oracle 一些性能查询SQL]]></title><link>https://blog.youkuaiyun.com/a5568327/article/details/78421654</link><guid>https://blog.youkuaiyun.com/a5568327/article/details/78421654</guid><author>a5568327</author><pubDate>Thu, 02 Nov 2017 10:06:05 +0800</pubDate><description><![CDATA[-- 总消耗时间最多的前10条SQL语句
SELECT *
  FROM (SELECT V.SQL_ID,
               V.CHILD_NUMBER,
               V.SQL_TEXT,
               V.ELAPSED_TIME,
               V.CPU_TIME,
               V.DISK_]]></description><category></category></item><item><title><![CDATA[oracle 锁表解锁]]></title><link>https://blog.youkuaiyun.com/a5568327/article/details/73743336</link><guid>https://blog.youkuaiyun.com/a5568327/article/details/73743336</guid><author>a5568327</author><pubDate>Mon, 26 Jun 2017 18:22:32 +0800</pubDate><description><![CDATA[1. 查锁表
SELECT p.spid, a.serial#, c.object_name, b.session_id, b.oracle_username,b.os_user_name
 FROM v$process p, v$session a, v$locked_object b, all_objects c
 WHERE p.addr = a.paddr 
 AND a.proc]]></description><category></category></item></channel></rss>