Database Administrator

Oracle Database physical file backup/recovery I have written a similar article before. Although it is not a problem to restore the physical files of the Oracle database, I always feel that something is wrong. I learned later that I had some

Solution to ORA-4031 errors In the face of ORA-4031 error, your heart will not send? The ORA-4031 can easily cause an abnormal database crash, which will crash when Oracle's core processes fail to get the Shared Pool memory. Of course, ORA-4031 is

Summary of the process of building physical DG using RMAN remote replication This document only records the setup process. For detailed parameter meanings and configuration principles, refer to the previous summary. Configure the tns of the master

Install MySQL 5.6.23 in Linux Install MySQL 5.6.23 in Linux Create userLog on as a root user and create a mysql user to maintain the mysql service. [Root @ localhost ~] #[Root @ localhost ~] # Groupadd mysql[Root @ localhost ~] # Useradd-g

Install Redis in CentOS 6.6 Notes for installing Redis in CentOS 6.6. I. Introduction Redis is used for database caching, session storage, and message queues. Ii. Installation $ Yum install-y wget gcc make tcl$ Wget http://download.redis.io/releases/

Beckham _ mysql optimization learning, and Beckham _ mysql OptimizationMysql OptimizationBrief:1. Database Design Optimization2. SQL statement Optimization3. Table Segmentation4. read/write splitting technology   I. Database Design Optimization 1.

Oracle pagination for tables without primary keys and Oracle primary key tables Generally, for tables with a primary key that can be used for unique table recognition, we can use the primary key and rownum for implementation. For example: Select

The C language calls the mysql stored procedure and the mysql Stored Procedure This article explains how to call the stored procedure of mysql database in C language. The following is a SC table that stores the course selection records of students,

Error code: 1247 Reference 'starttime' not supported (forward reference in item list), 1247 startTime 1. Error description 1 queries executed, 0 success, 1 errors, 0 warnings query: SELECT. createUserId AS typeId, (select count (c. id) FROM

[Oracle 10g] sqlplus logon error resolved, oraclesqlplus I,When running sqlplus in cmd in win7, the following error is reported: SP2-1503: Unable to initialize Oracle call interface SP2-1503: Unable to initialize Oracle call SP2-0152 Solution:

MySQL logon and mysql Logon1. Question 1: You cannot log on after changing the password using update mysql. user set password = 'root' Solution: perform the following steps. (1) Close mysql (kill the mysqld process) and run the following command:

MongoDB modifies and deletes the domain attribute instance of a document. MongoDB modifies or deletes a file's domain attribute instance During website development, the initial design may be unreasonable or the business changes in the future

MySQL multi-Table query, MySQLI. Use the SELECT clause for multi-table queries SELECT field name FROM table 1, Table 2... WHERE table 1. Field = TABLE 2. Field AND other query ConditionsSELECT. id,. name,. address,. date, B. math, B. english, B.

The kill table session in the lock_rac environment appears in the killed status (solved), _ rackilled Original works, from "Deep Blue blog" blog, deep blue blog: http://blog.csdn.net/huangyanlong/article/details/46876961 Killed state processing

Mysql account permission control and mysql permission Control 1. If we do not use the root account to operate the database, we may often encounter some permission problems. The following provides the simplest solution: Grant all privileges on *.

Simple sqlite performance test, sqlite Performance It mainly tests the performance of sqlite insertion and query in large data volumes: Test environment: Centos6.4 1 GB memory single-core Data Volume Size Index Field Retrieval (Time

Mybatis calls the mysql stored procedure and returns the result set, mybatismysql A result set is often returned in a stored procedure. Mysql directly uses select to return the result set. Oracle uses a cursor to return the result set. This is

Example of mydumper backing up mysql database and mydumpermysql Mydumper is a lightweight third-party open-source tool for mysql database backup. The backup mode is logical backup. It supports multithreading, And the backup speed is much higher than

Several ideas for improving database query speed and several ideas for database querySeveral ideas for improving database query speed:1. Caching: caching on the persistence layer or persistence layer;2. Remove large fields from the database table to

Sedna does not support xml schema and sedna XMLSCHEMA. Book. xsd:   Book. xml: The Call Of Wild