[20180823]IMU And db link.txt

--// When using db link When viewing remote tables , It actually produces a little log .
--// At that time, if it was related to IMU Bind together , Can lead to IMU The failure of .

1. Environmental Science :
SCOTT@book> @ ver1
PORT_STRING                    VERSION        BANNER
------------------------------ -------------- --------------------------------------------------------------------------------
x86_64/Linux 2.4.xx            11.2.0.4.0     Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

CREATE  PUBLIC DATABASE LINK LOOPBACK CONNECT TO SCOTT IDENTIFIED BY book USING 'localhost:1521/book:DEDICATED';
create table deptx as select * from dept;

2. test :
SCOTT@book> @ &r/viewsess "IMU commits"
NAME        STATISTIC#      VALUE        SID
----------- ---------- ---------- ----------
IMU commits        374          0          1

SCOTT@book> update deptx set dname=lower(dname) where deptno=10;
1 row updated.

SCOTT@book> commit;
Commit complete.

SCOTT@book> @ &r/viewsess "IMU commits"
NAME        STATISTIC#      VALUE        SID
----------- ---------- ---------- ----------
IMU commits        374          1          1

--// You can find the current database IMU It works .

SCOTT@book> @ &r/viewsess "IMU commits"
NAME        STATISTIC#      VALUE        SID
----------- ---------- ---------- ----------
IMU commits        374          0          1

SCOTT@book> update deptx set dname=lower(dname) where deptno=10;
1 row updated.

SCOTT@book> select sysdate from dual@loopback;
SYSDATE
-------------------
2018-08-22 09:04:00

SCOTT@book> commit ;
Commit complete.

SCOTT@book> @ &r/viewsess "IMU commits"
NAME        STATISTIC#      VALUE        SID
----------- ---------- ---------- ----------
IMU commits        374          0          1

--// When it's when it's executed dml From time to tome dblink The sentence of ,IMU invalid , Back to the original pattern .

--//viewsess.sql Script :
set verify off
column name format a70
SELECT b.NAME, a.statistic#, a.VALUE,a.sid
  FROM v$mystat a, v$statname b
 WHERE lower(b.NAME) like lower('%&1%') AND a.statistic# = b.statistic# ;
 --and a.value>0;

[20180823]IMU And db link.txt More articles about

  1. oracle db link View create and delete

    1. see dblink select owner,object_name from dba_objects where object_type='DATABASE LINK'; perhaps select * ...

  2. Oracle global database name And db link The entanglement of

    ORACLE In the database Global Database Name And DB LINKS The relationship between us is a little tangled , Before making this relationship clear , So let's see Global Database Name The concept of Global ...

  3. db link View create and delete ( turn )

    1. see dblink select owner,object_name from dba_objects where object_type='DATABASE LINK'; perhaps select * ...

  4. db link View create and delete

    1. see dblink select owner,object_name from dba_objects where object_type='DATABASE LINK'; perhaps select * ...

  5. About DB Link

    summary DB Link Is an object that defines the path from the local database to the remote database , yes schema object, It's a one-way connection adopt DB Link Can query remote The object of database and its running program In a distributed environment ,DB Lin ...

  6. DB link Migration

    We're doing something Schema When you're moving , Because of the use of Public Of db link, However, because I don't know db link The password of the target account in , So it's impossible to recreate... In a new environment DB link. The idea of this experiment is to view dba_db ...

  7. DB Link

    oracle in DB Link select * from TB_APP_HEADER@SSDPPORTAL

  8. A comprehensive interpretation of Oracle The conceptual function of synonyms 、 Create, delete, view and Oracle Of db link

    Oracle A synonym for (synonyms) Literally, it means alias , It's similar to the function of a view , It's a kind of mapping relationship . stay Oracle The management of users in is managed by using permissions , in other words , If we want to use databases , We have to ...

  9. DB Link Remove the domain name

    1. see global_name Set up SQL> show parameters global_name; NAME                                 TYPE    ...

Random recommendation

  1. Android Studio How to refer to external Library engineering

    Reference resources :    http://stackoverflow.com/questions/16588064/how-do-i-add-a-library-project-to-the-android-stu ...

  2. Legends-ggplot2 Some operations of legend

    Remove legend require(ggplot2) b = qplot(Sepal.Length,Petal.Length,data=iris,geom="point",colour = ...

  3. log4j Configure the instance

    1. http://hehongwei44.iteye.com/blog/1494999 2. http://maymay.iteye.com/blog/1275432 #log4j.rootLogg ...

  4. PrepareCommand

    /// <summary> /// Execute parameter query /// </summary> /// <param name="cmd"> Database execution command < ...

  5. IOS Development of ---- Agreement and Commission (Protocol and Delegate) Instance analysis

    1 agreement : agreement , Be similar to Java or C# Interface in language , It limits which methods an implementation class must have . It's a definition of object behavior , It's also the specification of function . Before I write an example, let me tell you @required and @optional These two keys ...

  6. jQuery review : Chapter two &amp; The third chapter

    Chapter two One . Selectors 1. Hierarchy selector $(“ancestor descendant”) selection ancestor All the descendant elements in the element $(“parent > child”) selection parent Under the element chi ...

  7. jq Carousel plug-in

    /* *  Instructions   *    *   1: Need to provide a label    *   2:lis: The number of pictures  *   3: The size of the carousel  width ,height *   4: The address of the picture imgs[0].carou ...

  8. IO Reuse

    IO Reuse : Enables the program to listen to multiple file descriptors at the same time select: select Within a specified period of time , Listen for file descriptors that users are interested in read . Write . Unusual events . select(int nfds,fd_set* readf ...

  9. Servlet And Session Handle

    HttpSession Several important methods available in object : 1    public Object getAttribute(String name) The method returns the value in the session The object with the specified name in the session ...

  10. Neural networks -SGD-1

    SGD Neural networks and python To realize 1.SGD(stochastic gradient descend):<1> Data extraction :<2> Calculate the gradient ;<3> Parameters are updated :< ...