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