Database Administrator

More about AWR AWR is a new feature of Oracle 10g version. Its full name is Automatic Workload Repository-Automatic load information library. AWR compares the statistics collected by snapshot twice, to generate report data. The generated report

Basic operations of mongodb and basic operations of mongodb Install mongodb in http://blog.csdn.net/u011575570/article/details/47791135Including linux and WindowsThe following are some basic operations:/Usr/local/mongodb/bin/mongo # Start

SQL Database Upgrade process-solve the WMI Service cannot be linked process, sqlwmi The trial period of the previously used SQL SERVER database is reached, and the database cannot be opened, prompting that the database has no permissions. I believe

MySQL uses the bat command to back up the mysql database in windows, batmysql Preface: My friend said that the backup failed with the bat command under windows. He could not find the problem at the moment, so he asked me for help. In fact, I have

In 2015, the xinxing Redis tutorial was released, which is the win version of Oracle and Xinxing redis.Recently, thanks to the busy schedule, the Xin Xing tutorial has been suspended for a longer period of time. I am sorry here, but many of my

Combined server test (1) and combined Server TestServer test (1) 1) Advance rehearsals of some services on the Intranet, such as level or point ranking information, pvp data, and pve level ranking. 2) create at least two databases in the intranet

Excel reads database tables and excel reads Databases The following code is used to read the table fields of a database using an Excel macro. Public Sub getdata () Dim cnn As New ADODB. connection, sh As Worksheet Dim rs As New ADODB. recordset Dim

SQL optimization skills (Oracle), SQL optimization skills oracle SQL optimization tips (1): Connection sequence in the Where clause: oracle parses the where clause in order from bottom to top. According to this principle, the connection between

Detailed description of pessimistic locks and optimistic locks in the database; Detailed description of the Database There are two types of locks in data: Pessimistic locks and optimistic locks, as well as table-level locks and row-level

MySQL Study -- MySQL tool mysqlshow, -- mysqlmysqlshow MySQL Study-MySQL tool mysqlshowMmysqlshow customers can quickly find the databases, tables in the database, columns or cables in the table.Mysqlshow provides a command line interface

Mysql Master/Slave configuration for read/write splitting and mysql Master/Slave read/write splitting In order to solve a large number of concurrent accesses to large websites, distributed load balancing is far from enough. At the data service

Mysql timer and mysql scheduled task Mysql timer is a mysql event. In actual development, we sometimes need to perform some operations on a regular basis. Most people create a timer using the ScheduledExecutorService class. In this case, when big

MySQL combined with multi-Table update and deletion, mysql combined updateMulti-Table updateIn MySQL 3.23, you can use LIMIT # to ensure that only the specified number of record rows is changed.If an order by clause is used (supported since MySQL 4.0

[Translated from mos] After clicking the finish button, dbca or dbua hang will stay, After the "finish" button is clicked, either dbca or dbua hangSource:DBCA/dbua appears to hang after clicking finish button (Document ID 727290.1) Applicable:Oracle

SQL Server queries all Sundays within a period of time, and SQL Sunday /* Query all Sundays within a period of time @ startdate start date @ enddate end date */declare @ startDate datetimedeclare @ endDate datetimedeclare @ week varchar (20) set @

MySQL (16) ----------- suggestions for massive data volumes, mysql ----------- The following are some important suggestions:1. Select the Correct storage engineTaking MySQL as an example, there are two storage engines MyISAM and InnoDB, each of

MYSQL import and export, mysql Import and Export Database Export all data in the entire database 1. Enter the following in the linux Command Line:? 1 mysqldump -u userName -p  dabaseName  > fileName.sql FileName. It is best to add

Oracle Advanced Programming, oraclesql Advanced Programming Oracle's advanced programming mainly involves the use of the ten objects in the database. Here, I will share with you some of my notes on these skills. Hope to help you! Before reading this

HBase learning Summary (2): HBase introduction and basic operations, hbase basic operations (HBase is a type of Database: Hadoop database, which is a NoSQL storage system designed to quickly read and write large-scale data at random. This document

Download MATLAB and matlabMATLAB-SQL connection technology [pure code] code block Code block syntax follows standard MATLAB code Function conn_matlab dB () % UI 2015.6.27 MATLAB R2013b % function Description: establish a connection between matlab