Record the irresponsible way of filing and supporting explosion in the first guide warehouse

There is another problem in the test data verification, but the card owner is still in the process of importing. Then I look at the logs and find that a large number of archive logs are generated during the import of impdp, so the storage and archive space is full, so it gets stuck Tail / u01 / APP / Oracle / diag / RDBMS / zhanky / zhanky / ...

Posted on Fri, 15 Nov 2019 16:21:29 -0500 by bo0

[vbox] 11g rac to simulate ocr damage recovery

Both the voice and ocr in 11gR2 are under the same disk group, so recovery is integrated View normal backups [grid@rac1 admin]$    [grid@rac1 admin]$ ocrconfig -showbackup  rac1     2019/05/08 12:27:51     /u01/app/11.2.0/grid/cdata/rac-cluster/backup00.ocr rac1     2019/05/07 15:32:37     /u01/app/11.2.0/grid/cdata/rac-clu ...

Posted on Fri, 15 Nov 2019 12:23:45 -0500 by egmax

oracle learning notes: ResultSetMetaData and ResultSet are transformed into corresponding entity class framework

introduce Objects that can be used to obtain information about the types and properties of columns in ResultSet objects are widely used in the framework of persistent frame layer (such as mybatis, hibernate). common method int getColumnCount() Returns the number of columns in this ResultSet object String getColumnLabel(int column) Gets the rec ...

Posted on Wed, 13 Nov 2019 10:31:55 -0500 by as22607

springboot with transaction operation mybatis four data sources oracle dream mysql sqlserver

springboot with transaction operation mybatis four data sources oracle dream mysql sqlserver Article directory springboot with transaction operation mybatis four data sources oracle dream mysql sqlserver 1. Preconditions 1. jar bag 2. pom files, not fancy, bring them all 3. properties 2. General configuration of data sou ...

Posted on Tue, 12 Nov 2019 13:18:24 -0500 by PromaneX

New feature of Oracle 12c -- PDBs point in time recoverys

concept You can now recover a PDB to a specific point-in-time. This feature is a high availability enhancement for consolidation and extends point-in-time recovery functionality to PDBs. You can now restore the PDB to a specific point in time. This feature is a high availability enhancement to consolidation and extends point t ...

Posted on Mon, 11 Nov 2019 17:52:14 -0500 by Taro

New feature of Oracle 12c -- LOGTIME parameter of data pump command

concept   The new LOGTIME command-line parameter available in Oracle Data Pump Export and Import allows you to request that messages displayed during export and import operations be timestamped. The valid values are: NONE - no timestamps on status or log file messages (same as the default) STATUS - timestamps on status mes ...

Posted on Mon, 11 Nov 2019 09:47:18 -0500 by LuiePL

Test merge efficiency

Test instructions: MERGE is A special sql syntax provided by oracle, which is very suitable for data synchronization scenarios, that is: (insert the data of table A into table B, and update the table B with the data of table A if there is A record with the same primary key in table b). The normal method of data synchronization is to try to ins ...

Posted on Sun, 10 Nov 2019 14:11:34 -0500 by PHP_Idiot

String.intern() could have been used that way (principles and applications)

1 Introduction String.intern() is a native method provided by JDK early on, not implemented by Java, but by the underlying JVM, which makes it more difficult for us to explore it.Especially after Oracle acquired Sun, the source code was not open source, let alone in-depth study.But we still need to explore as much as possible. This paper will m ...

Posted on Sun, 10 Nov 2019 02:23:07 -0500 by MiCR0

Mybatis realizes data up, down, top and bottom

introduce In some management systems, there are often some requirements to move the generated list data up, down, top and bottom. At this time, some SQL skills are required. Here is an introduction to the use of Mybatis technology. Concrete realization Database table The first design of the table needs to have some requirements, here a menu tre ...

Posted on Fri, 08 Nov 2019 05:59:21 -0500 by gateUK

oracle basically uses [7] single line function and group function

This article describes the functions in linux. In linux, functions are divided into single line functions and group functions. Single line functions are divided into string functions, number functions, date functions and other functions. Group functions are divided into max, min, avg, sum and count. 1 system, environment and preco ...

Posted on Wed, 06 Nov 2019 17:01:32 -0500 by TheDeadPool