Database Administrator

Patch 11.2.0.3.4 P14275605 PSU for a single Oracle 11g instance 1. Close all instances SQL> shutdown immediate 2. Disable all listeners $ [Oracle @ ora_11g test01] $ lsnrctl stop 3. Disable all background sqlplus [Oracle @ ora_11g 14275605] $ ps-ef |

MySQL Benchmark Test Tool MySQLSlap instance MySQLSlap is a benchmark tool provided by MySQL. It can be used without installation. The following describes how to use MySQLSlap to perform basic MySQL tests on the server. 1. cd/usr/local/mysql/bin/ Go

MySQL database Optimization How should we optimize the MySQL database? Next I will explain this problem from MySQL's hardware selection, MySQL installation, my. cnf optimization, MySQL architecture design, and data splitting. Optimization of server

Pt-Online-schema-change of MySQL online DDL Tool MySQL DDL:DDL is a feature that makes all MySQL ddbas criticized, because in MySQL, when dDDL is performed on a table, it locks the table. When the table is small, such as less than 1 W rows, it has

One Linux or UNIX Machine Sets multiple DB2 systems before DB2 for Linux, UNIX, and Windows Version 8, SAP customers can only install one copy of each DB2 Version on one physical machine, the installation path is hard-coded. Although DB2 Version 8

Oracle Database provides several data backup methods, but the most commonly used is logical Backup Using exp. Physical backup (including online backup and offline backup) is not used much. The main reason is that the physical backup process is

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

SQL Update multi-table joint Update method, sqlupdate joint Update Sometimes we need to update the data in multiple tables at the same time, then we need to use the following method: (1) sqlite multi-Table update Method Copy codeThe Code is as

Sort the add, delete, modify, and query statements involved in mysql. 1. Create a user: > Create user name identified by 'ssapdrow '; 2. Change the password: > Set password for name = PASSWORD ('fdddfd '); 3. permission management > Show grants for

With 200 lines of code, you can easily implement a simple blockchain and 200 lines of code. Lauri Hartikka The basic concept of blockchain is simple: a distributed database stores an ever-increasing list, which contains many ordered records. However,

1. OverviewThe Oracle EM11g database needs to be migrated. The main steps are as follows: 1. Disable OMS 2. Back up the current database and restore it to the new server. 3. Update OracleEM OMS database connection Configuration 4. Start OMS This

Link: http://www.vpsee.com/2009/08/use-shell-script-to-access-mysql/ In the afternoon, I wrote a simple bash script to test the program and input a test case file, Output the test cases and results that fail the test and save the results to the

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

Recently, due to the surge in archive logs, deleting archivelog all seems to be unable to clear all archived logs. Why? 1. Demo Environment SQL> select * from v $ version where rownum BANNER ---------------------------------------------------------

The OS package and OS patch required for installing oracle database 10gR2 under Solaris 10 or later, sparc10gr2 Reference: Oracle Database (RDBMS) on Unix AIX, HP-UX, Linux, Mac OS X, Solaris, Tru64 Unix Operating Systems Installation and

Advanced applications of Redis-transaction processing, persistence, message publishing and subscription, virtual memory usage, and redis Transaction Processing Iii. Transaction Processing Redis transaction processing is relatively simple. You can

Common tax risk management indicators and tax risk management Through data analysis technology, the risk warning index values are calculated in real time and randomly organized and managed according to business needs to ensure more reasonable and

Redis data persistence, redis dataIn general, there are two persistence solutions: RDB and AOF.The RDB method creates a time point-based snapshot for the dataset at a certain interval.The AOF method records the write operations received by the

Auto-configuration database_console version Restore database, Database Console Error message: Configuration: Cause: the database name "5" is not the actual logical name of the database backup file named "Sdzn" View the actual logical name of the

Oracle is a large database with a C/SClient/Server structure. It is mainly used in the 4GLSQL language and has the advantages of being powerful, simple, and easy to learn. The working process of the C/S structure is: when the client c end) inputs