Database Administrator

RMAN backup and recovery-parameter file Restoration In RMAN, "restoration" and "restoration" have different meanings. "restoration" refers to accessing the previously generated backup set to obtain one or more objects, then restore these objects at

Oracle 10g quick manual database creation procedure Step record of Oracle 10g quick manual database creation: 0. Modify Environment Variables [Oracle @ ocm1 ~] $ Vi. bash_profile Add the following content:Export ORACLE_SID = PRODExport ORACLE_BASE =/

Why didn't Oracle RAC Opatch go to Rac database home during auto? First explain the environment:Operating System: AIX 7.1Oracle version: Oracle Rac 11.2.0.3I used the 11.2.0.3.9 patch set before and it was not officially used for Rac installation,

Perfmon indexes for SQL Server Performance Optimization Perfmon is a Windows system performance monitoring program. Monitors CPU usage, memory usage, hard disk read/write speed, and network speed.Processor/% Privileged TimeThreshold Value: If the

When does MySQL use indexes or do not use indexes? Index: You can use indexes to quickly access specific information in database tables. An index is a structure that sorts the values of one or more columns in a database table, for example, the name

MyCAT reports java. lang. OutOfMemoryError: Java heap space In the morning, my colleague reported that mycat was suspended again. It was estimated that the memory was still overflow and I checked the error log. INFO | jvm 1 | 07:09:06 | java. lang.

The prefix index of MySQL is similar to that of Oracle. MySQL has an interesting index type called prefix index. It can index the front part of a text field separately to reduce the index size. In fact,Oracle has similar implementations. For text,

PL/SQL-related data dictionary and plsql-related dictionary Data Dictionary related to PL/SQLHttp://www.oracle.com/technetwork/issue-archive/2012/12-nov/o62plsql-1851968.html Sometimes, we encounter the following problems during PL/SQL development:1

MySQL Study -- Use of MySQL tools (phpMyAdmin) and -- mysqlphpmyadminMySQL Study-Use of MySQL tool (phpMyAdmin)System Environment: RedHat EL6Database: MySQL 5.6.4-m7PhpMyAdmin is a software tool written in PHP. It is a MySQL database management tool

Oracle foreign key cascade deletion and cascade update, oracle key level update Cascading Deletion Oracle has three behaviors: no action (similar to RESTRICT), CASCADE, and set null. The following uses the student-class as an example to describe

Review of the history of AI into China, review of the history of AI In 1955, American scholar John McCarthy (1927-2011) first proposed the term "AI", meaning: artificial intelligence is The science and engineering of making intelligent machin ".

2015 China Database Conference Mongodb sharing, 2015 mongodbThis article was shared by MongoDB Greater China technical consultant. When the "old man" came up, he asked what Mongo meant. He guessed the prize and claimed that he was the best MongoDB

Install and uninstall Mysql in Mysql source code mode, and uninstall mysql in Mysql source code mode1. Introduction to Basic Environment 1.1 Software Environment Operating System: redhat linux 6.3 Mysql version: Mysql 5.6.241.2 disk directory

Installation of Oracle in Virtual Machine use PLSQL Developer Connection tutorial in host machine, oracleplsql To meet the development requirements, install the XP system and Oracle on the VM, and install the Oracle Client and PLSQL Developer on the

SQLite tutorial (12): detailed explanation of lock and concurrency control, and detailed description of sqlite I. Overview: In SQLite, the lock and concurrency control mechanisms are handled by the pager_module module, such as ACID (Atomic,

Big environment MySQL5.6 source code Installation Practice step by step teach you CentOS6.5 _ 64bit under the compilation and installation of MySQL-5.6.23 @ guoyJoe, centos6.5mysql5.6 L reprint please indicate the source:

In "How to Design Database 2)", Jack London Chen raised some questions, which are roughly as follows: "Man/woman should be designed in the same table. Most user tables are designed as one table. Neither administrator nor user can be connected ." I

Explore Oracle Database Upgrade 7 11gR2 to 12c after the upgrade is complete, insert PDB, 11gr2pdb Explore Oracle Database Upgrade 7Insert PDB after 11gR2 to 12c upgrade is complete Preface: Since Oracle 12c, the concept of container database has

Mysql5.5 multi-instance deployment and mysql5.5 instance deployment To deploy MySQL Databases on multiple instances, follow these steps. 1. mysql multi-instance principle 2. Features of mysql multi-instance 3. mysql multi-instance application

2 logging3 datafile '/opt/oracle/oradata/bisal/test_data_01.dbf'4 size 10 M5 autoextend on6 next 10 m maxsize 2000 m7 extent management local;Tablespace created. Total 1.5 GB-Rw-r ----- 1 oracle oinstall 11 M Sep 27 22: 56 test_data_01.dbf 2