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

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

Ubuntu MongoDB 32-bit installation, tumongodb Download 32-bit MongoDB: https://fastdl.mongodb.org/linux/mongodb-linux-i686-3.0.1.tgz Unzip: tar-zxvf/mongodb-linux-i686-3.0.1.tgz Go to the MongoDB directory Create two files Mkdir data // store

Run scripts to generate reports of hybrid data sources and reports. You can use different data sources in the same report, such as RDB, TXT, Excel, JSON, HTTP, Hadoop, and mongodb. If you use a hybrid data source in a computing report that does not

[Translated from mos] monitors the progress of the flashback database,Monitor the progress of the flashback databaseReference:How to determine flashback database progress (Doc ID 1071391.1)Applicable:Oracle Server-Enterprise Edition-Version 10.1.0.2

Mariadb introduction, mariadb 1. Introduction to mariadb Official Website: https://mariadb.orgMariaDB was developed by Michael Widenius, MySQL founder. He sold his own company MySQL AB to SUN for $1 billion, as SUN was acquired by Oracle, the

Article Title, article title Daquan Oracle 11gR2 Clusterware log location:All clusterware daemon logs are stored in the/log/directory. The directory structure is as follows:Alert. log-check this article for most clusterware problems../Admin:./Agent:

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.

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

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:

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

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

Ado connects to SQL server and adosqlserver // Add the following sentence to the SQL server connection header file of ado: # import "C: \ Windows \ system \ msado15.dll" no_namespace rename ("EOF", "rsEOF ") // CoInitialize (NULL) in cpp ); _

Redis, Memcache, Mysql difference, redismemcache When using Redis, we found that Redis is different from Memcached and also different from MySQL.(This article mainly discusses the situation where VM support is not enabled for Redis)1. Schema MySQL:

Difference between @ param in spring and @ param in mybatis, @ parammybatis /*** Query whether the specified user and enterprise are associated with a configured role * @ param businessId memberId * @ return */int selectRoleCount (@ Param

Oracle query sequence and oracle Sequence Query the sequence of a user, where user_name is the login name of your current database SQL> select SEQUENCE_OWNER, SEQUENCE_NAME from dba_sequences where sequence_owner = 'user _ name '; SEQUENCE_OWNER