小伟的博客

 摘自老道博客： http://blog.youkuaiyun.com/daohengshangqian/article/details/39268609   metalink 给出的公式是 UR =undo_retention参数值 UPS= 每秒产生的undo block数量 DBS = undo tablespace block size 10g之前 SE

oracle 估算redo脚本 set lines 255 set pages 14 col "00" for a3 col "01" for a3 col "02" for a3 col "03" for a3 col "04" for a3 col "05" for a3 col "06" for a3 col "07" for a3 col "08" for a3 col "09" for

Option Explicit Dim mdl ' the current model Set mdl = ActiveModel If (mdl Is Nothing) Then MsgBox "There is no Active Model" End If Dim HaveExcel Dim RQ RQ = vbYes 'MsgBox("Is Excel Installed

col owner for a10 col table_name for a30 SELECT OWNER,        SEGMENT_NAME TABLE_NAME,        SEGMENT_TYPE,        GREATEST (ROUND ( 100 * ( NVL (HWM - AVG_USED_BLOCKS, 0 ) /

文档 ID 1064487.1) log file sync 诊断脚本内容如下：-- NAME: LFSDIAG.SQL-- -------------------------------------------------------------------------- AUTHOR: Michael Polaski - Oracle Support Services-- ----------

摘自：http://www.eygle.com/archives/2007/07/function_rdba_convert.html 1.写了一个简单的函数，用来从RDBA中转换file#和block#出来: CREATE OR REPLACE FUNCTION getbfno (p_dba IN VARCHAR2)    RETURN VARCHAR2 IS    l

将oracle 16进制的数据转换为字符类型 SQL> create or replace function hextostr(hexstr varchar2) return varchar2 is     i    number;     s    char;     str1 varchar2(20);     rst  varchar2(200);   begin