Database Administrator

Xtrabackup is an open-source project of percona to implement the innodb Hot Backup function similar to InnoDB's official Hot Backup tool. It can quickly back up and restore mysql databases. Xtrabackup contains two tools: Xtrabackup is a tool used

There are two main causes:1. There is a large volume of transactions that allow Oracle Undo to automatically expand, resulting in excessive disk space occupation;2. There are large transactions that have not been contracted or are not committed by

Fault description: Check the df-g space on AIX and check that the undo tablespace of the corresponding database has reached more than 90%. The following process the problem of too large data files in the tablespace. -- 1 check the tablespace size

Currently, most websites using MySQL use Memcache as the key-value cache at the same time. Although such an architecture is extremely popular and there are many successful cases, it relies too much on Memcache to virtually make Memcache the root

Both views and synonyms are the object names in the database. They do not correspond to actual data storage and all depend on the existence of other objects.View: A view can be viewed as a virtual table or storage query. Unless it is an index view,

Function Introduction The DECODE function is one of the powerful functions of Oracle PL/SQL. Currently, only oracle SQL provides this function, and other database vendors do not yet implement this function. What is the purpose of DECODE? First,

The materialized view stores the View query results to a real table based on the query definition. When you query data in the materialized view, Oracle does not search for a specific base table, this will greatly improve the efficiency. First, let's

Environment Oracle 9 Release 2 User sys Test Table Name ATTRIBUTE_TRANSFORMATIONS $ Tables and views in the used data dictionary USER_TAB_COLUMNS: basic organization information of the User table User_constraints: basic user constraint

In the Patchset of Oracle 10g version, only one file Disk1. the size of the Patchset in Oracle 11.2.0.2 and 11.2.0.3 is greatly increased. The Patchset of 11.2.0.2 and 11.2.0.3 is 5 GB. These 5 GB files are composed of seven files. It is a

I. Overview Development Environment: PHP 5.3.0 +/Symfony 1.4.4/DoctrineMongoDBODM 1.0.0/MongoDB 1.4.4 Tip: This article requires you to understand the following content: PHP namespace, Symfony framework, MongoDB, and Doctrine ODM (download ODM)For

1. Exception HandlingA warning and error in pl/SQL is called an exception. Exceptions include compilation exceptions and running exceptions. 2. Exception ClassificationSystem exceptionCustom exception 3. Abnormal Structure ExceptionWhen... then.. 4.

In order to learn, the verify_function function of the database is enabled, and the password expiration time of the default profile is automatically set to 60 days, the password is reused for 18000 days, And the Password meets the complexity

When I started the Oracle service today, I found that listener was unavailable. Use lsnrctl LSNRCTL> start Start tnslsnr: Please wait... TNSLSNR for 32-bit Windows: Version 11.1.0.6.0-Production The system parameter file is d: \ app \ qiao \

An error is reported in the background of the application server today: Java. SQL. SQLException: ORA-01114: IO error when writing blocks to file 201 (block #1015305)ORA-27069: skgfdisp: Try to execute I/O out of file rangeOSD-04026: The passed

I browsed the official Oracle webpage and unofficial ppt pages and briefly understood the high availability solution provided by Oracle. There are three main types: 1. RAC RAC, Real Application Clusters Multiple Oracle servers form a shared

Recently, there are a bunch of Delete statements to be executed. The 34 Delete statements are written as one PROCEDURE for execution, but the execution plan and time of a single DELETE statement cannot be seen during execution, think of using

Install the Oracle database in Linux: 1. Convention: linux System for Linux.5.4-server-x86_64, database for linux. x64_11gR1_database_1013When installing linux, select to install all packages.2. Use the root user to modify the kernel parameters and

1. Sequence creation and description Create a sequence. The syntax format of the Oracle sequence is:Create sequence name[Increment by n][Start with n][{MAXVALUE/MINVALUE n | NOMAXVALUE}][{CYCLE | NOCYCLE}][{CACHE n | NOCACHE}]; 1) increment by is

# Set the execution encoding format to prevent garbled Characters During Chinese Export Export NLS_LANG = "AMERICAN_AMERICA.UTF8" # Load the Oracle client program to the environment variable. Note: This line must be added if the script is placed in

1: Data Export command Declare --- Create a data pump handle H1 number; Begin -- Create a user-defined Data Pump for schema backup H1: = dbms_datapump.open (operation => 'Port', job_mode => 'scheme '); -- Define storage files Dbms_datapump.add_file (