<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[yanglei031的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/yanglei031</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; yanglei031]]></copyright><item><title><![CDATA[ora00257处理方法]]></title><link>https://blog.youkuaiyun.com/yanglei031/article/details/39830193</link><guid>https://blog.youkuaiyun.com/yanglei031/article/details/39830193</guid><author>yanglei031</author><pubDate>Mon, 06 Oct 2014 18:01:55 +0800</pubDate><description><![CDATA[su - oracle
sqlplus /nolog
conn as sysdba




ora-00257


一般这样的问题你用 df -k看一下磁盘是否满了


4、 定期用#df –g 查看/oradata目录空间，若发现将满空间，用以下命令处理：
oracle 归档日志满处理方法如下 
#su - oracle
$rman target  /      ]]></description><category></category></item><item><title><![CDATA[查看sql]]></title><link>https://blog.youkuaiyun.com/yanglei031/article/details/17959465</link><guid>https://blog.youkuaiyun.com/yanglei031/article/details/17959465</guid><author>yanglei031</author><pubDate>Tue, 07 Jan 2014 15:03:02 +0800</pubDate><description><![CDATA[select event,count(*) from v$session_wait where wait_class




select * from v$rollstat;


select p1,p2,p3, a.* from v$session a where a.event='db file sequential read';
select * from v$sql w]]></description><category></category></item><item><title><![CDATA[group by]]></title><link>https://blog.youkuaiyun.com/yanglei031/article/details/9879375</link><guid>https://blog.youkuaiyun.com/yanglei031/article/details/9879375</guid><author>yanglei031</author><pubDate>Sat, 10 Aug 2013 16:15:27 +0800</pubDate><description><![CDATA[select org, leaseform, sum(fesitmatecapital)
  from (
        
        select a.fesitmatecapital, b.fname_l2 org, c.fname_l2 leaseform
          from t_afl_con_contract a
         inner join t_or]]></description><category></category></item><item><title><![CDATA[sql行列转换]]></title><link>https://blog.youkuaiyun.com/yanglei031/article/details/7674218</link><guid>https://blog.youkuaiyun.com/yanglei031/article/details/7674218</guid><author>yanglei031</author><pubDate>Mon, 18 Jun 2012 18:09:42 +0800</pubDate><description><![CDATA[create table stu1
(
 sname varchar2(10),
 sshow   varchar2(20)
)




insert into stu1 (sname, sshow) values ('张三', '语文90');
insert into stu1 (sname, sshow) values ('张三', '数学50');
insert int]]></description><category></category></item><item><title><![CDATA[在线Form制作]]></title><link>https://blog.youkuaiyun.com/yanglei031/article/details/7270942</link><guid>https://blog.youkuaiyun.com/yanglei031/article/details/7270942</guid><author>yanglei031</author><pubDate>Sun, 19 Feb 2012 00:14:15 +0800</pubDate><description><![CDATA[http://wufoo.com/
http://www.phpform.org]]></description><category></category></item><item><title><![CDATA[velocity工具箱使用]]></title><link>https://blog.youkuaiyun.com/yanglei031/article/details/6939201</link><guid>https://blog.youkuaiyun.com/yanglei031/article/details/6939201</guid><author>yanglei031</author><pubDate>Sat, 05 Nov 2011 20:19:51 +0800</pubDate><description><![CDATA[1.  
class="org.springframework.web.servlet.view.velocity.VelocityViewResolver">

.vm




/WEB-INF/toolbox.xml






2.toolbox.xml
 


