Database Administrator

Five most common problems that cause RAC instance crashes Five most common problems that cause the RAC instance to crash (Document ID 1549191.1) Applicable: OracleDatabase-Enterprise Edition-version 11.2.0.1 and laterThe information contained in

[MonogDB] The description of index (2) Embedded and document Index, monogdbembedded In this blog, we will talk about another the index which was called "The embedded". First we init 1 w the records as follows: 2.2 The embedded Index The compare

Character set 'utf8mb4' is not a compiled character set, utf8mb4compiled A Character set error occurred during a recent MySQL Data migration. The prompt is "character set 'utf8mb4' is not a compiled Character set ". That is, the character set utf8mb4

Kettle-engine.jar and log4j. jar package conflict problem solution, log4j. jar Java to call kettle, reference the kettle-engine.jar in lib, log4j. jar package, test found that with the kettle-engine.jar package, log can not be written to the log

Oracle Partition Table execution plan, oracle execution plan Partition tables have many advantages: they are big, small, and small. With parallel use, loap can often improve the performance by dozens or even hundreds of times. Of course, poor table

Suggestions on the size of the initial SGA database and the size of the PGA database, sgapga1. Background information Many new business systems are launched, and most DBAs do not understand the business, so they are bored with the header database

SSDB basic instructions and usage, SSDB basic instructions There are several reasons for using SSDB at that time. First, when designing the contest module, You need to query the Rank of the current competition multiple times because you click to

Oracle SQL statements are fast and slow, while oraclesql statements are fast and slow. Today, I encountered a very strange problem. One SQL statement is very slow in PL/SQL developer and takes 9 s. The problem SQL: SELECT * FROM GG_function_location

Replication between mysql tables, the same database and different databases, mysql table replication Database Mysql statement We can first export the structure of table t1 under test, and then create a new table test1.t1. Execute the following

SQL Server Report statistics-parameterized Dynamic Compaction row-to-column, sqlserverregression List all table structures first: -- Title Report -- table real-time Water Fee: hx_t_received -- field Charge Department id: hx_f1_mentid 1. Charge

The mysqli extension is missing. Check the PHP configuration ., Mysqliphp A new lamp is installed and you want to open the database. The following error occurs: PhpMyAdmin-the error message "mysqli extension" is missing. Check the PHP

MySQL Master/Slave latency monitoring script (pt-heartbeat), mysqlpt-heartbeat We can use percona's powerful weapon pt-heartbeat to monitor the master-slave replication latency of MySQL databases. Pt-heartbeat updates a specific table in the master

Oracle 10G tablespace movement, all applicable routines of the TNS listener cannot establish a new connection, service_died 12537, c3p0 connection pool parameters, One Oracle O & M experience while learning and working, step by step. A few days ago,

[MongoDB] The Capped Collection set of Mongodb databases, mongodbcapped Capped Collection is a set of excellent performance with a fixed size. It executes age-out (aging removal) processing in the LRU (least Recently Used, least Recently Used) rule

Mongodb 1 quick start deployment Quick Start deployment of Mongodb 1. Download mongdb and unzip vue I downloaded the windows zip package here.     2. decompress the package Rename mongodb     3. Create data, log, and repair files in the

Database ----- catalog and schema introduction, ----- catalogschema In the SQL environment, both Catalog and Schema are abstract concepts. They are mainly used to solve naming conflicts. A database system contains multiple Catalog, and each Catalog

Java calls the kettle conversion file, and java calls the kettle Conversion Call kettle to convert files in java   You can also call the command line code through the command line, and then call the command line code in java. In this way, it is not

Single block read, block read What is single read? As the name implies, a single block can be read by a single block. The waiting event is db file sequential read. What are the situations of a single block read? Most index scans are for a single

SegmentFault! 1024 programmer game "Red shore call" task introduction the next day, segmentfault Seeing that the lab is about to close, let's take a look at the problem solving process (in fact, everyone is waiting for the third question to come

Mysql modifies the database's storage engine (InnoDB), mysqlinnodbThe current example is to change the engine MyISAM to innodb.View the supported database engines and default database engines of the current databaseDatabase-supported engines and