PHP

OracleVault is an important part of the three security technologies. Compared with the other two types, LabelSecurity, VPD (VirtualPrivateDatabase), and OracleVa Oracle Vault is an important part of the three security technologies. Compared with the

The new TemporaryUNDO feature of Oracle12C can reduce the amount of data stored in the undo tablespace and generate redo logs. New Features of Oracle 12C Temporary UNDO can reduce the amount of data stored in the undo tablespace and the generation

Oracle, as the most popular commercial database, provides a series of HA solutions in addition to independent database DBMS, to meet actual O & M system requirements. Here, Oracle, as the most popular commercial database, provides a series of HA

When a disk partition in a simulated Linux has free space and no Inodes is available, the error "Nospaceleftondevice" is returned. When a disk partition in a simulated Linux has free space and No Inodes is available, the error "No space left on

DataGuard's problem summary during Switchover Switching DataGuard's problem summary during Switchover Switching 1. The master database encountered a ORA-01093 error while converting the role of the physical master/Slave Database SQL> select

Sometimes redolog needs to be re-planned as the business grows. For example, there are three groups of existing logs, one member in each group, and the size of each member is 50 MB. Sometimes, as the business grows, you need to re-plan the redo log.

Recently, we are engaged in data migration. We have migrated data from U1 users in database A to U2 users in database B. We have used open-source kettle to work with the Data Pump. It's Okay during the test, but it's actually going online,

Prepare an SQL script demo. sqlsetserveroutputondeclarev_namedept.dname % type; beginselectdname1_v_namefromdeptwhe Prepare an SQL script demo. SQL set serveroutput ondeclarev_name dept. dname % type; beginselect dname into v_name from dept whe

In many scenarios, developers often use the millisecond value from 1970-01-0100:00:00. 000 to indicate the specific time, so that data can be stored in the database as NUMBER. In many scenarios, developers are used to express the specific time in

The AWR report is generated by comparing AWRBaseline. In this case, AWRBaseline is set up, and AWRreport is set up in different time periods to monitor and compare database performance changes. I. Building The AWR report is generated by comparing

MySQL management SQL statement instance first, let's import the world Library. The tables in this world library are dedicated tables for the mysqlocp examination. The mysqlsourcerootworld_innodb. SQL table structure on the internet is as follows:

This document is recorded when mysql dual-master is deployed online at the company. For security purposes, IP addresses are changed to intranet IP addresses. # Mysql-VmysqlVer14.14Distrib5.5.37, fordebian-linux-gnu (x86_64) usingread This document

You cannot perform Incomplete recovery on only one part of the database because it gives a part of the database a different system change number (SCN) or time point from the rest of the database. You cannot perform Incomplete recovery on only one

If the database is not closed and the member of the active redo log group or the current redo log group is lost, use alterdatabasecheckpoint to check the checkpoint immediately, If the database has not been closed and the member of the active redo

Background: In years of work, we have designed many system or product databases, including single-host databases, lan databases, and Internet databases. For different environments, the design considerations are different. Even if Background: In

The concept of transactions 1. transactions can be seen as a unit composed of several operations on the database. This unit is a whole and has a high sense of collective responsibility and honor, either the operation is successful .. The concept of

For online running systems, the current database performance monitoring usually monitors the following points: (1) whether there is Blocking (Blocking); (2) whether there is Waiting (Waiting ), blocking means Lock wait; (3) whether the running time

For details about NULL values in Oracle, NULL indicates UNKNOW (unknown) and does not represent any value. For example, if a column in a row does not have any value, it is NULL. For details about NULL values in Oracle, NULL indicates UNKNOW (unknown)

Oracle backup is divided into logical backup and physical backup. Logical backup is expimp; physical backup includes cold backup, hot backup, and RMAN backup. Expimp has three modes: Table mode, Oracle backup is divided into logical backup and

Recently, many warning messages are displayed when you view the error log of the MariaDB Master-Slave replication server Master. They indicate that the UUID () function is insecure, and the values generated by Slave and M Recently, many warning