Database Administrator

GoldenGate update loss Recently, an interesting but disturbing problem was found on the target database of GoldenGate (11.2.1.0.1 for 10g. This is the case. Some users reported that a table in the target database has two fields (DZFAILFLAG, REMARK)

Install MySQL 5.6.15 in Linux This article briefly explains how to install MySQL 5.6.15 in Linux. 1. Download MySQL 5.6Download Page: http://dev.mysql.com/downloads/mysql/Select "Red Hat Enterprise Linux 6/Oracle Linux 6 (x86, 32-bit), RPM Bundle"

Oracle SQL statement tracking 1. SQL statement tracking The execution of SQL statements must be performed on the Oracle server. The Oracle server detects and records all SQL statements executed by the access process. The commands used below are all

[Instance] in php, the PDO method is used to add, delete, modify, and query databases.You can easily organize and understand the PDO operation instances. Note that you need to enable the pdo support for php. php5.1 and later versions support

Improves SQL query efficiency and SQL Efficiency1. To optimize the query, try to avoid full table scanning. First, consider creating an index on the columns involved in where and order. 2. Try to avoid null value determination on the field in the

Oracle 12c connection errors reported ORA-28040 problem solution, 12cora-28040Problem description: When the client connects to Oracle 12c, an error is reported: ORA-28040: No matching authentication protocol Cause: The SQLNET.

Mysql trigger, mysql trigger instance Trigger 1. Definition: a specific operation is triggered by insert, update, delete, and other events. The trigger can trigger multiple execution statements. Note: triggers cannot contain keywords such as start

News system-SQLHelper assistant optimization, news system sqlhelper We used SQLHelper when restructuring our data center, but at that time we only applied it. We knew that using SQLHelper could help us connect to the database, but we still don't

Misunderstanding of Oracle Parallel 2 -- actually locking the entire table, oracle2 -- I have written a misunderstanding about Oracle parallelism before. 1. In fact, you didn't use parallelism. I always thought that Oracle would only lock the data

View MySQL indexes and mysql IndexesMysql> show index from tblname; mysql> show keys from tblname; · Table name. · Non_unique: 0 if the index cannot contain duplicate words. If yes, it is 1. · Key_name index name. · Column serial number in

MySQL database: consolidate the DDL statements, mysqlddl The SQL language includes four major programming languages: Data Definition Language (DDL), data operation language (DML), Data Control Language (DCL), and transaction control language. Data

Oracle uses AWR's SQL ordered by Gets and SQL ordered by Reads to diagnose problems. awrreads I have read many database reports before, and have encountered two serious performance problems recently. They are very representative, so I recorded them.

Chapter 9 algorithm Interview Questions 27 maximum continuous subset, Chapter 9 subsetChapter 9 algorithm official website-original website Http://www.jiuzhang.com/problem/27/ Question For an integer set S, the subset D of S is defined as a

Session warehouse receiving and phpsession warehouse receiving Session_set_save_handler (callback open, callback close, callback read, call write, callback destroy, callback gc)   Execution time and usage of each parameter Callback Function

Oracle sys_context () function, oraclesys_context The first parameter is 'userenv', which is fixed. The second parameter is also fixed, but multiple options are fixed. The optional values are as follows: Select sys_context ('userenv',

Database and database LearningConcurrent Control Task Correctly schedule concurrent operationsEnsures transaction isolationEnsure Database Consistency Multi-User Database SystemDatabase systems that can be used by multiple users at the same

Report development instance-dynamic multi-level KPI drilling report (II), kpiii InReport development instance-dynamic multi-level KPI drilling report (I)In, we talked about the scenario where dynamic hierarchical reports require hierarchical

Mongodb study notes, mongodb Summary of Mongodb study notes over the past few days /*** Get login client * @ author xuyw * @ email xyw10000@163.com * @ param host * @ param port * @ return */public static login client getlogin client (String host,

Date and Time storage and processingThis section summarizes the knowledge about date and time that are frequently used in databases.Because the character set has an effect on the date and time, this is the first thing we need to pay attention to,

MySQL study note _ 4_MySQL create a data table (below) and study note _ 4_mysqlCreating multiple MySQL Data Tables (below) V. Data Table types and storage locations 1. Unlike most databases, MySQL has a storage engine concept. MySQL can select