<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0">
  <channel>
    <title>ORACLE SOS - SQL 脚本</title>
    <link>http://ask.orasos.com/forum-52-1.html</link>
    <description>Latest 20 threads of SQL 脚本</description>
    <copyright>Copyright(C) ORACLE SOS</copyright>
    <generator>Discuz! Board by Comsenz Inc.</generator>
    <lastBuildDate>Wed, 29 Apr 2026 03:31:22 +0000</lastBuildDate>
    <ttl>60</ttl>
    <image>
      <url>http://ask.orasos.com/static/image/common/logo_88_31.gif</url>
      <title>ORACLE SOS</title>
      <link>http://ask.orasos.com/</link>
    </image>
    <item>
      <title>Oracle rman 检测坏块</title>
      <link>http://ask.orasos.com/thread-2706-1-1.html</link>
      <description><![CDATA[]]></description>
      <category>SQL 脚本</category>
      <author>xifenfei</author>
      <pubDate>Thu, 12 Jul 2018 04:30:24 +0000</pubDate>
    </item>
    <item>
      <title>记录特定用户操作触发器</title>
      <link>http://ask.orasos.com/thread-2705-1-1.html</link>
      <description><![CDATA[CREATE OR REPLACE TRIGGER sys.record_sql
  AFTER LOGON ON DATABASE
DECLARE

BEGIN
    IF (UPPER(sys_context(\'USERENV\', \'MODULE\')) LIKE \'SQLPLUS%\' AND UPPER(sys_context(\'USERENV\', \'HOST\')) IN(\'WORKGROUP\\XIFENFEI-PC\') AND UPPER(sys_context]]></description>
      <category>SQL 脚本</category>
      <author>xifenfei</author>
      <pubDate>Thu, 12 Jul 2018 04:28:06 +0000</pubDate>
    </item>
    <item>
      <title>触发器禁止exp导出数据</title>
      <link>http://ask.orasos.com/thread-2704-1-1.html</link>
      <description><![CDATA[]]></description>
      <category>SQL 脚本</category>
      <author>xifenfei</author>
      <pubDate>Thu, 12 Jul 2018 04:19:47 +0000</pubDate>
    </item>
    <item>
      <title>触发器找出来密码错误信息</title>
      <link>http://ask.orasos.com/thread-2703-1-1.html</link>
      <description><![CDATA[]]></description>
      <category>SQL 脚本</category>
      <author>xifenfei</author>
      <pubDate>Thu, 12 Jul 2018 04:17:44 +0000</pubDate>
    </item>
    <item>
      <title>long转换为varchar2脚本</title>
      <link>http://ask.orasos.com/thread-2702-1-1.html</link>
      <description><![CDATA[]]></description>
      <category>SQL 脚本</category>
      <author>xifenfei</author>
      <pubDate>Thu, 12 Jul 2018 04:17:03 +0000</pubDate>
    </item>
    <item>
      <title>剩余表空间查询脚本</title>
      <link>http://ask.orasos.com/thread-2701-1-1.html</link>
      <description><![CDATA[]]></description>
      <category>SQL 脚本</category>
      <author>xifenfei</author>
      <pubDate>Thu, 12 Jul 2018 04:14:56 +0000</pubDate>
    </item>
    <item>
      <title>Oracle数据库异常恢复检查脚本(Oracle Database Recovery Check)</title>
      <link>http://ask.orasos.com/thread-2700-1-1.html</link>
      <description><![CDATA[具体使用参考：Oracle数据库异常恢复检查脚本(Oracle Database Recovery Check)]]></description>
      <category>SQL 脚本</category>
      <author>xifenfei</author>
      <pubDate>Thu, 12 Jul 2018 04:14:16 +0000</pubDate>
    </item>
    <item>
      <title>剩余表空间查询脚本</title>
      <link>http://ask.orasos.com/thread-2685-1-1.html</link>
      <description><![CDATA[CLEAR COLUMNS BREAKS COMPUTES
set lines 150
COLUMN STATUS                              HEADING \'Status\'            ENTMAP off
COLUMN TABLESPACE_NAME                     HEADING \'Name\'              ENTMAP off
COLUMN CONTENTS          FORMAT a12]]></description>
      <category>SQL 脚本</category>
      <author>xifenfei</author>
      <pubDate>Sat, 29 Aug 2015 02:07:09 +0000</pubDate>
    </item>
    <item>
      <title>logmnr使用说明</title>
      <link>http://ask.orasos.com/thread-50-1-1.html</link>
      <description><![CDATA[]]></description>
      <category>SQL 脚本</category>
      <author>xifenfei</author>
      <pubDate>Sun, 30 Mar 2014 12:55:16 +0000</pubDate>
    </item>
    <item>
      <title>百试百爽的重设数据文件大小sql语句</title>
      <link>http://ask.orasos.com/thread-11-1-1.html</link>
      <description><![CDATA[当你想resize来减小数据文件大小时，可以通过下面脚本来完成，百试百爽]]></description>
      <category>SQL 脚本</category>
      <author>xifenfei</author>
      <pubDate>Sun, 16 Mar 2014 11:41:06 +0000</pubDate>
    </item>
    <item>
      <title>Script about session or wait</title>
      <link>http://ask.orasos.com/thread-10-1-1.html</link>
      <description><![CDATA[Script about session or wait events]]></description>
      <category>SQL 脚本</category>
      <author>yrg5101</author>
      <pubDate>Sun, 16 Mar 2014 09:39:27 +0000</pubDate>
    </item>
    <item>
      <title>一个查看表统计信息的脚本sosi</title>
      <link>http://ask.orasos.com/thread-9-1-1.html</link>
      <description><![CDATA[一个查看表统计信息的脚本sosi,来源于网络]]></description>
      <category>SQL 脚本</category>
      <author>yrg5101</author>
      <pubDate>Sun, 16 Mar 2014 09:30:33 +0000</pubDate>
    </item>
  </channel>
</rss>