文章列表
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title> hftable </title>
<meta name="Generator" content="EditPlus">
<meta name="Author ...
oracle常用sql
- 博客分类：
- oracle
查看连接：select * from v$session;
杀连接：alter system kill session 'SID,SERIAL';
oracle 过程、函数、视图检查
- 博客分类：
- oracle
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', 'yyyy-mm');
select 'alter view ORA.'|| object_name || ' compile;' from dba_objects where owner = 'ORA' and object ...
oracle更新统计数据
- 博客分类：
- oracle
dbms_stats.gather_schema_stats(ownname=>'USER',cascade=>TRUE);