Database Administrator

Restoration Methods for deleting online redo logs of Oracle databases The online redo log of the Oracle database contains Operation Records of all data in the database. We can use the redo log to perform many operations, such as log

MySQL loose index scan As we all know, InnoDB uses the index organization table (IOT), which is called the index organization table, and the leaf node stores all the data, which means that the data is always stored in a certain order. So the

MySQL composite Partition In the end, it is still open-source software. MySQL's support for composite partitions is far from that of Oracle. In MySQL 5.6, only the RANGE and LIST subpartitions are supported, and the subpartitions can only be HASH

MySQL Incremental backup script (innobackupex) 1. in the online environment, I sometimes write a simple script for Incremental backup of the MySQL database. 2. Add an automatic task and execute it every hour or shorter. #! /Bin/sh # Author RuM #

Oracle online redefinition Before online redefinition of [@ more @] Oracle9i, table data is organized by alter table XXX move [tablespace XX. If the table is very large and IO is not fast, the process of moving may be quite long and cannot be

RHEL6.4 install MySQL 5.6.27 RHEL6.4 install MySQL 5.6.27 Download (temporary address. If not available, please download it from the Oracle website) Use rpm to install mysql Server: Ftp://pepstack.com/pub/rpm/MySQL-server-5.6.27-1.el6.x86_64.rpm To

How to Upgrade Oracle 11g to Orcale 12c Hello everyone. Today we will learn how to Upgrade Oracle 11g to Oracle 12c. Let's get started. Here, I am using the CentOS 7 64-bit Linux release. I suppose you have installed Oracle 11g on your

SQL statement used by MySQL to query duplicate table data MySQL queries duplicate data in a table. For example, to query records with duplicate bar codes in the table, the SQL statement is as follows: SELECT GUIDE_BARCODE FROM checker_barcode

Flash back Version Query Flashback Version Query "Forgetting to back up" is a military rule that impressed the author with the experience of an industry predecessor a few years ago. For DBA, Backup usually refers to "Media Backup", which is a

The SQL statement used to query the data between the nth and NTH rows in the database in SQL SERVER. When writing a program today, You need to generate an SQL statement from the start id to the end id. This function is not required now. In SQL

The MySQL command displays all types available for query, and mysql displays all The MySQL command displays all types available for query. Mysql>? Contents; You asked for help about help category: "Contents" For more information, type 'help ',

Mongodb 3.0 index and set daily operations, mongodb3.0 ----- 1. create an index db. tblorders. dropIndexes (); db. tblorders. createIndex ({"OrderNo": 1 },{ background: true, name: "index_OrderNo"}); db. hisorders. createIndex ({"orderno": 1 },{

[Translated from mos] visit the well-known Data Providers for. NET and mosproviders of Oracle Database Applicable: Oracle Data Provider for. NET-Version 9.2.0.8 and laterOracle Providers for ASP. NET-Version 11.1.0.6 and laterMicrosoft Windows

SQL retrieves fields from two tables to form table data and then inserts it into the function table. SQL Fields It is difficult to describe how to achieve this effect. Here, I will first show the implemented effect in the form of a diagram. This is

Where, having, group by, order by, havinggroup   1. order by is sorted by a field. desc indicates descending order, and esc indicates ascending order.   2. group by is grouped by a field.   3. "Where" is a constraint declaration. Where is used

Use operating system commands to trace and trace listeners Strace tnsping prod Strace tnsping prod 2> & 1 | less Strace-eopen tnsping prod 2> & 1 | grep '=-1' Strace tnsping prod 2> & 1>/dev/null | grep-E '^ stat | ^ open' Strace-e trace = access,

Summary of Oracle functions in the first week of work, oracle functions in the first week 1.Oracle row-to-column and column-to-row The most common principle of Row-to-column conversion is the use of decode functions, Aggregate functions (sum () Max (

How to uninstall oracle11g and oracle11g Oracle 11g R2 x64 Redhat5 (rhel x64) 1. Use SQL * PLUS to stop a database [oracle@OracleTest oracle]$ sqlplus logSQL> connect / as sysdbaSQL> shutdown [immediate]SQL> exit2. Stop

An error occurred while inserting the database emoticons. First you have to look at this blog http://blog.csdn.net/u011575570/article/details/47048101Then handle the insert emoticons in the database.The processing of emoticon is just now utf8,

Databases in SQL Server are transplanted to each other ., Port sqlserver When sorting out BS template materials a few days ago, Shi Ge asked us to publish several websites on the server. I was responsible for the background release of Yonghe cash