Database Administrator

EXP-00091: Exporting questionable statistics Sometimes many EXP-00091: Exporting questionable statistics errors are reported when you use EXP tools to export or migrate data,The processing method is as follows: 1. symptom[Oracle @ node1] $ exp

MySQL master-master Replication Recently, I have been busy with MySQL for a long time and have not updated the document. I have learned that I have just set up the master copy of MySQL and sent the document by the way. Hope to help you! Production

Install and configure apsaradb for Redis in Linux I. Redis Configuration 1. Download and install $ Wget http://download.redis.io/releases/redis-2.8.17.tar.gz$ Tar xzf redis-2.8.17.tar.gz$ Redis-2.8.17 cd$ Make$ Make install Redis executable files

Oracle block upt Bad blocks In general, Oracle's Bad blocks can be divided into two scenarios: physical damage and logical damage. The physical damage is caused by storage and other reasons. As a result, Oracle finds that the checksum of the block

Key to enterprise application of NoSQL The discussion about whether NoSQL can be competent for enterprise-level databases is rampant. The focus of attention is that the environment of NoSQL databases is uncertain and changing. Some NoSQL enterprises

MySQL5.7 online Innodb_Buffer_Pool_size adjustment without restarting the mysql process In earlier versions, it is much easier to adjust the Innodb_Buffer_Pool_size to take effect only after the mysql process is restarted. Application scenarios of

Bug of rain and Oracle GoldenGate in Jinan, oraclegoldengateJinan is raining now (am). However, my mood is best described by Qi Qin's Song-"relentless rain, gently wake me up and make my tears ice like rain"I have just confirmed a bug of ogg in the

[MongoDB] Eight optimization skills and eight MongoDB skillsTip 1: Minimize disk access to memory much faster than disk access. Therefore, the essence of optimization is to minimize disk access.The read speed of the memory is 1 million times faster

Logical Backup Task in win7 and logical Backup Task in win7 Original Works are from the blog of "Deep Blue blog". You are welcome to reprint them. Please note the following source when reprinting them. Otherwise, you will be held legally liable for

SELECT field FROM table WHERE a field Like condition, selectwhereSQL provides four matching modes for conditions: 1. %: Represents any 0 or multiple characters. It can match any type and length of characters. In some cases, if it is Chinese, use

Missing filename opening checkpoint file., openingcheckpointGGSCI (hosta) 48> view report dpfull**************************************** *******************************Oracle GoldenGate Capture for OracleVersion 11.2.1.0.27 19591627 OGGCORE_11.2.1.0.

On the development of a new generation of large data distributed relational database initiative, relationalOn the development of a new generation of large data distributed relational database initiativeLi WanhongThe modern era has entered the age of

Oracle 11g RAC manually uninstall grid, no deinstall, griddeinstall1. log on to the ORACLE_HOME page of the grid as the root user. [Root @ db01] # source/home/grid/. bash_profile[Root @ db01] # cd $ ORACLE_HOME/crs/install/ 2. Execute the

Use explain to analyze and optimize the view performance composed of multiple tables (more than three tables ). View: Create or replace view FLOW_SUBMITPROCESS_V Select pi. START_USER_ID _, pir. STARTUSERID, pi. PROC_INST_ID _, pir. PROCESSINSTID,

Oracle _ view, oracle View Oracle _ view ① View1. A view is a virtual table.A view is built on an existing table. The tables created by the view are called base tables.The statement that provides data to the view is a SELECT statement, which can be

Session cache in Hibernate, hibernatesession1. Session cache:1). The implementation of the Session Interface contains a series of Java sets.,These Java sets constitute the Session cache.Used for storageSessionAssociated object(There are many ways to

You can use the table name and field name to query the field type. Today, I encountered a problem: I want to obtain the field type of this field through the table name and field name. I found a lot of methods on the Internet, but I was not

Common Oracle Database classic queries and oracle database queries This document collects common database queries and requires the database administrator privilege: 1. query temporary tablespace usage SELECT TABLESPACE_NAME, TABLESPACE_SIZE / 10

Resolution ORA-28000: the account is locked, ora-28000locked In oracle, if the account fails to log on for ten consecutive attempts, the account will be locked ). When you log on with a locked account, the system reports an error: ORA-28000: the

Use bbed (BBED-00200: invalid keyword (file), bbedbbed-00200[Oracle @ ogg1 lib] $ cat filelist.txt