Database Administrator

1. process description In AIX, a process is a task, and a running program is a process. 2. child and parent Processes A process can be dependent on a process. A process can generate a new process. The generated process is called a child process,

I. Nullable When designing a table, a column is sometimes allowed to use the default Null value ). 650) this. width = 650; "src =" http://www.bkjia.com/uploads/allimg/131229/211U45539-0.png "title =" null.png "alt =" 110227268.png"/>

I. Overview MySQL has three levels of locks: Page, table, and row. The MyISAM and MEMORY storage engines use table-level locking. The BDB storage engine uses page-level locking, but also supports table-level locking; the InnoDB Storage engine

--- SQL Server statement: SELECT COUNT (1 ), remark FROM (SELECT Remark = case when Remark LIKE '% check tkt time % 'then' there is a problem WITH the retention TIME 'when Remark LIKE' % WITH "AV" AGAIN % 'then' there is no space 'When Remark LIKE

Add and modify data files in oracle ---------- Add a data file --------- Altertablespacetablespace_nameadddatafile '+ ASMDISK1/mydbfile. dbf' size10240M; ------- Manually change the data file size ------ Alterdatabasedatafile '+ ASMDISK1/mydbfile.

1. Install cmakeMySQL 5.5 and later versions have been replaced by the cmake tool./configure compilation and configuration method.Therefore, we must first compile and install the cmake tool in the system source code. # Wgethttp: //

Hive is engaged in the Query Platform for each Query tag, want to try the effect if found that there is no data inflows; the original found Hive inside made an improvement: https://issues.apache.org/jira/browse/HIVE-887 For simple queries, instead

A transient network disconnection causes the dpe process ABENDING of ogg. view the dpe Process report. 2013-09-2422: 19: 51errogg-01031thereisaprobleminnetworkcommunication, aremotefileproblem, encryptionkeysfortargetandsourcedonotmatch

Recently, we are looking at oracle recovery and backup mechanisms. It is fresh to learn about oracle beginbackup and endbackup. I did some small experiments. The result is confused. I don't know why I need this technology. Sys @ CISCOSYS> alter

-- ================================== -- SYSTEM tablespace management and Backup Recovery -- ================================== SYSTEM tablespace is the most important tablespace in Oracle databases. It stores information generated by some DDL

-- ====================================== -- Oracle Hot Backup -- ====================================== Oracle Hot Backup refers to a series of backup operations on database data files, control files, parameter files, and password files when the

In the morning, I saw two dead Datanode alarms. I checked the system logs and found that the current high load caused the datanode to time out and the heartbeat was removed by DatanodeManager, further found that the high load is caused by a Job with

Recently, the Hive Query Platform has many considerations. One of them is to limit the user's query volume for partition tables, mainly because you must specify the partition key. at the beginning, the idea step was to do HQL parsing. However, due

① ASM file conversion Take the created asmtest tablespace as an example. (I) convert OS files to ASM files Sys @ ORCL> create tablespace asmtest datafile size 10 m; Tablespace created. Sys @ ORCL> alter tablespace asmtest offline; Tablespace

Step 1: Download from http://www.mongodb.org/downloads Step 2: Decompress the downloaded file to a location on the disk and copy its bin path, for example, H: \ DevelopmentTools \ mongodb2.4.6 \ bin. And add Step 3: Create a configuration file

/* 1. Use some, any, and all to process the multiple rows returned by the subquery. 1. some satisfies the meaning of one of them here, which is a comparative clause concatenated with or. 2. any also indicates satisfying one of the meanings. It is

Problem background:To facilitate troubleshooting and reduce the log file size, you need to poll slow query logs and error logs by day. Round Robin script/data/scripts/mysql-log-rotate ): "/data/dbdata/otherlog/slow_query.log" "/data/dbdata/otherlog/

10.1 perform the huge table splite to partition table action. The process went smoothly. After the program was started, it was found that some reporting programs were slow. The analysis shows that the number of sessions is high, and the active

Working topology: 650) this. length = 650; "src =" http://www.bkjia.com/uploads/allimg/131229/201Z26336-0.jpg "title =" mysql-master-salve-proxy.jpg "width =" 400 "height =" 354 "border =" 0 "hspace =" 0 "vspace =" 0 "style =" width: 400px; height: 3

Official: The first time you install Oracle Database software on a server, you are prompted to specify the location of the inventory directory, called oraInventory. this directory provides a centralized inventory of all Oracle software products