<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[csdn426523的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/csdn426523</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; csdn426523]]></copyright><item><title><![CDATA[oracle中 connect by prior 递归算法 （转）]]></title><link>https://blog.youkuaiyun.com/csdn426523/article/details/100321365</link><guid>https://blog.youkuaiyun.com/csdn426523/article/details/100321365</guid><author>csdn426523</author><pubDate>Fri, 10 Mar 2017 10:25:35 +0800</pubDate><description><![CDATA[oracle中 connect by prior 递归算法 

Oracle中start with...connect by prior子句用法 connect by 是结构化查询中用到的，其基本语法是： 
select ...]]></description><category></category></item><item><title><![CDATA[安装psutil模块报错的解决方法]]></title><link>https://blog.youkuaiyun.com/csdn426523/article/details/100321420</link><guid>https://blog.youkuaiyun.com/csdn426523/article/details/100321420</guid><author>csdn426523</author><pubDate>Tue, 24 Jan 2017 15:29:13 +0800</pubDate><description><![CDATA['*' token
 psutil/_psutil_linux.c:190: error: expected '=', ',', ';', 'asm' or '__attribute__' before '*' ...]]></description><category></category></item><item><title><![CDATA[实战存储过程调度过程]]></title><link>https://blog.youkuaiyun.com/csdn426523/article/details/100321370</link><guid>https://blog.youkuaiyun.com/csdn426523/article/details/100321370</guid><author>csdn426523</author><pubDate>Thu, 21 Jul 2016 17:14:08 +0800</pubDate><description><![CDATA[实行功能


	1.可以按流程执行存储


	2.如果中间某一个过程执行错误会立即退出流程


	3.在次执行时候会从错误过程里面继续往下跑


	4.会把调度job...]]></description><category></category></item><item><title><![CDATA[异常处理过程]]></title><link>https://blog.youkuaiyun.com/csdn426523/article/details/100321364</link><guid>https://blog.youkuaiyun.com/csdn426523/article/details/100321364</guid><author>csdn426523</author><pubDate>Mon, 04 Jul 2016 15:07:55 +0800</pubDate><description><![CDATA[有问题过程会比执行三次还是不行就会停止执行
create or replace procedure exception_procedure is
cursor log_data is select m.pro_name f...]]></description><category></category></item><item><title><![CDATA[分区管理过程]]></title><link>https://blog.youkuaiyun.com/csdn426523/article/details/100321366</link><guid>https://blog.youkuaiyun.com/csdn426523/article/details/100321366</guid><author>csdn426523</author><pubDate>Mon, 04 Jul 2016 15:05:57 +0800</pubDate><description><![CDATA[一次性添加一年分区
保留当前表20天数据，20天后数据事实被交换到历史表
保留分区表2个月数据






	


	create or replace procedure manage_p...]]></description><category></category></item><item><title><![CDATA[ORA-19606: Cannot copy or restore to snapshot control file]]></title><link>https://blog.youkuaiyun.com/csdn426523/article/details/100321361</link><guid>https://blog.youkuaiyun.com/csdn426523/article/details/100321361</guid><author>csdn426523</author><pubDate>Wed, 25 May 2016 15:12:51 +0800</pubDate><description><![CDATA[ORA-19606: Cannot copy or restore to snapshot control file

1. Set new name (or location) for RMAN to use for s...]]></description><category></category></item><item><title><![CDATA[Linux发邮件磁盘空间监控]]></title><link>https://blog.youkuaiyun.com/csdn426523/article/details/100321368</link><guid>https://blog.youkuaiyun.com/csdn426523/article/details/100321368</guid><author>csdn426523</author><pubDate>Wed, 03 Feb 2016 08:56:42 +0800</pubDate><description><![CDATA[Linux发邮件磁盘空间监控
#!/usr/bin/python
# -*- coding: UTF-8 -*-


