Database Administrator

Red Hat Enterprise Server 5.8 + Oracle10g (Chinese interface) Installation Red Hat Enterprise 5.8 is installed under VMware workstation10 (Virtual Machine) Create a virtual machine Create a VM and select the configuration type as-typical

Triggers in Oracle databases A trigger is a special stored procedure that is automatically triggered by the Oracle system when a database event occurs. Triggers are usually used to enhance database integrity constraints and business rules. For

Overview of Oracle DB partition features Overview of Partitions Overview: in Oracle databases, partitions can break into very large tables or indexes into small, manageable blocks ), these blocks are called partitions ). each partition must have

MySQL "Bind on TCP/IP port: Address already in use" Recently, a MySQL instance has been added to the server where MySQL Enterprise Monitor has been deployed. As a result, the MySQL Enterprise Monitor Instance becomes abnormal and cannot be restarted

Database Optimization-create and classify Oracle table partitions When the amount of data in a table increases, the speed of data query slows down, and the performance of applications degrades. In this case, you should consider partitioning the

New Features of Oracle 11g-HM (Hang Manager) In this article, we will introduce the new features of Oracle 11g-hang Manager. We need to note that HM only exists in the RAC database. When we diagnose database problems, we often encounter

Tips for improving PostgreSQL Performance In a (poor) PostgreSQL query, only a small change is required (ANY (ARRAY [...]). to ANY (VALUES (...))) the query time can be reduced from 20 s to 0.2 s. From the simplest use of explain analyze, to the use

Database optimization tutorial (11) Design a beautiful table and database Optimization4. Design a beautiful table The previous chapter describes how to use indexes to accelerate our query statements. This chapter allows us to go back to the initial

DDL_LOCK_TIMEOUT, ddl_lock_timeout The function of the 11g DDL_LOCK_TIMEOUT parameter is literally the timeout time for DDL to obtain the lock. Let's take a look at the introduction of the official documentation: DDL_LOCK_TIMEOUT Property

HMaster startup code analysis for source code analysis of HBase1.0.0 (2), hbase1.0.0hmaster In the previous blog, my code analysis is the startup function of the startMaster core. This article mainly analyzes the corresponding components involved in

Introduction to basic concepts and terms of data structures and algorithms, and introduction to data structures and algorithms In order to get a "common language" with everyone, some concepts and terms are given definite meanings. 1. data: a

[MySQL Notes] Powerful SQL optimization tool and powerful MySQL SQL Tool If you have experience using MySQL, you may encounter slow SQL queries in your project. In some scenarios, you can easily locate the problem (for example, when a single table

Relational Database V. S. Non-relational database, relational database v. sThe most important feature of a relational database is transaction consistency: The read and write operations of a traditional relational database are transactions and

Redis database of NoSQL Database: Redis introduction and installation and deployment, nosqlredisZookeeper NoSQL (NoSQL = Not Only SQL) refers to non-relational databases. With the rise of Internet Web websites, traditional relational databases are

Listener refused the connection with the following error: ORA-12505, TNS: listener does not currently, ora12505When you connect to oacle12c using java, an error is returned:Java. SQL. SQLException: Listener refused the connection with the following

Redis Research (16)-publishing/subscription mode, redis subscription In the previous article, we wrote the Redis task queue. Http://blog.csdn.net/wtyvhreal/article/details/43112735 In addition to implementing the task queue, Redis also provides a

Redis Research (10)-Redis transactions and survival time, redis transactions I. Transaction Overview Redis transactions are a collection of commands. A transaction is the smallest Execution Unit of Redis like a command, either executed or not

SYBASE: sybase Basics (1) Historical versions of sybase; Sybase server 1.0 2.0, Sybase openclient/openserver, Sybase system 10, sybase replication server, Sybase SQL server 11.0, Sybase ase 11.5, Sybase ase 11.9.2, ase 11.9.3, ase 12.0, ase 12.5,

Perform catastrophic recovery-1 and perform disaster-1Perform disaster recovery:[Oracle @ oracle ~] $ Sqlplus/as sysdbaSQL * Plus: Release 10.2.0.5.0-Production on Thu Nov 6 20:23:30 2014Copyright (c) 1982,201 0, Oracle. All Rights

Oracle-rdbms-server-12cR1-preinstall package for OS version determined, oraclerdbms1. automatic configuration of ORACLE12cR1 installation environment In the official ORACLE12C_R1 (E50529_01) documents, in the Chapter "Automatically installing Oracle