oracle
yanglei031
这个作者很懒,什么都没留下…
展开
-
转:Oracle系统非空闲等待事件
select sid, p1, p1raw, p2, p2raw, p3, p3raw, wait_time, seconds_in_wait, state, event, sysdate from v$session_wait where event not in原创 2010-02-04 21:55:00 · 1564 阅读 · 0 评论 -
oracle调用java
create or replace and compile java source named md5util asimport java.security.MessageDigest;public class MD5Util{ public static String encrypt(String s) { char hexDigits[] = {0, 1, 2,转载 2010-05-27 20:39:00 · 371 阅读 · 0 评论 -
【转载】oracle性能检测sql语句
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转载 2011-08-16 10:38:33 · 437 阅读 · 0 评论 -
group by
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原创 2013-08-10 16:15:27 · 648 阅读 · 0 评论 -
查看sql
select event,count(*) from v$session_wait where wait_classselect * from v$rollstat;select p1,p2,p3, a.* from v$session a where a.event='db file sequential read';select * from v$sql w转载 2014-01-07 15:03:02 · 522 阅读 · 0 评论 -
ora00257处理方法
su - oraclesqlplus /nologconn as sysdbaora-00257一般这样的问题你用 df -k看一下磁盘是否满了4、 定期用#df –g 查看/oradata目录空间,若发现将满空间,用以下命令处理:oracle 归档日志满处理方法如下 #su - oracle$rman target /原创 2014-10-06 18:01:55 · 1041 阅读 · 0 评论