import smtplib
import os
import commands,time
...]]></description><category></category></item><item><title><![CDATA[LINUX 自动备份程序日志(shell)]]></title><link>https://blog.youkuaiyun.com/csdn426523/article/details/100321357</link><guid>https://blog.youkuaiyun.com/csdn426523/article/details/100321357</guid><author>csdn426523</author><pubDate>Wed, 06 Jan 2016 14:45:09 +0800</pubDate><description><![CDATA[定期备份脚本案列
用tar压缩7天前日志
删除7天压缩完日志
删除压缩完356天前日志

#！/bin/bash
#delete expire log
#script name drop_log
#script ...]]></description><category></category></item><item><title><![CDATA[STANDBY DATABSE UNDO ERROR(ORA-10564、ORA-10567、ORA-01110）]]></title><link>https://blog.youkuaiyun.com/csdn426523/article/details/100321416</link><guid>https://blog.youkuaiyun.com/csdn426523/article/details/100321416</guid><author>csdn426523</author><pubDate>Tue, 15 Dec 2015 12:43:52 +0800</pubDate><description><![CDATA[standby database trace log
Tue Dec 15 10:19:43 2015
alter database recover managed standby database using curren...]]></description><category></category></item><item><title><![CDATA[ORACLE百万数据导入导出解决方法（LOADER、UTL_FILE）]]></title><link>https://blog.youkuaiyun.com/csdn426523/article/details/100321360</link><guid>https://blog.youkuaiyun.com/csdn426523/article/details/100321360</guid><author>csdn426523</author><pubDate>Thu, 12 Nov 2015 14:45:23 +0800</pubDate><description><![CDATA[Oracle 的SQL*LOADER可以将外部数据加载到数据库表中。下面是SQL*LOADER的基本特点：
1）能装入不同数据类型文件及多个数据文件的数据
2）可装入固定格式，自由定界以及可度长格式的数据
3）可以装入...]]></description><category></category></item><item><title><![CDATA[邮件告警中心]]></title><link>https://blog.youkuaiyun.com/csdn426523/article/details/100321356</link><guid>https://blog.youkuaiyun.com/csdn426523/article/details/100321356</guid><author>csdn426523</author><pubDate>Sat, 17 Oct 2015 14:21:33 +0800</pubDate><description><![CDATA[-- Create table
告警中心功能有
1.发送时间
2.邮件发送次数
3.批量发送邮件
4.可以查看已经发送次数




这个参数表
create table WARNING_PARAMETER...]]></description><category></category></item><item><title><![CDATA[ORA-28002: the password will expire解决方法]]></title><link>https://blog.youkuaiyun.com/csdn426523/article/details/100321358</link><guid>https://blog.youkuaiyun.com/csdn426523/article/details/100321358</guid><author>csdn426523</author><pubDate>Sat, 17 Oct 2015 08:52:32 +0800</pubDate><description><![CDATA[[oracle@fj ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Sat Oct 17 08:42:43 2015

Cop...]]></description><category></category></item><item><title><![CDATA[RMAN 解决（RMAN-06208，RMAN-06207，ORA-19606）删除过期文件问题]]></title><link>https://blog.youkuaiyun.com/csdn426523/article/details/100321362</link><guid>https://blog.youkuaiyun.com/csdn426523/article/details/100321362</guid><author>csdn426523</author><pubDate>Fri, 14 Aug 2015 12:25:07 +0800</pubDate><description><![CDATA[RMAN 解决（RMAN-06208，RMAN-06207，ORA-19606）删除过期文件问题

-
RMAN&gt; Delete noprompt obsolete;
RMAN retention policy w...]]></description><category></category></item><item><title><![CDATA[linux 性能调优参数]]></title><link>https://blog.youkuaiyun.com/csdn426523/article/details/100321349</link><guid>https://blog.youkuaiyun.com/csdn426523/article/details/100321349</guid><author>csdn426523</author><pubDate>Fri, 07 Aug 2015 12:27:10 +0800</pubDate><description><![CDATA[linux 性能调优参数

