Oracle Wait Events: Wait for scn ack

wait for scn ack is a waiting event that may be common in RAC environments, meaning waiting for a SCN response across instances. Top 5 Timed Events Avg %Totalr ~~~~~~~~~~~~~~~~~~ wait Call Event Waits Time (s) (ms) Time Wait Class ...

Posted by 00tank on Sun, 16 Dec 2018 10:03:03 -0800

ASM Translation Series 12: ASM Internal amdu - ASM Metadata Dump Utility

Original text: ASM disk header Author: Bane Radulovic Translator: Zhuang Peipei, Pre-sales Engineer of Waukee Science and Technology Database, is mainly responsible for database platform architecture design, product validation and testing. Revision: Wei Xinghua Chief Editor: Qian Shuguang amdu - ASM Metadata Dump Utility ASM Metadata Du ...

Posted by somedude on Sun, 16 Dec 2018 02:42:03 -0800

Oracle11g migrates from single instance + ASM to RAC+ASM

A few days ago, when my department colleagues were working on the project, the customer asked to migrate the single instance + ASM database to RAC+ASM. After that, the God sorted out some ideas and operation details and published them on the company's public number. I saw itching in the future, so I planned to do an experiment ...

Posted by Jewbilee on Sun, 16 Dec 2018 02:06:03 -0800

Basic usage of Bean Utils, ConvertUtils, Property Utils and Collection Utils of apache-commons

The BeanUtils toolkit, developed by Apache, is designed to facilitate programmers to easily manipulate Bean classes. BeanUtils has four packages:       org.apache.commons.beanutils       org.apache.commons.beanutils.converters       org.apache.commons.beanutils.locale       org.apache.commons.beanutils.locale.converters Of particular ...

Posted by m00p4h on Sun, 16 Dec 2018 01:54:04 -0800

[ArcSDE/Oracle] Configure Oracle so that SQL can operate on ST_GEOMETRY type

To use the relevant dynamic link libraries in sde, you need to install arcsde and oracle beforehand. 1. Test cases select sde.ST_AsText(SDE.ST_Geometry('POINT (10 10)', 0)) from dual; 2. Configure listener.ora, tnsname.ora and extproc.ora If the following error occurs: ORA-28595: Extproc agent: invalid DLL path ORA-06512: In "SDE. ...

Posted by Grayda on Sat, 15 Dec 2018 19:42:03 -0800

mysql, sql server, oracle, DB2, Access paging technology

mysql, sql server, oracle, DB2, Access paging technology mysql Remember that limit in mysql starts from scratch The main format is as follows: select * from tablename limit m,n For example, look up lines 6 to 20 select * from tablename limit 5,15 The two right-hand writings are equivalent: sel ...

Posted by manjunath on Sat, 15 Dec 2018 12:51:03 -0800

Spring + spring MVC + mybatis + Oracle + atomikos + JTA to realize multi-data source transaction management

- Restore content to start In the process of project, we encountered the situation that we need to access two databases in a project. We found that the transaction could not be rolled back properly because of the routine spring management. Therefore, we adopt the distributed data source mode of jta+atomikos to manage the transaction. Make a rec ...

Posted by Cep on Fri, 14 Dec 2018 22:54:04 -0800

Java Collection (3) - ListIterator Interface Source & Identification of ListIterator Interface and Iterator Interface

ListIterator interface Official Document Description: An iterator for lists that allows the programmer to traverse the list in either direction, modify the list during iteration, and obtain the iterator's current position in the list. A ListIterator has no current element; its cursor position always lies between the element that would b ...

Posted by ywickham on Wed, 12 Dec 2018 17:33:06 -0800

Use RMAN DUPLICATE...FROM ACTIVE DATABASE to create physical standby database (document ID 1526160.1)

Use RMAN DUPLICATE... FROM ACTIVE DATABASE Step-by-Step Guide to Creating Physical Standby Databases (Document ID 1526160.1) Apply to: Oracle Database - Enterprise Edition - Version 9.2.0.8 and higher The information contained in this document is applicable to all platforms target How to create a step-by-step guide to physical standb ...

Posted by melmoth on Tue, 11 Dec 2018 05:00:08 -0800

Installation of oracle-xe-11g database using Docker under mac os

First, install docker. In mac os, you need to install docker through docker-toolbox. You can download docker here. docker-toolbox Download the corresponding version of the pkg file and double-click to open the installation Pictured next can be installed. There are two more items in your Application after installation Pictured ...

Posted by grissom on Mon, 10 Dec 2018 22:15:05 -0800