Database Administrator

Simple use of merge commands in Oracle Merge command With this merge, You can execute the inserts and updates operations on a table in an SQL statement at the same time. You can use the meger statement to merge two specified tables. The syntax is as

SQL Server clustered indexes are converted in functions and even fail (CASE ), During the latest phase I optimization, the first N most time-consuming statements in the database are queried! SELECT TOP 10 qp.query_plan,qt.text,total_worker_time

[Introduction to algorithms] 12th skip table, Introduction to algorithms skip This section introduces a new data structure-Skip table. A skip table is a simple and interesting data structure for dynamic search. It is easy to implement and ensures

Catalyst Optimizer, catalystoptimizer For more information, see ChenZhongPu's Gitbook:Https://www.gitbook.com/book/chenzhongpu/bigdatanotes/details The Catalyst of Spark SQL is easy to expand. It also supports rule-based and cost-based optimization

Xtrabackup stream backup and recovery, xtrabackup backup Xtrabackup is one of the most common tools for MySQL database backup. Provides full backup, Incremental backup, database-level, table-level backup, and so on. There is also a backup that is

Xtrabackup automatic restore script v2 and xtrabackup script v2Xtrabackup Automatic Restoration**************************************** **************************************** ****************Application scenarios:***********************************

Solve the problem that Mac OS 10.10 php cannot connect to mysql, 10.10 mysql There is no problem connecting php to the database. After upgrading to 10.10, the connection suddenly fails. This problem has been put on for a long time. Today, I suddenly

ORA-19815, Flashback Logs-Space management, ORA-19815, Flashback Logs-Space management (Doc ID 369755.1) Applicable:Oracle Database-Enterprise Edition-Version 10.1.0.2 to 11.2.0.3 [Release 10.1 to 11.2]Information in this document applies to any

[Translated from mos] restore a failed primary database to a physical standby database, Restore a failed primary database to the physical standby database Reference:Step by Step Guide on How To Reinstate Failed Primary Database into Physical Standby

[The log of the database 'tempdb' is full] The latest solution, tempdb logThe log of the database 'tempdb' is full.Execute SQL statements. Temporary tables are not used in the middle.Prompt server: Message 9002, Level 17, status 2, Row 1The log of

CentOS6.5 _ 64 bit compiler installation MySQL-5.6.23, centos6.5mysql Reprinted please indicate the source: http://blog.csdn.net/guoyjoe/article/details/44785511 **************************************** ********************CentOS6.5 _ 64bit compile

ORACLE 11G traverses the cursor in the stored procedure, calls the scheduled execution of job tasks, and 11 gjob Cursor traversal and scheduled job execution in ORACLE stored procedures  1. First, use the For Loop For Loop is a simple and practical

Plsqloracle_home solution cannot be identified by plsql on 64-bit ORACLE clients1. Problems Plsql has only 32-bit programs so far, and most desktop systems use 64-bit windows operating systems. On 64-bit windows, in most cases, the 64-bit ORACLE

Experiments on free and bad data blocks:Use dbv to check data files[Oracle @ orahost ~] $ Dbv file =/oracle/oradata/orcl/users01.dbfDBVERIFY: Release 10.2.0.5.0-Production on Tue May 6 06:48:02 2008Copyright (c) 1982,200 7, Oracle. All rights

Data splitting-Management and Maintenance of Mysql partition tables For more information about Mysql partition tables, see: Http://blog.csdn.net/jhq0113/article/details/44592865 For details about how to create a Mysql Partition Table,

MongoDB UTC time problem, mongodbutc time When a batch of data is imported by accident, it is found that the date seen in MongoVUE is 8 hours less than the actual date, because MongDB uses UTC time (Coordinated Time) If you want to display it

Why study Oracle technology ?, Learning Oracle technology? As we all know, Oracle accounts for more than 48.1% of the market share in the enterprise database field and has become an absolute leader in high-end enterprise database software. With

Several errors and solutions encountered during manual creation of Oracle, oracle Solutions There are a lot of errors when you create an Oracle database manually. This process is really disappointing. But when you see that the database is

Who can provide specific practice instances for the mysql high-availability architecture !!!, Mysql Architecture Currently, mysql high-availability architecture is only available in solution 4, as shown below, but there is no specific practice. Can

Mysql "net" is neither an internal command or an external command, nor a program that can be run. I have not used mysql for a long time. I went to struts2 last night to work on the small bbs project, used the database, started it, and input net