Database Administrator

The permission system of the oracle database includes system permission and object permission. Database system privilege allows users to execute specific command sets. For example, the create table permission allows users to create tables, and

In general, we understand that after the logbackup chain is broken, a complete backup is required before a new log backup starts. In fact, it is not necessarily necessary to complete the backup, and differential backup is also possible.     First,

Using mysqldump in linux to back up a mysql database as an SQL FilePhase 1: Completely backup mysqldump-h IP address-uusername-ppassword-A> ~ /Name. SQL in this case, the entire database (structure and data) is exported and backed up into an SQL

MySQL 5.6.10 official version has been released for many days. MySQL 5.6 adds the partition replacement function. Today, let's try out the partition replacement function.Two example tables: t1 is a partitioned table and t2 is a normal INNODB table.

The following is the configuration and monitoring of the SGA big page on the AIX platform. 1. Page size supported by aix AIX supports four types of page sizes, but not every hardware platform supports four types at the same time. You can use the

Is Chinese character encoding always difficult for a well-known mysql database? This article uses mysql5.5 as an example. The installation method is considered here. To ensure that the program smoothly inserts data into the database without any

Here, we use the LVM Logical Disk for speeding backup of Mongodb. mongodb has reached dozens of GB or more. The speed of using the mongodb tool for backup will make us feel quite slow, at this time, we can perform LVM snapshot backup in the data

Tree-structured data is common in project development. For example, it is typical for Forum topic messages. Each topic node) can have n message subnodes ). These messages can have their own messages. Therefore, this structure is a tree. This article

Single Instance for RMAN backup and recovery] Topic: simple use of RMAN]I. rman backup operations:1. Log On As an oracle user. First, check whether the/u02/rman directory exists.2. log on to rman using the sys user and the password oracleRman target

Oracle10g client tool plsql link Server Configuration Oracle10g client tools, such as plsql, have many problems in connecting to the server on the network, and often encounter many inexplicable problems. In fact, it is not the configuration of

Before introducing the group by and HAVING clauses, we must first talk about a special function in SQL: aggregate function, such as SUM, COUNT, MAX, and AVG. The fundamental difference between these functions and other functions is that they

1. Check whether you should use a MySQL cluster. Reduce the pressure on the data center nodes and process large data volumes. MySQL is distributed and one or more applications correspond to one MySQL database. Share data with the common data of

ORACLE accesses the SQL SERVER database with an article titled Oracle heterogeneous service practices.But it does not show how to configure access to multiple SQL Server databases.Suppose we want to access the default pubs and Northwind databases in

  I believe that many system administrators are doing the same job every day-backing up data. Once the system fails and data recovery is required, the system is powerless. It would be nice to set a fixed time every day for the system to

1. Create an informix group and an informix user; 2. Modify the $ HOME/. profile file of informix, and add:INFORMIXDIR =/usr/informix (main directory of informix) PATH = $ PATH: $ INFORMIXDIR/bin Export INFORMIXDIR Export PATH 3. modify the

The core architecture of Informix Dynamic servers is designed to provide built-in multi-clue and parallel processing capabilities.Multi-clue On the database server, the Informix dynamic server uses an adjustable database server process pool called a

1. Accelerate SQL Execution 1. Use sort or join in the select statement If you have sorting and join operations, you can first select data to a temporary table and then process the temporary table. Because temporary tables are created in the memory,

Affected Systems:Oracle Database 9.2.0.0-10.2.0.3 Description: Bugtraq id: 17426 Oracle is a large commercial database system. Oracle 9.2.0.0 to 10.2.0.3 allows users with only SELECT permission in the base table to insert, update, and delete data

First, check the status of the system through some tools of the operating system, such as CPU, memory, swap, and disk utilization. Based on experience or compared with the normal status of the system, sometimes the system seems idle on the surface,

Preface The increasing demand for distributed applications requires a better distributed software environment, which constantly promotes the development of distributed technology. Oracle Data replication is a technology that implements a