Database Administrator

RMAN backup and recovery-full recovery and Incomplete recoveryGlossary: As the name suggests, full recovery means that the index data has not been lost. Incomplete recovery refers to the loss of some data after recovery. They are two recovery

Oracle 11g R2 rac rman backup script example 1. Switch RAC to archive Mode 1. Modify the archive mode of the database. Generally, archive is configured and the flash back area is used when RAC is installed. you can skip the steps below if you have

Redis (4) for beginners-Sort Redis cache and redis Before implementing the cache sorting function, you must first clarify the rationality of this function. Now that you can sort data in the database, why do you need to put the sorting function in

MonjaDB is a MongoDB GUI client tool that provides intuitive MongoDB data management functions and supports Windows, Mac, and Linux. MonjaDB is an Eclipse plug-in that must be installed first. Main features: Easy to use WYSIWYG edit

Centos7: The correct command for installing mariadb, centos7mariadb The centos7 System of linode is used, and mariadb is used by default when mysql is installed. However, no matter whether you use the linode official website instructions or the

Mysql Performance Check script-mysql Performance Check script #! /Bin/sh# Ocpyang@126.com Export black = '\ 033 [0m'Export boldblack = '\ 033 [1; 0m'Export red = '\ 033 [31m'Export boldred = '\ 033 [1; 31m'Export green = '\ 033 [32m'Export boldgreen

Sqlite study notes 7: Open the database using sqlite in C language, sqlite Study Notes The basic content of the database has been mentioned earlier. Next, let's take a look at how to use sqlite in the C language. Interface 1 sqlite3_open(const char

Transaction Processing and concurrency control, transaction processing Concurrency Control What is a transaction? Is a mechanism, an operation sequence, it contains a group of database operation commands, and all the commands as a whole, together to

Oracle session blocking, oracle sessionSession blocking for a single instance Simulate 232 sessions being blocked by 1224 sessions select * from V$SESSION_BLOCKERS; SID SESS_SERIAL# WAIT_ID WAIT_EVENT WAIT_EVENT_TEXT

The interceptor of mybatis implements statistical analysis of SQL Execution time, And mybatis performs statistical analysis. Reprinted from: http://blog.csdn.net/andyzhaojianhui/article/details/72823055 The idea of the interceptor for mybatis comes

Preface Indexes are one of the most important objects in relational databases. They can significantly reduce disk I/O and logical read consumption and improve the query performance of SELECT statements. However, it is a double-edged sword. Improper

Detailed explanation of Yahoo's MySQL Performance Analyzer, yahoomysql AnalyzerDetailed explanation of Yahoo's MySQL Performance Analyzer Author: chszs, reprinted to be noted. Blog homepage: http://blog.csdn.net/chszs一、introduction Yahoo opened its

1. Prepared hostNode1: 172.16.133.11Node2: 172.16.133.12MySQL has been installed.MySQL installation see: http://5142926.blog.51cto.com/5132926/9356522. mysql master-slave ReplicationNode1: master serverNode2: slave server(1) node1:Enable binary log (

MongoDB data model and index learning summary, mongodb ModelMongoDB data model and index learning Summary 1. MongoDB Data Model: MongoDB data storage structure:MongoDB uses BSON (binary json, binary encoding) data format for document (large files

DB link migration (the password in dblink is unknown), dbdblinkI don't know if DBAs sometimes encounter such a situation where the Public db link is used for Schema migration. However, the target account password in db link is unknown, therefore,

How to deal with the rapid growth of oracle archive logs, oracle archive logs Oracle archive logs are generally generated by dml statements, so the increase speed should be too frequent by dml. First, query the generation of the following daily

Incorrect practice: To port the data in the oracle 9i database to a lower version of oracle 8i, first use the exp command to export the command line in oracle 9i ): Exp username/password @ Global SID file = export database file name owner =

Many parameters can be selected during script generation. reasonable configuration of these parameters makes it easy for us to generate scripts as expected. Script generation options, such: Here is the SQL 2005 option, which is slightly different

I. Introduction Since you and your team have successfully developed and deployed an INTERNET website, this website has attracted thousands of users to register and use in a short period of time, therefore, you have a very satisfied customer.

Migration environment Configuration: Data source:BNET Development Environment Data Server:SunOS v880 5.8 Database:Oracle 9.2.0.4 & DB2 8.2 Migration tool:IBM DB2 Migration Toolkit 1.3I. Table migration 1. Index length limit In DB2, the maximum