Database Administrator

Use Grid Control to quickly deploy Oracle physical Data Guard Grid Control (GC in this article) is a good helper for monitoring and managing databases, and also a double-edged sword. If you are proficient in applications, You can greatly improve the

Storage of FLOAT and DOUBLE types in MySQL In fact, in the single-precision and double-precision floating-point storage, the storage method is consistent with the C/C ++ standard. They are all floating-point type. The so-called floating-point type

How to Improve datapump Operation Performance When performing datapump export and import, do everything possible to improve the performance. Here we will introduce some related DataPump and database parameters that can significantly improve the

MySQL slow query log settings and Analysis The slow query log is used to record some slow query statements, which can help the Administrator analyze the problem. This log is not enabled by default. You need to add a series of parameters in the

Install the cx_Oracle module in Python If you want to access a remote Oracle database and do not want to install a few hundred megabytes of Oracle Client locally (also known as root), the python cx_Oralce module must rely on the Oracle Instant

TimesTen memory fragmentation (high water level) recovery steps Memory is the most important resource in the TimesTen memory database, just like the Oracle database we are familiar with has only one System tablespace; unfortunately, the memory

A simple MySQL performance query script A simple MySQL performance query script is as follows: #!/bin/shmysqladmin -P3306 -uroot -p'password' -r -i 1 ext |\awk -F"|" \"BEGIN{ count=0; }"\'{ if($2 ~ /Variable_name/ && ((++count)%20 == 1)){\ print

Import (Restore) Oracle dmp files to different tablespaces and different users Copy A dmp backup file from the production environment, build a test environment on another computer, and run the imp command to import the dmp file with the following

Combined Query of three MySQL tables Combined Query of three MySQL tables 1. Table Structure1. Image table (storing images) Create table 'tb _ pic '('id' int (11) not null AUTO_INCREMENT COMMENT 'auto-increment id', 'url' varchar (255) default null

Oracle imports the local dmp backup file into the local Oracle database. Oracle imports the local dmp backup file into the local Oracle database. Import syntax Imp usename/password @ SID full = y file = d: \ data \ xxxx. dmp ignore = y Import

Subscription and release of apsaradb for Redis Document directory 1. Why subscription distribution? 2. Subscription publishing in Redis 3. Redis producer consumer 4. Subscription and release in Redis 5. Java Jedis's pitfalls Why subscription

Create a replica set on the MongoDB Cluster 1. Replica Set ConfigurationAfter successfully running MongoDB on a single machine, you need to disable the mongod daemon before using the replica set to create a Mongodb cluster: Mongod -- replSet setname

Features introduced by Oracle 11g ASM 1.1 new features introduced by 11g ASM that affect ManagementThe following features will not be supported when the 10G version of ASM is maintained. However, most features have little impact on ASM maintenance. 1

Set Oracle Internet access in CentOS Environment: CentOS 7 + Oracle 11g r2 Public Network: fixed IP Address Symptoms: port 1521 is normal, netmanager configuration test is normal, plsql connection prompts ORA-12514: TNS: listener does not

Oracle knowledge sorting: More than Oracle Common heap table limitations:Table update with log overhead table deletion with flaws table record too large slow retrieval index back table read overhead large ordered insertion difficult to orderly read

TPCC test for MySQL 5.7 Mysq5.7.7-rc System info:System | Dell Inc.; PowerEdge R620; vNot Specified (Rack Mount Chassis)Service Tag | JX47Z42Platform | LinuxRelease | CentOS release 6.6 (Final)Kernel | 2.6.32-431.23.3.el6.x86 _ 64Architecture | CPU =

How to install Oracle 11g in centos Linux Kernel version: Linux version 2.6.32-431.23.3.el6.x86 _ 64 (1) install Xmanager Enterprise 4 on Windows to connect to Linux machines. Create a new link and use SSH protocol by default. You only need to enter

MySQL source code compilation and installation (5.5 and 5.6 coexist) Introduction: How to run two or more MySQL services simultaneously on one server. 1. MySQL 5.6 Shell> useradd-r-s/sbin/nologin mysql Shell> wget ftp://mirror.switch.ch/mirror/mysql/

MongoDB $ type OperatorDescription The $ type operator is based on the BSON type to retrieve matching data types in the set and return results. The following table lists the types that MongoDB can use: Type Number Remarks

Basic Oracle Database Operations Basic Oracle database operations. All usernames and passwords created by Oracle are bkjia Create user bkjia identified by bkjia Assign permissions to the user name Grant resource, dba, connect to bkjia; Change