Database Administrator

Subtotal for Oracle 1. Sequence 1.1 What is Sequence? Sequence is an object provided by Oracle for generating auto-increment primary keys. This is similar to the identity of SQL server. From a mathematical point of view, it is an arithmetic

Ubuntu 14.04 LTS 64-bit installation of Oracle 11g Oracle does not officially state that it supports Ubuntu installation. Therefore, the environment must be adjusted and prepared before installation can be successful. Ps, I tried multiple times but 1

Oracle cascade operations When you add a foreing key constraint, you can also specify the cascade operation type, which is mainly used to determine how to process the foreign key fields in the subtable When deleting a record in the (on delete)

Truncate usage in Oracle Syntax: truncate table; You can use the truncate Statement (DDL language) to delete all records in a table. The truncate statement is usually much faster to delete data than to delete data. This is because no rollback

Enq: DM, resetlogsenq In recent cases, the alter database open resetlogs command in db 10.2.0.5.12 has been waiting, and the alert_sid.log information is: Setting recovery target incarnation to 2   The waiting event obtained from v $ session.

SQL series, ultimate SeriesSQL statement Optimization Methods Some are general (for example, avoid Select *); Some different database management systems are different (such as Where clause order ); Then you must optimize the SQL statement based on

How to backup and restore database in SQL Server, backuprestore /* By Dylan SUN */ If you want to backup and restore one database in SQL Server. Firstly, create a shared folder, and add everyone with read/write right. Secondly, backup your

Mysql installation, mysql Install mysql source code Http://www.cnblogs.com/fly1988happy/archive/2011/11/21/2257682.htmlHttp://www.cnblogs.com/wuhou/archive/2008/09/28/1301071.html Problems During mysql Installation You must install the ncurse

ORACLE 11G does not have backup file parameter files on the same machine through rman backup recovery was accidentally deleted data, 11 grman Background: Colleagues accidentally deleted online data, so they need to recover data from the backup. Real

Getting started with mysql enterprise backup, enterprisebackup **************************************** * ********************** -- 1. full backup *************************************** * ******************** # mysqlbackup -- defaults-file

Mongodb3.0 Performance Test Report III. mongodb3.0 performance test Mongodb3.0 Performance Test Report 1 Mongodb3.0 Performance Test Report 2 Test environment: Servers: 6 X86 pcservers Cpu: single 8-core Memory: 64 GB Disk: raid 10 Operating System:

Mysql transaction and mysql Transaction ProcessingIntroduction Mysql supports transaction processing since 4.1, but only databases created using InnoDB/BDB engines Support transaction operations. View the mysql database creation engine type: show

[Oracle] Character Set, National Character Set, and NLS_LANG Runtime Library, using lenls_lang**************************************** ********************************* *** Original article: blog.csdn.net/clark_xu Xu changliang's column**************

JAVA transaction attribute ACID; java transaction attribute acidATOMICITY ):A transaction must be completely completed or canceled without ambiguity. When an error occurs in any operation, the effect of all operations that constitute the transaction

Rebuilding the data room charging system-database design and restructuring the data room Charging System After completing the three-tier example, Data Center reconstruction should have started for a long time, but I have never wanted to change it.

Oracle purchase price (III)-x86 price, oraclex86Read Oracle purchase price research (2)Read more Today, the article "New Directions for distributed database applications in the ORACLE to MYSQL-post-prism age" in a company's technical Magazine

Connection Pool technology and technology Concept The connection pool is a buffer pool technology for creating and managing a connection. After the connection pool is ready, it will be used by any thread that needs them. The technology that

[Data Center Charging System] use of triggers and data center charging system triggers In data center reconstruction, many functions involve operations on multiple tables in the database. For example, after the checkout is successful, the following

High concurrency: Memcached practice lesson 10th-part of the code for "Memcached Get data" Section 2: memcached practiceHigh concurrency: Memcached practice lesson 1-"Memcached Get data" part of Code 2 I. Logic of reading and writing the Memcached

An error occurred while converting from nvarchar to numeric. nvarcharnumeric When writing an SQL statement, you need to compare the nvarchar column of the (dictionary) table with the numeric column of Table B; The dictionary data stored in the