import
request
org.apache.velocity.tools.vie]]></description><category></category></item><item><title><![CDATA[右键新增打开cmd窗口]]></title><link>https://blog.youkuaiyun.com/yanglei031/article/details/6824963</link><guid>https://blog.youkuaiyun.com/yanglei031/article/details/6824963</guid><author>yanglei031</author><pubDate>Tue, 27 Sep 2011 09:52:40 +0800</pubDate><description><![CDATA[REGEDIT4
[HKEY_CLASSES_ROOT\*\shell\cmdhere]
@="Cmd&Here"
[HKEY_CLASSES_ROOT\*\shell\cmdhere\command]
@="cmd.exe /c start cmd.exe /k pus]]></description><category></category></item><item><title><![CDATA[ibatis中实现批量操作]]></title><link>https://blog.youkuaiyun.com/yanglei031/article/details/6824954</link><guid>https://blog.youkuaiyun.com/yanglei031/article/details/6824954</guid><author>yanglei031</author><pubDate>Tue, 27 Sep 2011 09:51:07 +0800</pubDate><description><![CDATA[public class SqlMapAccountDao extends SqlMapClientDaoSupport implements AccountDao {
    ...

    public void insertAccount(Account accou]]></description><category></category></item><item><title><![CDATA[如何在不定义VO的情况下返回带map的list结果集]]></title><link>https://blog.youkuaiyun.com/yanglei031/article/details/6824813</link><guid>https://blog.youkuaiyun.com/yanglei031/article/details/6824813</guid><author>yanglei031</author><pubDate>Tue, 27 Sep 2011 09:06:46 +0800</pubDate><description><![CDATA[配置文件写成
 
         select kpi_code,kpi_name from kpi_info where kpi_code like #kpiName#
 
调用如下：
List data = getSqlMapClientTemplate().qu]]></description><category></category></item><item><title><![CDATA[【转载】oracle性能检测sql语句]]></title><link>https://blog.youkuaiyun.com/yanglei031/article/details/6690904</link><guid>https://blog.youkuaiyun.com/yanglei031/article/details/6690904</guid><author>yanglei031</author><pubDate>Tue, 16 Aug 2011 10:38:33 +0800</pubDate><description><![CDATA[1. 监控事例的等待 

select event,sum(decode(wait_Time,0,0,1)) "Prev", 
sum(decode(wait_Time,0,1,0)) "Curr",count(*) "Tot"

from v$session_Wait]]></description><category></category></item><item><title><![CDATA[【转载】java中byte转换int时为何与0xff进行与运算]]></title><link>https://blog.youkuaiyun.com/yanglei031/article/details/6688482</link><guid>https://blog.youkuaiyun.com/yanglei031/article/details/6688482</guid><author>yanglei031</author><pubDate>Mon, 15 Aug 2011 14:55:50 +0800</pubDate><description><![CDATA[在剖析该问题前请看如下代码
public static String bytes2HexString(byte[] b) {
  String ret = "";
  for (int i = 0; i 
   String hex = Integer.toHexStri]]></description><category></category></item><item><title><![CDATA[【转载】md5加密解密]]></title><link>https://blog.youkuaiyun.com/yanglei031/article/details/6688454</link><guid>https://blog.youkuaiyun.com/yanglei031/article/details/6688454</guid><author>yanglei031</author><pubDate>Mon, 15 Aug 2011 14:50:42 +0800</pubDate><description><![CDATA[import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.io.*;
import java.security.*;
import javax.crypto.*;
imp]]></description><category></category></item><item><title><![CDATA[MySQL允许远程访问]]></title><link>https://blog.youkuaiyun.com/yanglei031/article/details/6660021</link><guid>https://blog.youkuaiyun.com/yanglei031/article/details/6660021</guid><author>yanglei031</author><pubDate>Thu, 04 Aug 2011 15:17:03 +0800</pubDate><description><![CDATA[1.update
user set
host = '%' where
user = 'root';
2.GRANT
ALL PRIVILEGES
ON *.*
TO 'root'@'%'
WITH GRANT
OPTION
  FLUSH PRIVILEGES]]></description><category></category></item><item><title><![CDATA[Linux用户配置文件]]></title><link>https://blog.youkuaiyun.com/yanglei031/article/details/6658031</link><guid>https://blog.youkuaiyun.com/yanglei031/article/details/6658031</guid><author>yanglei031</author><pubDate>Wed, 03 Aug 2011 20:50:06 +0800</pubDate><description><![CDATA[/etc/profile 中定义环境变量
/etc/bashrc 中定义针对root用户的一些配置
 
