[Oracle @ test2 ~] $ Sqlplus/nolog
SQL * Plus: Release 10.2.0.1.0-Production on Sun Jan 21 12:01:35 2007
Copyright (c) 1982,200 5, Oracle. All rights reserved.
SQL> conn/as sysdba
Connected.
SQL> r
1 * select program, count (1) from v $ session group by program
Program count (1)
----------------------------------------------------------
Oracle @ test2 (ARC1) 1
Oracle @ test2 (RECO) 1
Oracle @ test2 (ARC0) 1
Oracle @ test2 (PMON) 1
Oracle @ test2 (q000) 1
Oracle @ test2 (SMON) 1
Oracle @ test2 (MMON) 1
Sqlplus @ test2 (TNS V1-V3) 2
Oracle @ test2 (q001) 1
Oracle @ test2 (DBW0) 1
Oracle @ test2 (CKPT) 1
Oracle @ test2 (CJQ0) 1
Oracle @ test2 (QMNC) 1
Oracle @ test2 (LGWR) 1
Oracle @ test2 (PSP0) 1
ORACLE. EXE 1
Oracle @ test2 (MMNL) 1
Oracle @ test2 (MMAN) 1
18 rows selected.
SQL> host
[Oracle @ test2 ~] $ Uname-
Linux test2 2.6.9-34.EL #1 Wed Mar 8 00:07:35 CST 2006 i686 i686 i386 GNU/Linux
In the v$sessionmodule, the process oracle.exe was shocked. I thought I encountered another BUG and analyzed the cause.
[Oracle @ test2 ~] $ Uname-
Linux test2 2.6.9-34.EL #1 Wed Mar 8 00:07:35 CST 2006 i686 i686 i386 GNU/Linux
SQL> create table test nologging as select * from all_objects;
Table created.
SQL> alter table test add constraint pk_object_id primary key (object_id );
Table altered.
SQL> CREATE MATERIALIZED VIEW LOG ON test;
Go to windows
SQL> host
Microsoft Windows XP [version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.
SQL> CREATE MATERIALIZED VIEW test
2 build immediate
3 refresh force
4 next sysdate + 2/1440
5 with primary key
6 as select * from yxyup. test @ teng
7/
SQL> r
1 * select program, count (1) from v $ session group by program
Program count (1)
----------------------------------------------------------
Oracle @ test2 (ARC1) 1
Oracle @ test2 (RECO) 1
Oracle @ test2 (ARC0) 1
Oracle @ test2 (PMON) 1
Oracle @ test2 (q000) 1
Oracle @ test2 (SMON) 1
Oracle @ test2 (MMON) 1
Sqlplus @ test2 (TNS V1-V3) 2
Oracle @ test2 (q001) 1
Oracle @ test2 (DBW0) 1
Oracle @ test2 (CKPT) 1
Oracle @ test2 (CJQ0) 1
Oracle @ test2 (QMNC) 1
Oracle @ test2 (LGWR) 1
Oracle @ test2 (PSP0) 1
ORACLE. EXE 1
Oracle @ test2 (MMNL) 1
Oracle @ test2 (MMAN) 1
18 rows selected.
It is almost clear that it should be the ORACLE. EXE process generated by DBLINK.