Database Administrator

Deep understanding of Oracle sequence Oracle Sequence: Sequence creates, uses, modifies, and deletes data. Sequence is an object used to generate continuous integer data. A sequence is often used as a growth column in the primary key. It can be

Meaning of using the optimizer_mode parameter in Oracle Oracle uses the Optimizer_mode parameter to control the optimizer preferences. 9i has several common parameters: first_rows, all_rows, first_rows_N, rule, and choose. 10 Gb is less than rule

Stored Procedures for completely copying table structures in Oracle Recently, when dealing with an Oracle table sharding problem, we need to create an automatic table sharding Stored Procedure for the program. We need to ensure that all the table

Usage and summary of Oracle Materialized View What is a materialized view? Materialized View is a database object that contains query results. It is a local copy of remote data or used to generate a summary table based on the sum of data

MySQL getting started Operating System: CentOS 6.7MySQL version: 5.6.30 1. Preparations 2. System Configuration 3. CMake compilation Configuration 4. make & make install 5. Subsequent configuration and Testing Reference 1. Preparations First,

Impact of the resource role on the quota of the quota tablespace Two days ago, I saw a brother in the Forum saying that the user set the table space's quota, but the data volume that exceeds the quota can still be inserted into the tablespace. I

MySQL database instance Parameter comparison script How to compare the parameters of two MySQL instances is usually the requirement in production. Recently, a python script has been written to achieve this requirement. Script #!

TimesTen reconstruction of the backup machine standard operation [TimesTen O & M] During TimesTen's O & M process, rebuilding the slave is the most frequently performed operation in daily O & M. Here we record the operation steps for rebuilding the

Set the MySQL character set to utf8 in Ubuntu Set the MySQL character set to utf8 in Ubuntu 1. mysql configuration file address/Etc/mysql/my. cnf 2. Add the following code below [mysqld][Mysqld]Init_connect = 'set collation_connection = utf8_unicode_

Install MongoDB 3.0.2 in 64-bit CentOS 6.2 Mongo is easy to manage using yum, as long as you create/etc/yum. repos. d/mongodb-org-3.0.repo, write: Mongodb-org-3.0Name = MongoDB RepositoryBaseurl =

In-depth analysis of MySQL logon principles The first step in using the MySQL database is to establish a connection and log on, and then execute the SQL command above. Whether it is through the MySQL client, or through the C-API, JDBC standard

Install MongoDB on Linux Install MongoDB on Linux. 1. Download the installation package and decompress tgz (the installation on 64-bit Linux is demonstrated below ). Curl-O https://fastdl.mongodb.org/linux/mongodb-linux-x86_64-3.0.6.tgz # download

Introduction to deadlocks in SQL Server Introduction What is a deadlock? In my opinion, the deadlock is because two objects apply for another resource when they have one resource, and the other resource is exactly what the two objects are holding,

Oracle manages disk space and resources1. Recoverable space allocation 1.1 learn about recoverable space allocation Generally, we initiate a large database operation, such as creating a large table index. If the tablespace is insufficient, the

In-depth understanding of the underlying implementation of MySQL This article comes fromGitChatFor more information, see "understanding the underlying implementation of MySQL" and "read the original article. 「 High energy at the end of the

Summary of common JDBC interfaces and summary of jdbc This article mainly introduces common JDBC interfaces. Let's take a look at the specific content below. 1. Driver Interface Each database Driver must implement the Driver interface. When writing

Examples of the Mybatis paging plug-in are described in detail. Examples of Mybatis paging plug-ins 1. Preface: We know that in MySQL, paging SQL is implemented using limit. If we write SQL by ourselves, there is certainly no problem with paging.

Simple Application of SQL server public expressions and SQL I. Preface　　 Currently, An orm framework is basically used for project data access. It shields underlying data access forms in the form of object-oriented, allowing developers to focus more

-- Create a tableDrop table test cascade constraints;Create table test (a varchar (30), B VARCHAR (30 ));-- View specific PermissionsSelect distinct privilege from DBA_SYS_PRIVS where privilege like '% DIRECTORY % ';-- Authorize SCOTT with SYS

View the ASM disk status SQL> select group_number, disk_number, mount_status, header_status, mode_status, state, failgroup, total_mb, free_mb, name, path from v $ asm_disk; View the situation of the ASM disk groupSQL> select group_number, block_size,