Database Administrator

New Features of MongoDB 3.0 In March 3, MongoDB3.0 was finally released. The main features include support for the previously acquired WiredTiger storage engine, plug-in storage engine API, SCRAM-SHA-1 authentication mechanism, and improved

Upgrade Goldengate 11.1.1.1.2 to 11.2.1.0.1 Configuration environment: Source:OGG: 11.2.1.0.1Name: bkjia1 Target:OGG: 11.1.1.1.2Name: bkjia2 Upgrade Target to the same version as the source. Backup Target ogg installation directory:[Root @ bkjia2/] #

Oracle mobile table When creating a table, you can specify a storage space for the table. If not specified, Oracle will store the table to the default tablespace. You can move a table from one tablespace to another as needed. Syntax: Alter table

How to forget the MySQL root Password in Windows 1. Open the MySQL configuration file my. ini and add skip-grant-tables to the end of the file or add it to the [mysqld. 2. Restart the MYSQL service. In windows:Net stop MySQLNet start MySQL If an

Hibernate configuration file Persistent objects can be in the following three States: Temporary State (Transient): the object is in the temporary State before it is saved to the database. In this case, the database does not have information about

OGG-01496 OGG-01031 troubleshooting The pump process reports the following error: 01:20:49 ERROR OGG-01496 Oracle GoldenGate Capture for Oracle, ext2.prm:./dirdat/sa000000, at RBA 2295. The tail file does not exist on the target end. It may be

Unique and index in Oracle 10 GB Unique and index in Oracle 10 GB Create table test ( X integer, Y integer, Z integer ); Alter table test add constraint primary key (x); -- generates a constraint and an index of the same name. Create unique index

Introduction to the Oracle temp table [Preface] Today, the developer encountered a problem where data could not be found in the temp table. After learning a little bit about it, I feel that there are still many knowledge points, so I will sort them

Oracle table access permission Control Currently, the Oracle database has a system user SYSUSER who has permissions on all tables. The other system wants to access a table in my database. I don't want him to control all tables in my database, I

Create a temporary tablespace group in Oracle After Oracle 11g, you can create a temporary tablespace group. A temporary tablespace group can contain one or more temporary tablespaces.A temporary tablespace group must consist of at least one

Oracle query Sequence Oracle queries the sequence of a user, where user_name is the login name of your current database SQL> select SEQUENCE_OWNER, SEQUENCE_NAME from dba_sequences where sequence_owner = 'user _ name '; SEQUENCE_OWNER

Oracle clusters and cluster tables A cluster consists of multiple tables that share the same data block. It stores the related rows of these tables in the same data block, which can reduce the disk read volume required to query data. After creating

Install the phpredis module extension in ubuntu. 1. The premise is to install redis first, and then install phpredis... 2.download the phpredis-master.tar.gz installation package first... The details are as follows: 1.tar zxvf

Sub-structure and sub-structure of the tree 1. Question Enter Two Binary Trees A and B to determine whether B is A sub-structure. The binary tree structure is as follows: Struct BinaryTreeNode { Int m_nValue; BinaryTreeNode * m_pLeft; BinaryTreeNOde

11. Basic binary tree theory and 11 basic binary tree theoryI. Basic concepts of Binary Trees1. DefinitionA Binary Tree is a finite set of n (n> = 0) nodes. It is an empty set (or an empty Binary Tree ), it can also be composed of a root node and a

Oracle 12c learning 3 converting nocdb to pdb and nocdbpdb 01:23:06 sys @ orcl> select name, decode (cdb, 'yes', 'multitenant Option enabled', 'regular 12c Database: ') "Multitenant Option", open_mode, con_id from v $ database; NAME Multitenant

Transport Tablespace Set (3), createtablespace View the source Character Set and endian:SQL> select userenv ('language') from dual;USERENV ('language ') SIMPLIFIED CHINESE_CHINA.ZHS16GBKSQL> SELECT d. PLATFORM_NAME, ENDIAN_FORMAT2 FROM V

Enq: TX, enqtx Enq: three parameters of the TX-row lock contention wait event are as follows: * P1 = name | mode * P2 = usn XidusnAnd v $ transaction.Xidslot* P3 = sequence XidseqIt is not hard to find that P2 and P3 are actually XIDComponents --

Data migration-compact and move -- The current requirement is that the following result sets become compact: COL1 COL2 COL3------------------------------ 123456789101112 COL1 COL2 COL3------------------------------1 7 112 8 123 94 1056 Drop table

Build a highly scalable WEB interactive system (I) to build a highly scalable web Source: http://www.zaojuzi.com/nirenju/1287.html Scalability is a design indicator for the processing capability of software systems. high scalability represents a