ITPub博客

模型原理.1. A user application updates a row on system A.2. Extract extracts the row on system A and sends it to system B.3. Replicat updates the row on system B.4. Extract extracts the row on systemB and sends it back to system A.5. The row is applied on system A (for the second time).6. This...

1、创建数据字典文件（data-dictonary)需要在初始化文件中指定参数UTL_FILE_DIR = (\xxx\xx) 需要重新启动系统2、sys 登入运行存储过程connect /as sysdba  SQL> execute dbms_logmnr_d.build(dictionary_filename => 'dict.ora',dictionary_location => 'xxx\xxx');3、创建要分析的日志...

lsof（list open files）是一个列出当前系统打开文件的工具。在linux环境下，任何事物都以文件的形式存在，通过文件不仅仅可以访问常规数据，还可以访问网络连接和硬件。所以如传输控制协议 (TCP) 和用户数据报协议 (UDP) 套接字等，系统在后台都为该应用程序分配了一个文件描述符，无论这个文件的本质如何，该文件描述符为...

列出所有端口 (包括监听和未监听的)netstat -a列出所有 tcp 端口 netstat -at列出所有 udp 端口 netstat -au在 netstat 输出中显示 PID 和进程名称 netstat -p

avg-cpu段:%user: 在用户级别运行所使用的CPU的百分比.%nice: nice操作所使用的CPU的百分比.%sys: 在系统级别(kernel)运行所使用CPU的百分比.%iowait: CPU等待硬件I/O时,所占用CPU百分比.%idle: CPU空闲时间的百分比.Device段:tps: 每秒钟发送到的I/O请求数.Blk_read /s: 每秒读取的block数.Blk_wrtn/s: 每秒写入...

基数是指一张表有N行其中一列的值为固定的几个加入为M个则基数为M/N N 越大越好M 越小越好（对于位图来讲）

作为sys 登入执行下列语句SQL> create role plustrace;SQL> grant select on v_$sesstat to plustrace;SQL> grant select on v_$statname to plustrace;SQL> grant select on v_$mystat to plustrace;SQL> grant plustrace to dba with admin option;SQL> grant plustrace to pub...

1-----------------alter session set sql_trace=true;SELECT c.value||'/'||d.instance_name||'_ora_'||a.spid||'.trc' trace_file_name          from v$process a,v$session b,v$parameter c,v$instance d         wher...

ultraedit 删除空行是一个非常有用的功能。令人啼笑皆非的是，令人哭笑不得的是，网上到处都是专家文章，能否使用的却几乎没有。不得不自己来写本文，方便以后查询。以下查到的7中方式，最有效的似乎还是第七种。(1)如果是UNIX格式，替换^n^n为^n, 或者替换"^?n?$" 为空（""）(2)如果是DOS格式，特换^r^n^r^n为^r^n,(3)...

  CREATE TABLE ADAPTER.ADAPTER_ERRORDATA   (EVENTID VARCHAR2(32) NOT NULL ENABLE, RECORDCLASSIFYING VARCHAR2(32), RECORDTITLE VARCHAR2(50), EFFECTIVETIME DATE, AUTHORORGANIZATION VARCHAR2(56), SOURCEID VARCHAR2(32), VERSIONN...

select * from t_viradsl2 as of timestamp to_Date('2011-01-19 15:28:00', 'yyyy-mm-dd hh24:mi:ss')

the Permission (java.io.FilePermission <<ALL FILES>> execute) has not been granted to ADAPTER. The PL/SQL to grant this is dbms_java.grant_permission( 'ADAPTER', 'SYS:java.io.FilePermission', '<<ALL FILES>>', 'execute' ) Execute SYS.dbms_java.grant_permission( 'username', 'SYS:java.io...

Oracle中TO_DATE格式TO_DATE格式(以时间:2007-11-02 13:45:25为例)           Year:        yy two digits 两位年 显示值:07        yyy three digits 三位年 显示值:007        yyyy four digits ...

CREATE OR REPLACE FUNCTION C2B (b IN CLOB default empty_clob()) RETURN BLOBASres BLOB;b_len number := dbms_lob.getlength(b) ;dest_offset1 NUMBER := 1;src_offset1 NUMBER := 1;amount_c INTEGER := DBMS_LOB.lobmaxsize;blob_csid NUMBER := DBMS_LOB.default_csid;lang_ctx I...

CREATE OR REPLACE FUNCTION blob_to_clob (blob_in IN BLOB) RETURN CLOB   AS    v_clob CLOB;    v_varchar VARCHAR2(32767);    v_start PLS_INTEGER := 1;    v_buffer PLS_INTEGER := 32767;    tmp_num number;  &...

RMAN> run{2> allocate channel d1 type disk;3> backup as compressed backupset4> incremental level 05> format '/u01/backup/inc0_%t_%T'6> tag='inc0'7> database include current controlfile;8> sql 'alter system archive log current';9> backup archivelog all format '/u01/b...

V$rman_Backup_Job_DetailsSELECT j.session_key,       TO_CHAR (J.START_TIME, 'yyyy-mm-dd hh24:mi:ss') start_time,       TO_CHAR (j.end_time, 'yyyy-mm-dd hh24:mi:ss') end_time,       J.TIME_TAKEN_DISPLAY,  &nbsp...

Oracle审计表AUD$数据过大问题1)Only appropriate privileged user can do delete operation on SYS.AUD$ table. The user must have either of the following privileges.-SYS user.-DELETE ANY TABLE system privilege. (If O7_DICTIONARY_ACCESSIBILITY=TRUE)-A user to whom SYS has granted the o...

1、DML could fail because there is not enough space to accommodate undo fornew transactions.2、Long-running queries could fail with a snapshot too old error, which meansthat there was insufficient undo data for read consistency

@echo offfor %%i in (D:\temp\*.txt) do (for /f "delims=" %%j in ('type %%i') do echo %%j>>D:\temp\huzhicheng.txt)echo 操作完成pause