Database Administrator

Oracle GoldenGate installation Configuration Oracle GoldenGate can be used to migrate and synchronize data on heterogeneous platforms. It is based on database log structure changes and obtains data increments by parsing source-end online logs or

Development idea of using Lua script in Redis Redis provides the eval command to execute the Lua script. The following example shows how to execute a Lua script on the Redis server. 1. Run the following commands to execute the Lua script:

How to solve Chinese garbled characters written into MySQL using Java How to solve the problem of garbled characters in MySQL written in Java:Method 1: When the page value contains Chinese characters, you can use the filter to compile it. However,

Oracle NULL column and PL./SQL Execution Experiment Today, we have some experiments on Oracle NULL values. We will discuss how to insert NULL values. 1. You can insert ''or NULL in PL/SQL, provided that the column is allowed to be empty. 2. You can

PostgreSQL Stored Procedure What is a Stored Procedure, which is defined by Baidu Encyclopedia: A Stored Procedure (Stored Procedure) is a set of SQL statements in a large database system to complete specific functions, after the first compilation,

Oracle 11g Data Loading Methods Data Loading: SQL * LOADER External table Import/Export SQL * LOADER: SQL * LOADER is an Oracle tool that can load data from external data files to databases. The command for running SQL * LOADER is sqlldr. Two

Mysql Log, where is the mysql Log File? Mysql logs are classified into binary logs, error logs, general query logs, and slow query logs. Binary log: records database operations in the form of binary files, but does not record query statements. Error

Temporary tablespace cleaning in Oracle and Oracle tablespace cleaning Author: iamlaosong Oracle temporary tablespace is mainly used to query and store some buffer data. Temporary tablespace consumption is mainly caused by sorting the intermediate

ORACLE-013: kill deadlock process in oracle, oracle-013oracle In oracle, stored procedures or functions that frequently access packets may cause deadlocks. Scripts of deadlocked objects cannot be run, causing freezing or an exception: too many

Redis configuration file details, redis configuration file# Redis configuration file# When the memory size needs to be configured in the configuration, you can use 1 k, 5 GB, 4 M and other similar formats, the conversion method is as follows (Case

[Data Center reconstruction]-view, trigger, use of stored procedure, trigger Stored Procedure In the data room charging system, it is very troublesome to write multiple SQL statements to query multiple tables. To facilitate code writing, code

Mysql Date and Time type, mysql Date and Time Type Current_time display current time now () display current date and time type YEAR 1 byte 1901 ~ 2155 zero value 0000 DATE 4 byte 1000-01-01 ~ 9999-12-31 0 value 0000: 00: 00 TIME 3 bytes-838: 59: 59

Redhat 6.4 install ORACLE11R2 and run root. sh to report the following error: "libcap. so.1: cannot open shared object file", oracle11r2root. sh 1. system environment: Redhat 6.4 Enterprise Edition Oracle11.2.0.2 RAC + ASM 2. error

Use expdp (non-local) to remotely export data and use expdp to export data Background: Some time ago, test data (one table) needs to be imported into the local database from a remote test database. The table has about 5 million data records and more

About the OGG stats process name reset command, the oggstatsreset command Oracle GoldenGate Command Interpreter for OracleVersion 11.1.1.1.2 OGGCORE_11.1.1.1.2_PLATFORMS_111004.2100 Linux, x86, 32bit (optimized), Oracle 10g on Oct 4 2011 23: 54: 04

The object attributes of the MySqli extension Library and the process-oriented comparison with the mysql database. After learning the mysql database to operate mysql, this is a process-oriented method. However, object-oriented is the trend of the

[Translated from mos] Oracle Database In-Memory Advisor, mosin-memory Oracle Database In-Memory Consultant Source:Oracle Database In-Memory Advisor (Document ID 1965343.1) Applicable:Enterprise Manager for Oracle Database-Version 12.1.0.2.0 and

Supports SQL tuning and SQL TUNING A friend of mine found me a few days ago and said that an SQL Performance problem exists to see if it can be optimized. The process is as follows: Snow Leopard 9:35:10 Are you there? Orchid island master 15:07:39 I

An SQL Server query statement increases tempdb by 55 GB and tempdbby 55 GB. When I operated the server today, the lower right corner of the page prompts "disk C is not enough "! Scared !~Look at drive C, there are still 7 M !!! How can I lose such a

Shang Silicon Valley-mybatis-resolves the conflict between field names and object class names, and Silicon Valley-mybatis- Project Structure: Prepare tables and data: CREATE TABLE orders(order_id INT PRIMARY KEY AUTO_INCREMENT,order_no VARCHAR(20)