Database Administrator

Issues with CDB User Creation and tablespace allocation in Oracle 12c Database In Oracle12c, the concept of database plug-in is added, that is, PDB, which allows a database container (CDB) to host multiple pluggable databases (PDB ). CDB is called

Compile and install PostgreSQL in Mac OSX Originally, the official installation package was used. However, the installation package will create postgre, which is a bit uncomfortable on the login interface. After searching for a long time, I did not

Misunderstanding of DML's use of parallelism and misunderstanding of DML's use of Parallelism I always think that we can use parallelism for DML. We only need to add the hint of parallel. Actually, no. Using alter session force parallel dml is the

IMU technology and redo private strand Technology in Oracle, imustrand Oracle030 IMU technology and redo private strand Technology in oracle030Oracle 3. Explain the Oracle IMU Mechanism Select * from v $ sysstat where name like '%

Redis cluster _ 1. redis installation, redis cluster _ 1. redisRedis introduction:Redis is a high-performance key-value storage system. Similar to Memcached, But it supports more storage value types, including string, list, set, and zset ). These

[ORACLE] transaction and consistency (trn tbl and ITL basics), trnitl4 transactions and consistency 4.1 undo segment header transaction table and transaction control table (trn tbl and TRN ctl) -- Undo header contains the transaction table trn tbl

Redis Research (19th)-command attributes, redis research command attributes Different Redis commands have different attributes, such as whether it is a read-only command or an administrator command. A command can have multiple attributes. In some

[ORACLE] processing of oracle string objects, oracle string objects 2.1 char field, varchar2 Field (1) Defining the field length char (10) indicates that the field can contain 10 English characters (regardless of the encoding method, do English

[ORACLE] processing of oracle time objects and oracle object processing 1.1 Use of oracle date objects (1) Create A date Field For example, Create table foo_7 (d1 date ); (2) Use the to_date function to insert a date object. To_date ('string',

PostgreSQL registration Start and Stop unmount batch processing script, postgresql Batch Processing Register to start pg_install.bat: echo offset PGSQL_DIR=%~dp0if not "%PGSQL_HOME%"=="" ( if not "%PGSQL_HOME%"=="%PGSQL_DIR%" ( echo

Enable postgresql remote permissions and enable postgresql Preface: Previously, only the remote permission of the specified IP address of postgresql will be configured. Later, a client wants to remotely connect to postgre and view data, but her IP

Common Oracle functions-date functions, oracle date functions In the development and use of oracle, a variety of date functions are often used. The online date functions are searched for in batch, and there are many minor problems to use. I will

MySQL schema and binary log disk space trend analysis, schemabinary Author: SkateTime: 2015/01/05   Disk Space Trend Analysis of MySQL schema and binary log [Root @ skatedb55 dist] #./mysqlsize -- helpUsage: Database diskspace usage v0.1, (C)

Data Center reconstruction-database design, data center reconstruction Database Database Design-conceptual design stage This phase mainly draws an erdiagram based on requirements, as shown in the following figure. The diagram shows the erdiagram

About Dynamic Sampling (Dynamic Sampling), dynamicsamplingDynamic Sampling) Original article: http://www.oracle.com/technetwork/issue-archive/2009/09-jan/o19asktom-086775.html This article will answer: What is dynamic sampling? What is the function

Oracle query does not mean that the condition contains null values. oracle query contains null values. Requirement: currently, the is_use field in the oracle database has the following values: null, 0, 1, and 2. Now you need to query data not equal

Database Course Design -- Summary of "coffee tea" sales management system and database Course Design The one-week database course design was finally completed to summarize some experiences and lessons learned. The basic knowledge should be kept in

Use of mysql monitor MONyog and mysql monitor monyog MONyog is a commercial paid software, but you can find the cracked version. I use the 4.72 cracked version. 1. Fig 1.1 In the server settings, 1.1. Enable sniffing in Sniffer Settings? Select

Simple tutorial on SQL statements in linux --- simple tutorial on table connection and SQL Now we will introduce the concept of Join. To understand the connection, we need to use a lot of commands we have introduced before. Let's assume that we have

SQL statement concise tutorial for linux --- DISTINCT, concise tutorial --- distinct SELECTThe command allows us to read all the data in one or more columns of a table. This will capture all the data, regardless of whether the data value