Database Administrator

New Features of Oracle 11g: User rename Oracle Data is constantly changing during project development. Therefore, we need to regularly import the development database to the test database. The common practice is "trilogy :" 1. Export data from exp

How to install Oracle 10g on CentOS 6.6 _ x64 The CentOS 6.6 system used in this experiment. The database is Oracle 10 Gb. Centos: CentOS-6.6_X64-bin-DVD1.iso Oracle Database Version: 10201_database_linux_x86_64.cpio.gz To install the Oracle

MongoDB replica set implementation and read/write splitting In the previous article "building an instance in MongoDB master-slave mode", we briefly introduced how to build a master-slave Mongodb server environment. However, Mongodb does not

Why cannot I enable ADG for Oracle 11g slave database? Today, we have encountered a strange problem, but there is an essential cause and effect behind the strange phenomenon.During an Environment check in the afternoon, it was found that the standby

Setup of MySQL/MariaDB Galera cluster in Linux MariaDB Introduction MariaDB is a MySQL Branch maintained by the open-source community. It is developed by MySQL founder Michael Widenius and uses a GPL license. MariaDB is designed to be fully

Install PostgreSQL 14.04 on Ubuntu 9.2 I. Environment Vmvm NAME = "Ubuntu"VERSION = "12.04.4 LTS, Precise Pangolin" Ii. Process 1. Install make. Do not install make now. # Apt-get install make # Make -- versionGNU Make 3.81Copyright (C) 2006 Free

InnoDB RR isolation level insert select two deadlock case analysis, innodb Case Analysis Author:Gao Peng (Eight monsters in Chongqing) School draft:Master Ye (some content is fine-tuned) Original article: http://blog.itpub.net/7728585/viewspace-

Database selection of different business logic constraints and database business logic Constraints I think the constraints on data tables are still very useful. At least there are many database optimizations, which can greatly improve the retrieval

Qt implements cascading deletion of sqlite3 and qt implements sqlite31. there are two required tables: the barcode table and the product details table. The rfid in the barcode table is the rfid foreign key in the product table, you must delete the

HBase learning Summary (4): How HBase works and how hbase works I. Split and allocate large tables HBase tables are composed of rows and columns. HBase tables may contain billions of rows and millions of columns. The size of each table may reach TB

A small example of redirecting data files under asm (using the toad tool), asmtoad Original works, from the blog of "Deep Blue,Deep Blue blog: http://blog.csdn.net/huangyanlong/article/details/46863991   Scenario: in the production environment, you

SQL Server Batch processing (Batch Requests/sec) high tracking processing, batchrequests Recent observations showed that the number of Batch processing Requests per second (Batch Requests/sec) of a database often increased for a long time, several

MySQL Optimization-view and mysql View Reprinted please indicate the source: http://blog.csdn.net/l1028386804/article/details/46761521 What is the reason for using the view? 1. Security: This is generally done: Create a view and define the data

Performance case 02 -- sybase connection blocking, 02 sybase Symptom:Recently, a problem was reported on the site. during the approval process, the system often gets stuck. The whole system is useless and the browser access is in the loading state.

Installation and uninstallation of Oracle11g and use of common tools, oracle11g installation and uninstallation Installation and uninstallation of Oracle11g and use of common tools Purpose: (1) master the installation and uninstallation processes of

What is the difference between MyISAM and InnoDB Storage engine? myisaminnodb Storage 1. MyISAM does not support advanced transaction processing, whereas InnoDB does. 2. MyISAM emphasizes performance and speed, while InnoDB provides advanced

MySQL-10 configuration items that must be adjusted for newly installed MySQL (episode) and 10 configuration items for MySQL Reprinted please indicate the source: http://blog.csdn.net/l1028386804/article/details/46324419 I am still worried about the

Oracle stored procedure execution can input SQL statements and return result sets, oraclesql 1. Create a test table: Create table AAA(Aa NVARCHAR2 (100 ),Bb NVARCHAR2 (100 ),Cc NVARCHAR2 (100 ),Dd NVARCHAR2 (100)) And import the test data insert

Enable HTTPS secure link (SSL) and ebsr12 for Oracle EBS R12 E-Business Suite R12.1.1 provides Advanced Configuration wizards that make it easier to deploy features such as SSL and load-balancing. apps administrators can use these wizards to make

About the meaning of 'controlfile Checkpointed at scn 'in the trace file after the control file is dumped, The meaning of 'controlfile Checkpointed at scn 'in the trace file after control file dumping Controlfile Checkpointed at scn: 0x0000. 0006c3