Database Administrator

New Feature of RavenDB 3.0: Index backend RavenDB indexing is definitely not a simple storage of key/value, and its functions are much more powerful. Just like other features of version 3.0, It is the crystallization of sweat and wisdom. This

Install the MySQL Sample Database Sakila Generally, there is no data available for testing and use on a brand new MySQL server. MySQL provides us with some sample databases for basic operations and stress testing based on these databases. This

An example of solution to system downtime caused by full archiving logs of Oracle databases When the first downtime occurs, the system memory overflows. Therefore, the application server is restarted and an error is reported when the application

Configure HugePage in Linux For Oracle database servers with large memory, it is necessary to configure HugePage. The following describes how to configure Huge: My environment: OS: CentOS release 6.4 (Final) Oracle: 11.2.0.4 RAC HugePage needs to be

Considerations for installing MySQL source code scr. rpm The rpm installation package is usually a Binary package or a Source package. When using the source code to install MySQL, the source code package downloaded on the official website is usually

Oracle Error: ORA-00119/ORA-00130 When Oracle is started after the Server IP address and host name are changed, the following error occurs: SQL*Plus: Release 11.2.0.2.0 Production on Wed Nov 14 13:51:39 2012  Copyright (c) 1982, 2010, Oracle. 

ORA-27102: out of memory 64bit RedHat Linux, [Oracle @ DB ~] $ Uname-Linux DB 2.6.32-279. el6.x86 _ 64 #1 SMP Wed Jun 13 18:24:36 EDT 2012 x86_64 x86_64 x86_64 GNU/Linux The physical memory is 16 GB. When the SGA allocates 4 GB memory, the instance

Shell script instance for creating a tablespace in Oracle Shell script instance code for creating a tablespace in Oracle: #! /Bin/bash# Ocpyang@126.com# Create tablespace If [$ #-ne 2]; thenEcho "Usage: $0 TABLESPACE_NAME TABLESPACE_SIZE"Exit 1Fi #

Check whether Oracle is 32-bit or 64-bit (x86 or x64) How to check whether Oracle is 32-bit or 64-bit (x86 or x64 ). Method 1: Use sqlplus ### 64-bit:[Oracle @ db01 ~] $ Sqlplus/as sysdba SQL * Plus: Release 11.2.0.3.0 Production on Fri Oct 3 18:44:0

Mysql generates a complete Stored Procedure Definition Statement. mysql Stored Procedure Select concat ('pr _ ', p. db ,'. ', p. name) FileName, CONCAT ('delimi', 'TER $ USE '', p. db, ''$ drop procedure if exists'', p. name, ''$ create definer = ',

Create MySQL slave database and MySQL We know that Oracle has DataGuard to back up data in real time, which can be used for master-slave switchover. MySQL also has its own backup database solution, which is called master-slave replication. The

Splunk meeting Review: The Key to big data is machine learning. splunk Review Jonathan Allen, author The Splunk User Conference is coming to an end. During the three-day conference, over 160 topics were discussed, covering security, operation,

Oracle Foreign Key usage (1), oracleforeign Oracle Foreign Key usage (1)1. Objectives Demonstrate how to use a foreign key in an Oracle database 2. What is a foreign key? 1) in Oracle databases, foreign keys are one of the methods used to achieve

CentOS 6.5 install MongoDB 2.6 (multiple yum data sources) and centosmongodbNext we will install the latest MongoDB 2.6.5 on CentOS 6.5 x64. There are a total of five packages in the MongoDB v2.6.5 software warehouse:1) mongodb-org This package is a

64-bit oracle databases cannot be connected with 32-bit plsql developer (oci. dll cannot be loaded), plsqloci. dll Install the oracle database in a 64-bit operating system and download a new 64-bit database (if the 32-bit database is installed on a 6

An additional column of serial numbers is automatically added to the SQL statement query results, and an SQL column is automatically added. Sqlserver It can be implemented using the row_number function. As follows: SELECT *, row_number () OVER

Sqlplus is prohibited in Oracle db. Record it first: How to Disable a SQL * Plus Connection for a User (Documentation ID 124121.1) Use the sqlplus/nolog command in the DOS window to log on to oracle. The result is similar to "sqlplus is not an

HIVE 0.11 and hive0.11bugHIVE 0.11 bugTwice {group by} bug https://issues.apache.org/jira/browse/HIVE-5149 SELECT key, COUNT (*) FROM (SELECT key, value, COUNT (*) FROM src group by key, value) aGROUP BY key; It is characterized by two group by

Shell to export each mysql stored procedure as a single file, # Shell implementation: export the Stored Procedure Code in mysql as the file dbcn = "mysql-h172.16.1.194-uroot-p123456"; db = BCReport_Sync_Executor; ii = 0; ct = '$ dbcn-N-e "select

Database backup and recovery, database backup and recoveryBackup and recovery of databases 1. Open SQL Server Management Studio → Database: practice_20.gl is the database we need to back up.2. Right-click the database to be backed up.3. Click