1.drop_caches 
drop_caches

向/proc/sys/vm/drop_caches文件中写入数值可以使内核释放page cache，dentries和inodes缓存...]]></description><category></category></item><item><title><![CDATA[(library cache load lock)cpu占用高]]></title><link>https://blog.youkuaiyun.com/csdn426523/article/details/100321363</link><guid>https://blog.youkuaiyun.com/csdn426523/article/details/100321363</guid><author>csdn426523</author><pubDate>Mon, 03 Aug 2015 13:46:41 +0800</pubDate><description><![CDATA[监控操作发现cpu被占用比较高百分97左右，运行进程队列等待严重，这说明cpu负载很高然后进一步分析


	Vmstat 2


	



	Top看到oracle服务器占用比较高cpu

...]]></description><category></category></item><item><title><![CDATA[TCP洪水攻击（SYN_SENT）的诊断和处理]]></title><link>https://blog.youkuaiyun.com/csdn426523/article/details/100321346</link><guid>https://blog.youkuaiyun.com/csdn426523/article/details/100321346</guid><author>csdn426523</author><pubDate>Thu, 30 Jul 2015 12:33:22 +0800</pubDate><description><![CDATA[TCP洪水攻击（SYN_SENT）的诊断和处理

SYN攻击原理
SYN攻击属于DOS攻击的一种,它利用TCP协议缺陷,通过发送大量的半连接请求,耗费服务器CPU和内存资源.SYN攻击聊了能影响主机外,还可以危 害路由器,...]]></description><category></category></item><item><title><![CDATA[(Datagurad)监控脚本]]></title><link>https://blog.youkuaiyun.com/csdn426523/article/details/100321355</link><guid>https://blog.youkuaiyun.com/csdn426523/article/details/100321355</guid><author>csdn426523</author><pubDate>Sat, 25 Jul 2015 12:05:33 +0800</pubDate><description><![CDATA[dg监控脚本
功能

	邮箱告警，primary服务器宕机，数据库被关闭，datagurad服务器不同步standby就会发起告警邮件


#!/bin/bash
if [ -f ~/.bashrc ]; then...]]></description><category></category></item><item><title><![CDATA[oracle定期清空回收过程]]></title><link>https://blog.youkuaiyun.com/csdn426523/article/details/100321345</link><guid>https://blog.youkuaiyun.com/csdn426523/article/details/100321345</guid><author>csdn426523</author><pubDate>Sat, 25 Jul 2015 11:55:47 +0800</pubDate><description><![CDATA[创建job调度过程实现自动化

当回收站记录达到200记录，就开始清空回收站
create or replace procedure clear_recyclebin is

recy_count number(9);...]]></description><category></category></item><item><title><![CDATA[Oracle自动添加数据文件过程]]></title><link>https://blog.youkuaiyun.com/csdn426523/article/details/100321342</link><guid>https://blog.youkuaiyun.com/csdn426523/article/details/100321342</guid><author>csdn426523</author><pubDate>Sat, 25 Jul 2015 11:53:11 +0800</pubDate><description><![CDATA[创建一个JOB定期执行以下过程就可以自动添加数据文件
当表空间使用90%触发过程添加数据文件，数据文件时按日期生成

create or replace procedure auto_add_datafile is

...]]></description><category></category></item><item><title><![CDATA[（OEL 6.3） Mysql6.5二进制安装]]></title><link>https://blog.youkuaiyun.com/csdn426523/article/details/100321352</link><guid>https://blog.youkuaiyun.com/csdn426523/article/details/100321352</guid><author>csdn426523</author><pubDate>Thu, 23 Jul 2015 13:56:10 +0800</pubDate><description><![CDATA[操作系统
Oracle Linux Server release 6.3

数据库
Mysql5.6

#添加mysql用户和组
[root@localhost app]# groupadd mysql

[r...]]></description><category></category></item></channel></rss>