KIN ORACLE

原创 解构数据可视化

什么是数据可视化数据可视化的目标是透过数据的表象，洞悉其中的规律，指导用户高效、准确地进行决策。数据可视化四大过程一个完整的数据可视化过程，主要有以下四个步骤:确定主题提炼数据确定图表可视化设计及布局1. 确定主题数据可视化的主体，数据可视化要表达的主题及目的。一个具体问题、业务、战略目标，都可用是一个数据可视化的主题。举例:电商平台双十一大屏成交额、订单数、物流包...

原创 SSH免密码登陆避免首次需要输入yes

ssh -o stricthostkeychecking=no

原创 Shell Cheatsheet

批量替换文件名:find /dir -name 'a*' | xargs -i echo mv {} {} | sed 's/a/b/2' | sh批量替换文件内容sed -i "s/201611/201612/g"  `grep 201611 -rl /dir/` --path or -- file

原创 Solr-删除所有索引

DocumentDocument Type*:*

翻译 Oracle-hugepages_settings.sh

#!/bin/bash## hugepages_settings.sh## Linux bash script to compute values for the# recommended HugePages/HugeTLB configuration# on Oracle Linux## Note: This script does calculation for all sha

转载 Linux-NFS服务安装配置

server&client:yum -y install nfs-utils rpcbindserver:vi /etc/exports #增加一行：/usr/local/test/ 192.168.1.226(rw,no_root_squash,no_all_squash,sync)exportfs -r注：配置文件说明：/usr/

原创 Shell-快速创建大量目录

for (( i=1; i<=365; i++ ))do for (( j=1; j<=100000; j++ )) do mkdir -p $i/$j donedone

原创 Oracle返回表集合函数

create or replace type type_col as object(e varchar2(36 char),n varchar2(100 char));create or replace type type_tab as table of type_col;create or replace function f_return_rowtype(v_id varchar2)

原创 Windows脚本-Tomcat部署WAR

Title WAR Deploy JobREM -----------------------------------------------------------REM Deploy WAR in TomcatREM Date: 2015/8/24REM Version:v1.2REM Author: Kin ZhangREM --------------------------

原创 Solr不区分大小写

schema.xmlschema.xml

原创 ORA-0131:Insufficient privileges

grant debug connect session to kin;

原创 Python执行Shell命令测试脚本

logging.conf[loggers]keys=root[handlers]keys=rotateFileHandler[formatters]keys=logformat[formatter_logformat]format=%(asctime)s - %(name)s - %(levelname)s - %(message)s[logger_root]level=

原创 Linux常用压缩、解压命令

-- 打包压缩find *.log |xargs tar czf jay.tar.gzfind *.log |xargs tar cjf jay.tar.bz2-- 解压tar xvf kin.tar.bz2tar xvf kin.tar.gz-- 解压到指定目录tar xvf kin.tar.bz2 -C /tmp/tar xvf kin.tar.gz -C /tmp/-

转载 ORA-245: In RAC environment from 11.2 onwards Backup Or Snapshot controlfile needs to be in shared l

ORA-245: In RAC environment from 11.2 onwards Backup Or Snapshot controlfile needs to be in shared location (Doc ID 1472171.1)To BottomModified:26-Jun

原创 Python-Bubble Sort

def bubble_sort(bubble_list): list_length = len(bubble_list) while list_length > 0: for i in range(list_length - 1): if bubble_list[i] > bubble_list[i + 1]:

原创 Oracle-多版本环境变量切换

ORACLE_BASE=/home/oracle/appecho "(1) Oracle10g"echo "(2) Oracle11g"read -n1 KEYecho ""case $KEY in1)ORACLE_HOME=$ORACLE_BASE/Oracle10gORACLE_SID=SID;;2)ORACLE_HOME=$ORACLE_BASE/Oracle

原创 Shell-计算多行数值求和

生成文件:touch /tmp/1.log模拟数据:echo 3 > /tmp/1.log echo 2 >> /tmp/1.log echo 1 >> /tmp/1.log 求和:cat /tmp/1.log |awk '{sum+=$1} END {print sum}'

转载 Linux-SAMBA

useradd -M -s /sbin/nologin shera1useradd -M -s /sbin/nologin shera2smbpasswd -a shera1smbpasswd -a shera2step2:准备共享目录（假定共享目录为/share)mkdir -m 755 -Z unconfined_u:object_r:samba_share_t:s0 /s

原创 Shell-Check Redis

