Database Administrator

Case study of incomplete records of RAC split-brain logs due to not configured diagwait1. Fault A rac with the CRS version 10.2.0.4. After the server goes DOWN at the second node, the server goes DOWN at the first node.2. CRS log analysis 2.1 2-node

SQL Server database startup process details and analysis and solutions to problems that cannot be started Currently, as an excellent RDBMS of Microsoft, the SQL Server database has very few problems when it is started. When we use it at ordinary

Database Operations-create indexes, databases-Indexes When receiving a task some time ago, You need to query the existence of a data entry from 10 million data entries within two seconds. I was shocked. 10 million pieces of data! Two seconds! Is

MsSQL disk space is insufficient.ZookeeperI. How does msSQL errorlog cause insufficient disk space?Execute EXEC sp_cycle_errorlog to generate a new errorlog to overwrite the old errorlog. The errorlog can be overwritten once every 7 cycles.Ii.

Oracle flashback and oracleflashbackFlash back: fixed a logic error and returned from the current point.1. There are dedicated flashback logs stored in the FIA, but they are only used in the database. 2. If a full database flash is performed, it is

Oracle basics-index and oracle basic index 1. What is indexing? A: indexes are used in databases to improve query efficiency. Supplement: too many indexes can greatly reduce the efficiency of DML statements. The indexing principle is to create

Atitit. Get connection hibernate4, atitithibernate4 Atitit. Get connection hibernate4   1. SessionFactoryUtils method (recommended) 1 2. ConnectionProvider method () 1 3. Ga self-implementation method (not recommended) read hb configuration file 1 4.

How to import dmp database files in oracle, oracledmpImporting and exporting Oracle Data imp/exp is equivalent to restoring and backing up oracle data. The exp command can export data from the remote database server to the local dmp file, and the

OLAP learning and instance building, and OLAP learning instance Building OLAP learning and instance Building Theoretical preparation: I. OLAP 1. What is OLAP? OLAP (On-LineAnalysis Processing) is a fast analysis technology that shares

Oracle SPM execution plan management, oraclespm **************************************** * ******************** Part 1: concept *************************************** * ******************* SQL scheduler management is a new function introduced with

Pfile VS Spfile (MOS Note 249664.1), pfilespfile For the original article, see:Http://www.cnblogs.com/haoxiaoyu/p/4308483.html, Better format, more conducive to reading ~~~   ========================================================== ================

Error reported when centos65 was installed on pg935: jade: Command not found, centos65pg935When centos65 is installed on pg935, the following error occurs: jade: Command not found.1[Root @ pghost1 postgresql-9.3.5] #. /configure -- prefix

Install and optimize Mysql in Linux.System Environment: CentOS 6.5Mysql version: mysql-5.6.19.tar.gzSoftware upload path:/doiido/soft1. Install Mysql1: Firewall opens the corresponding port#/Sbin/iptables-I INPUT-p tcp -- dport 3306-j ACCEPT#/Etc/rc.

Collation of numbers and Chinese characters in oracle and introduction to REGEXP_SUBSTR, oracleregexpsubstr Requirement: There is a column NAME, varchar2 type, the content is as follows The preceding statements are sorted by order by name, but

ORACLE Installation and oracle Installation Statement:Original Works are from the blog of "Deep Blue blog". You are welcome to repost them. Please indicate the source when you repost them. Otherwise, the copyright will be held legally

Table space that can be transferredOracle2271 There is an important concept for the table space that can be transferred: Self-Contained ).During tablespace transmission, the tablespace set must be self-contained. The self-contained indicates that

Analysis of pub/sub function in Redis, Xinxing redis The pub/sub function is the publish/subscribe function, that is, the publish and subscribe function. In an event-based system, pub/sub is a widely used communication model. It uses events as the

Character Set OverviewA brief overview of the oracle031 Character Set: A character set corresponds to the encoding. 1. Functions and meanings of character setsCharacter encodingUsageDatabase Character Set(1) used to store CHAR, VARCHAR2, CLOB, LONG,

[Translated from mos] file # = 0 is damaged in V $ BACKUP_DATAFILE, Source:V $ BACKUP_DATAFILE Shows before uptions for File #0 (Document ID 399113.1) Applicable:Oracle Database-Enterprise Edition-Version 9.2.0.1 to 11.1.0.6 [Release 9.2 to

Case study of incomplete log records of RAC split-brain due to not configured diagwait, diagwaitrac1. Fault A rac with the CRS version 10.2.0.4. After the server goes DOWN at the second node, the server goes DOWN at the first node.2. CRS log