Database Administrator

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

How to install and configure MariaDB10.0.14 in CentOS 7 System Environment: CentOS 7MariaDB version: MariaDB 10.0.14: Http://mirrors.neusoft.edu.cn/mariadb/mariadb-10.0.14/source/mariadb-10.0.14.tar.gzOther package address: https://downloads.mariadb.

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

Fast Switchover in Data Guard, some suggestions for Failover In fact, Failover and Switchover are both a headache and a key process for everyone to deal with disasters. Assume that you are sleeping in the middle of the night, and you are awakened by

MySQL database migration MySQL database migration (direct migration of data files) In late October this year, the company's servers needed to be migrated, which involved MySQL database migration. Check the MySQL data file size, which is close to 60

SQL Server 2014 SP1 NOLOCK command interrupted In the Cumulative Update #6 Update for SQL Server 2014 SP1, The NOLOCK command is interrupted. Therefore, databases dependent on the NOLOCK command may experience congestion or deadlocks in other places.

Oracle uses RMAN for data migration Overall process: perform A hot backup for the database of machine A, and perform A full backup. Then, use the scp command to upload the backup to machine B, stop database A (note that archive is not triggered when

Range of the interval partition store in Parameter Oracle 11g introduced interval partitions. In the past, partitions were manually or semi-automated scripts to implement partition expansion. However, the emergence of such interval partitions

MySQL basic learning Summary1. Basic concepts of MySQL The logical architecture of mysql is as follows: Each client connection will have a thread in the server, and the query of this connection will only be executed in this separate thread. MySQL

ORA-00257 archiving logs full resolution April 3, 2016 Customer environment: Linux + RAC Client account login, error prompt: ORA-00257: archiver error. Connect internal only, until freed   Use PUTTY to connect to the server Enter the Oracle account:

Notes for installing the lnmp environment by bogo Video tutorial address: https://chuanke.baidu.com/v5659343-234411-1698133.htmlCreate a virtual machine Note: After the configuration is complete, click Finish (the reason is that the selected

RBAC introduction _ dynamic node Java school arrangement, rbacjava What is permission management? Permission management is basically required for systems involving users. permission management belongs to the category of system security. permission

One of the differences between MySQL and Oracle is the data type mysqloracle Data Type No. ORACLE MYSQL Note 1 NUMBER Int/DECIMAL DECIMAL is a structure such as NUMBER (). INT Is NUMBER (10), which

 : Http://dev.mysql.com/downloads/mysql/5.6.html#downloads Select "Source Code"   2: necessary software packages Yum-y install gcc-c ++ gcc-g77 autoconf automake zlib * fiex * libxml * ncurses-devel libmcrypt * libtool-ltdl-devel * make cmake 3:

The problem encountered today had been resolved after a long morning. As recorded here, I think this Code can be applied to many similar problems. Requirement Description: A table named MyImage has the following columns: Number ID and PATHFor

Table B: 3 million, primary key IDDelete records with ID = Table A IDs from Table B.Delete from B WHERE EXISTS (SELECT 1 FROM (SELECT ID FROM (SELECT T. ID, rownum rn from a) where rn> 0 and rn However, the execution plan shows that the COST is

I recently heard that mongodb is very popular, so I downloaded and learned something about mongodb. I will discuss it later. My machine system is ubuntu13.04. There are two ways to install mongodb: 1. Download the tar-gz package, decompress it, and

However, software resource restrictions do not change much, especially process/file, which correspond to nproc and nofile respectively.Nproc can be queried by ulimit-u; nofile can be queried by ulimit-n.Here, we will introduce/etc/security/limits. d/

The ASM instance has many special parameters. We recommend that the ASM instance use spfile instead of the initialization parameter file. For example, when adding or deleting a disk group, the asm_diskgroups parameter will be automatically