oracle
netmail2012
这个作者很懒,什么都没留下…
展开
-
oracle常用sql
查看连接:select * from v$session;杀连接:alter system kill session 'SID,SERIAL';原创 2011-08-18 17:41:37 · 77 阅读 · 0 评论 -
oracle更新统计数据
dbms_stats.gather_schema_stats(ownname=>'USER',cascade=>TRUE);原创 2011-07-08 08:53:10 · 101 阅读 · 0 评论 -
oracle 过程、函数、视图检查
[code="sql"]select 'alter procedure ORA.'|| object_name || ' compile;' from dba_objects where owner = 'ORA' and object_type = 'PROCEDURE' and status = 'INVALID' and created > to_date('2011-03', 'yyy...原创 2011-07-08 11:25:44 · 101 阅读 · 0 评论