- 博客(3)
- 资源 (11)
- 收藏
- 关注
原创 ORACLE 外键禁用
删除所有外键约束 Sql代码 1.select 'alter table '||table_name||' drop constraint '||constraint_name||';' from user_constraints where constraint_type='R' select 'alter table '||table_name||' drop constr...
2012-04-23 17:05:59 111
原创 数据线程监控
select count(*) from v$process; Select count(*) from v$session; select count(*) from v$session where status='ACTIVE'; select sid,serial#,username,program,machine,status from v$session; ...
2012-04-22 11:55:34 157
原创 Oracle监控数据库性能的SQL汇总
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 group by event order by 4; ...
2012-04-21 23:09:47 106
Hibernate_DEV_GUIDE夏昕-.pdf
2009-07-24
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人