oracle_script
zxx2403
这个作者很懒,什么都没留下…
展开
-
login.sql
REM turn off the terminal output - make it so SQLPlus does notREM print out anything when we log inset termout offREM default your editor here. SQLPlus has many individual settingsREM Thi转载 2011-06-12 01:32:00 · 467 阅读 · 0 评论 -
show_space
CREATE OR REPLACE PROCEDURE show_space(p_segname IN VARCHAR2, p_owner IN VARCHAR2 DEFAULT USER, p_type IN VAR转载 2011-06-12 01:45:00 · 276 阅读 · 0 评论 -
show_lock.sql
查看锁定select t2.username, t3.owner, t3.object_name, t2.machine, t2.sid as sid, t2.serial#, t2.LA原创 2011-07-04 13:39:02 · 291 阅读 · 0 评论 -
show_locked_sql.sql
--显示产生锁定的sql语句select /*+ NO_MERGE(a) NO_MERGE(b) NO_MERGE(c) */ a.username, a.machine, a.sid,a.serial#, a.last_call_et "Se原创 2011-07-04 13:44:42 · 297 阅读 · 0 评论 -
gettracename.sql
SELECT d.VALUE || / || LOWER (RTRIM (i.INSTANCE, CHR (0))) || _ora_ || p.spid || .trc trace_file_name FROM (SELECT p.spid FROM v$mystat m, v$session s, v$转载 2011-07-02 19:49:25 · 435 阅读 · 0 评论 -
rebuild_indx.sql
REM =============================================================REMREM rebuild_indx.sqlREMREM Copyright (c) Oracle Software, 1998 - 2000REMREM Author : Jurgen SchelfhoutREM转载 2011-07-02 20:00:07 · 532 阅读 · 0 评论 -
recover.sql
column file# format 999column status format 999column error format a10column tablespace_name format a10column datafile format a40c原创 2011-09-28 10:06:11 · 440 阅读 · 0 评论 -
表空间使用率检查脚本
SELECT upper(f.tablespace_name) tablespace_name, d.Tot_grootte_Mb total_Mb, d.Tot_grootte_Mb - f.total_bytes used_Mb,原创 2011-10-12 14:06:58 · 1025 阅读 · 0 评论 -
How can I find which tables reference a given table
select table_name, constraint_name, status, ownerfrom all_constraintswhere r_owner = :r_ownerand constraint_type = 'R'and r_constraint_name in ( select constraint_name from all_constraints转载 2013-01-29 15:34:02 · 506 阅读 · 0 评论