Database Administrator

Restore Point and flash back database Flash back database and restore origin are two types of data recovery-related functions, they are used to replace restoration by time point to Cancel Changes to the database. Flashback allows you to roll back

Oracle Database Connection detection (Shell) Version 1 Oracle Database Version: Oracle Release 10.2.0.1.0 System Version: Red Hat guest iselinux 5.4 2 detection steps 2.1 write Shell scripts Edit the check_oracle_connection.sh script for a user with

Redis Transaction Processing Current redis version # Redis-cli-vRedis-cli 2.6.4 MULTI, EXEC, DISCARD, and WATCH are the foundation of Redis transactions. 1. The MULTI command is used to start a transaction. It always returns OK.After MULTI is

Restoration Method for Oracle 10g Clusterware Votedisk corruption Votedisk is very important for RAC (10g Clusterware, 11g GI). We call it an arbitration disk, when a node in the RAC cluster fails and the network is disconnected, it determines

MySQL MHA introduction and advantages MHA is the best choice for many enterprises that use MySQL databases for high availability. It is easy to use and powerful, and implements automatic master-slave failover Based on the MySQL replication

MySQL master-slave replication configuration based on binlog The last time I configured the master-slave replication for MySQL was at the beginning of the year, I did not expect to start using MySQL again. If you don't talk much about it, go to the

Nagios monitoring Oracle alert Log script Click Nagios to know how to use it.# Add nagios to the oinstall Group# Usermod-a-G oinstall nagios #! /Bin/shDbversion = 11Bdump

Manually uninstall Oracle Database 11gR2 using the command line There are two ways to uninstall Oracle: one is to automatically uninstall Oracle using DBCA, and the other is to manually uninstall Oracle using commands. The following describes the

Mybatis executes the query statement and can query data in plsql, but cannot be found in the program. mybatisplsqlWhen you use mybatis to query statements today, the SQL statements output by the console can be correctly executed in plsql, but no

Connect to Mysql in Qt5.4, QSqlDatabase: QMYSQL driver not loaded but available, qsqldatabaseqmysql First from the help of this foreign god http://seppemagiels.com/blog/create-mysql-driver-qt5-windows, at the same time I hope that my blog can help

SQL Optimization-logical Optimization-view rewriting and equivalent predicate rewriting, SQL Predicate 1) view Rewriting View type: A) a view constructed in SPJ format is called a simple view. Create view v1 as select x, y, z FROM t; B) A

Oracle Advanced queue introduction, oracle queueOriginal link: http://www.oracle-developer.net/display.php? Id = 411Oracle Advanced queue IntroductionAdvanced Queue (AQ) is available in multiple oracle versions. He is an oracle native messaging

For beginners of PostgreSql, learn the basic commands and summary of postgresql 1. log on to the database through the command line There are two methods: one is to directly execute the psql command under the system shell; the other is to first enter

JAVA connects to SQLServer basics and reads and writes 0.2 million data records (0.4 million operations) within five minutes. The qlserver First, the most basic connection method: private String url = "jdbc:odbc:Driver={SQL

The atomicity of MongoDB upsert operation concurrency, mongodbupsert When C ++ is used to perform the update operation on MongoDB, if the upsert parameter is set to true, data that does not exist is automatically inserted. In a high concurrency

Shell operations on mongodb and shellmongodb Want to query MongoDB data through shell Many people on the Internet say that mongoDB does not support shell. I basically agree with this statement; But the project needs to be done, and I have to

Description of dbfsize output and dbfsize output [Oracle @ rhel63single test] $ which dbfsize/u02/app/oracle/product/11.2.0.4/db_1/bin/dbfsize [oracle @ rhel63single test] $ [oracle @ rhel63single test] $ [oracle @ rhel63single test] $ [oracle @

SaveChanges (false), savechangesfalse This is a problem I encountered when I was working on the project. After searching for half a day, I found an english blog and introduced it. I still don't understand it. Below are some of my translations of the

Detailed introduction of WAL mechanism in SQLite, sqlitewal Mechanism 1. What is WAL? The full name of WAL is Write Ahead Logging. It is a mechanism used in many databases to implement atomic transactions. SQLite introduced this feature in version 3.

A Preliminary Study on compilation of oci and a preliminary study on oci0. Preface Let's continue with the story in the previous article and let us walk into the magical oci.I. Concepts of oci ORACLE Call Interface (OCI) provides a set of Interface