Database Administrator

Oracle media sorting before 10 GB Sort out the official Oracle 10g media for friends who need it. Oracle9i Database Release 2 Enterprise/Standard/Personal Edition for Windows

GreenPlum database fault recovery test This article describes gpdb master fault and recovery testing and segment fault recovery testing. Environment Introduction:Gpdb version: Binary version 5.5.0OS: CentOS linux 7.0Master segment: 192.168.1.225/24

Win8 64-bit connection to oracle Database Using plsql developer, win8plsql Problem: When plsql developer is used on a 64-bit win8 system to connect to a local oracle database, an inexplicable problem may occur. The error prompt box may even be blank.

Redis for beginners (3) -- using Redis as the cache of Mysql database, redismysql After the Mysql result set is cached in the Redis string or hash structure, we are faced with a new problem, such as what these strings or hash names are, that is, how

[Test] database system principle (II)-detailed explanation (database design and ER Model), database system principle er Everything has a lifecycle. Of course, the database system is no exception! The database design and ER model chapter mainly

The project team needs to install Oracle on a remote HP minicomputer. The hardware information of the system is as follows: The software information is as follows: 1. Download the correct Oracle Installation version HP-UX can run on HP's own

Problem Environment:1. Database version: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit Production2. Operating System Environment: Windows 7 flagship edition 64-bit3. Four Oracle database software (four database software, not four

Database System Principle-ER model and relational model, database system principle er The database system is a type of software, and the database system naturally has its own life cycle-lifetime. Its survival period starts from planning to

Install postgreSQL + postGIS in the production environment The production environment is as follows: Operating System: CentOS release 5.5 (Final) Installation required: Postgresql address: http://www.postgresql.org/ftp/source/ PostgisAddress:

In-depth understanding of MySQL 5.7 GTID series (II): GTID-related internal data structure, mysqlgtid Author:Gao Peng (Eight monsters in Chongqing) Original article address: Https://www.jianshu.com/p/5649644fdc13 I have a deep understanding of

Global Database ranking in December 2017: the decline of SQL Server was remarkable. MariaDB, which was just invested by Alibaba, performed well. Program ape (No.: imkuqin) yuanmei Compilation Source:

Database Design-Data Flow Diagram (DFD) and data flow dfd1. Data Flow Diagram definition data flow diagram (DFD) is a tool used in structural analysis. It graphically depicts the process of data flow and processing in the system, because it only

Introduction:Reference a section in the MySQL official document: the MERGE storage engine, also known as the MRG_MyISAM engine, is a set of identical MyISAM tables that can be used as one. "same" means that all tables share the same column and index

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 ---------------------------------------------------------

Quick grasp of Oracle Golden Gate 650) this. width = 650; "id =" aimg_104370 "src =" http://www.bkjia.com/uploads/allimg/131228/21511KO9-0.jpg "zoomfile =" http://www.bkjia.com/uploads/allimg/131228/21511KO9-0.jpg "file ="

You need to know that the thread wait time is an important factor restricting the efficiency of SQL Server. This article will learn how to collect information such as the thread wait time and type in SQL Server, this information is the basis for

Fault symptom: 1. Computers are running slowly and cannot be manipulated. 2. The web programs supported by the data source are down, and the Error exposed is: Connection timeout. 3. There is no problem connecting to the database locally, but the

Case study: Create a 20 GB tablespace In the DB2 database of the AIX system. The specific SQL statements are as follows: CREATE REGULAR TABLESPACE HTDC_DATA PAGESIZE 8 K MANAGED BY DATABASE USING ( FILE ’/db2_tag/TABLE_SPACES/HTDC_DATA/HTDC_

Recently I encountered a problem with the mysql5 database. Is a standard servlet/tomcat network application that uses mysql databases in the background. The problem is that after one night of standby, the first login on the next morning always fails.

From the perspective of users and developers, Windows Phone 7 brings us many new and exciting features. At the same time, the current Windows Phone 7 series does have shortcomings that disappoint many users. One typical pity is that Windows Phone 7