/home/youyou/.bash_profile 中定义针对youyou用户的配置，其他用户也类似
 
如果想要在某个用户登录时就做一些初始化（比如启动某些服务）]]></description><category></category></item><item><title><![CDATA[MySQL备份与恢复]]></title><link>https://blog.youkuaiyun.com/yanglei031/article/details/6657819</link><guid>https://blog.youkuaiyun.com/yanglei031/article/details/6657819</guid><author>yanglei031</author><pubDate>Wed, 03 Aug 2011 19:03:29 +0800</pubDate><description><![CDATA[mysql备份 ： mysqldump -u root -p123 test > /study/mysql/testbak  将数据库test备份到testbak文件
mysql恢复： mysql -u root -p123 test]]></description><category></category></item><item><title><![CDATA[【转载】Linux下安装MySQL]]></title><link>https://blog.youkuaiyun.com/yanglei031/article/details/6657294</link><guid>https://blog.youkuaiyun.com/yanglei031/article/details/6657294</guid><author>yanglei031</author><pubDate>Wed, 03 Aug 2011 17:28:37 +0800</pubDate><description><![CDATA[1、下载MySQL的安装文件
　　安装MySQL需要下面两个文件：
　　MySQL-server-5.0.26-0.i386.rpm
　　MySQL-client-5.0.26-0.i386.rpm
　　下载地址为：http://dev.mysql.com/downloa]]></description><category></category></item><item><title><![CDATA[进程与线程的区别]]></title><link>https://blog.youkuaiyun.com/yanglei031/article/details/6656739</link><guid>https://blog.youkuaiyun.com/yanglei031/article/details/6656739</guid><author>yanglei031</author><pubDate>Wed, 03 Aug 2011 14:10:09 +0800</pubDate><description><![CDATA[进程：
进程就是正在执行的程序
 
线程：
线程可以看成是轻量级的进程
进程有独立的地址空间，线程没有。当一个进程启动后，操作系统会分配相应的内存空间给它
线程不能独立存在，必须由进程创建，linxu下为fork
正常情况下，线程消耗的内存和cpu都小于进程]]></description><category></category></item><item><title><![CDATA[Linux下设置任务调度]]></title><link>https://blog.youkuaiyun.com/yanglei031/article/details/6656095</link><guid>https://blog.youkuaiyun.com/yanglei031/article/details/6656095</guid><author>yanglei031</author><pubDate>Wed, 03 Aug 2011 10:40:28 +0800</pubDate><description><![CDATA[1.编写一个简单的shell命令，生成sh文件
vi myTask.sh:
 
date >> /home/yanglei031/aa.txt
cp /home/yanglei031/aa.txt /home/youyou/
 
2.使用crontab生成任务调度]]></description><category></category></item><item><title><![CDATA[Linux下修改网络设置的三种方式]]></title><link>https://blog.youkuaiyun.com/yanglei031/article/details/6655938</link><guid>https://blog.youkuaiyun.com/yanglei031/article/details/6655938</guid><author>yanglei031</author><pubDate>Wed, 03 Aug 2011 10:05:51 +0800</pubDate><description><![CDATA[1.setup启动配置界面，其中有一个网络设置的选项
 
2.ifconfig etho XXXX 设置ip地址
   ifconfig etho network XXXX设置子网掩码 
 
3.修改配置文件
vi /etc/sysconfig/network-scr]]></description><category></category></item><item><title><![CDATA[Linux下配置Samba]]></title><link>https://blog.youkuaiyun.com/yanglei031/article/details/6655687</link><guid>https://blog.youkuaiyun.com/yanglei031/article/details/6655687</guid><author>yanglei031</author><pubDate>Wed, 03 Aug 2011 09:47:19 +0800</pubDate><description><![CDATA[samba主要用户在linux和window中实现文件共享
 1.创建用户 useradd youyou
2.设置登录密码 passwd youyou
3.生成samba用户：
cat /etc/passwd | mksmbpasswd.sh > /etc/samba/s]]></description><category></category></item></channel></rss>