REDIS=/usr/local/bin/redis-cliREDIS_STATUS=1CHECK_TIME=3function check_redis_status(){ $REDIS PING >/dev/null 2>&1if [ $? = 0 ];then REDIS_STATUS=1 else REDIS_STATUS=0fi return $REDIS

原创 Python-Redis

pip install redis#!/usr/bin/env python#coding=utf8import redisr = redis.Redis(host='', port=, db=)r.set('kin','kin')r.get('kin')r.dbsize()r.delete('kin')r.dbsize()r.save()r.flushdb

原创 Python(pika)-RabbitMQ

send.py#!/usr/bin/env python#coding=utf8import pikacredentials = pika.PlainCredentials('admin', 'admin')connection = pika.BlockingConnection(parameters = pika.ConnectionParameters('',

原创 Oracle-Procedure LOOP

CREATE OR REPLACE PROCEDURE PROC AS i NUMBER; j NUMBER;BEGIN i := 1; WHILE i <= 100 LOOP dbms_output.put_line(i); i := i + 1; END LOOP; FOR j in 1 .. 100 LOOP dbms_output

原创 Oracle-numtodsinterval&numtoyminterval

select sysdate now,sysdate+numtodsinterval(1,'second') add1second,sysdate+numtodsinterval(1,'minute') add1minute,sysdate+numtodsinterval(1,'hour') add1hour,sysdate+numtodsinterval(1,'day') add1day

原创 Oracle11g(CentOS6)-pdksh

wget http://mirror.centos.org/centos/5/os/x86_64/CentOS/pdksh-5.2.14-37.el5_8.1.x86_64.rpmllrpm -ivh pdksh-5.2.14-37.el5_8.1.x86_64.rpm rpm -e ksh-20120801-21.el6.1.x86_64rpm -ivh pdksh-5.2.14

原创 ORA-01031: insufficient privileges

sqlplus '/as sysdba'show parameter passwordselect * from v$pwfile_users;cd $ORACLE_HOME/dbsorapwdorapwd file=orapwkin entries=10 password=manager

原创 Linux-挂载移动硬盘

Download:http://www.tuxera.com/community/ntfs-3g-download/Installation:cd ntfs-3g_ntfsprogs-2014.2.15./configuremake && make installUsage:mount -t ntfs-3g /dev/sda1 /mnt/wi

原创 Oracle-SQL_TRACE使用

select * from v$session where schemaname='SCOTT';select p.spid  from v$session s, v$process p where s.paddr = p.addr   and s.sid = &1   and s.serial# = &2;   exec dbms_monitor.sessio

原创 Jmeter测试HTTP请求

原创 Linux-清除root密码

1.Linux进入单用户模式,通常选择内核按e 最后添加single,按b进入单用户。2.清除/etc/shadow中root这一行第一个:符号和第二个:符号之间内容。3.正常启动,passwd root修改密码。

原创 Oracle-CURSOR及EXECUTE IMMEDIATE使用

CREATE OR REPLACE PROCEDURE P_REPLACE ISv_sql VARCHAR2(2000);CURSOR cur IS SELECT * FROM user_tab_cols;tableinfo user_tab_cols%rowtype;BEGINOPEN cur;LOOPFETCH cur INTO tableinfo;EXIT WHEN cur

原创 Shell-Linux CRON调用JAR log4j无法输出日志

Shell调用JAR包时,log4j日志无法输出,由于log4j指定为当前文件夹,

原创 Oracle层次查询方式

create table cp(u int,uname int,parentid int);

原创 Python-Excel+Oracle

import xlrdimport cx_Oracle""" all indexs's number in excel begin with 0"""__excel = xlrd.open_workbook(r"E:\areaid_list.xlsx")__table = __excel.sheet_by_index(0) __data = __table.col_values

原创 MySQL-lock table thread

kill mysql lock table thread

原创 Shell- PS1

export PS1='\n\e[1;37m[\e[m\e[1;32m\u\e[m\e[1;33m@\e[m\e[1;35m\H\e[m \e[4m`pwd`\e[m\e[1;37m]\e[m\e[1;36m\e[m\n\$'

原创 Windows-xcopy用法一则

xcopy KIN\*.* e:\KIN\%date:~0,4%%date:~5,2%%date:~8,2%%time:~0,2%%time:~3,2%%time:~6,2%\ /Y

原创 CentOS安装Pymongo

wget https://pypi.python.org/packages/source/p/pymongo/pymongo-2.7.tar.gztar xvf pymongo-2.7.tar.gz cd pymongo-2.7python setup.py install

原创 CentOS安装python-pip

wget https://pypi.python.org/packages/2.6/s/setuptools/setuptools-0.6c11-py2.6.eggchmod +x setuptools-0.6c11-py2.6.egg sh setuptools-0.6c11-py2.6.egg wget http://pypi.python.org/packages/sou

原创 MySQL mysqldump小记

mysqldump -uroot -p -d db > db.sql #导出数据库表结构mysqldump -uroot -p -d db tab > db.sql #导出某张表的结构mysqldump -uroot -p db > db.sql #导出数据库所有表结构及数据mysqldump -uroot -p db tab >db.sql #导出数据库某张

原创 SQL Server管理

-- 查看blockingselect spid, blocked, loginame, last_batch, status, cmd, hostname, program_namefrom sysprocesseswhere spid in( select blocked from sysprocesses where blocked 0)