Database Administrator

Oracle 11g adds a control file to the ASM disk, 11 gasm A Control File is one of Oracle physical files. It records the database name, data File location, and other information. The importance of the control file is that the database will go down

Linux mysql regular backup and compression, linuxmysql 1. Check whether the mysql BACKUP command works. Create a backup directory under the var directory and a mysql directory under the backup Directory to store mysql backup files Cd to

SQL Server Service Remote process call failed, SQL Server call Due to the need for a unified vs version for the development system, after a hard and arduous struggle all day yesterday, xiaobian finally succeeded in writing in the 13 version of vs

Concerning the LUN queue depth (queue_depth) and aixqueue_depth In the AIX operating system # Lsattr-El hdisk10 PCM/friend/hitachifcp N/A True PR_key_value 0x1c4ce354c Reserve Key True Algorithm round_robin N/A False Clr_q no Device CLEARS its Queue

Filesystemcache and aixfilesystemcache on aix The filesystemcache on aix has been discussed in the following books:   The Oracle optimization Diary of eel: The story of a gold card dba. See page 165th:   This FileSystemCache, after nmon enters,

For MySql database, table operations, addition, deletion, modification, query, and other SQL statements, mysqlsql (1) how to copy and paste content in cmd? Reference: http://jingyan.baidu.com/article/93f9803fd3a4dde0e46f55f5.html (2) how to open

Oracle's problem about number type conversion to_char is that oracleto_char Select to_char (0.1) nums from dual; It is observed that if the integer of a decimal number is 0 and the preceding 0 is not displayed after the string is converted, and

MySQL Database password function, mysqlpassword Execute the following statement in the MySQL database to generate a new encrypted string for the string. The user stores the password in the database. Select password ('A ') The generated string

[Redis] redis command Summary (2), redis command SummaryPublish/subscribe pub/sub Command Format Time Complexity Command description Return Value Publish channel message O (N) Sends the message to the specified

The automatic backup script for Oracle databases in Windows @ Echo off echo ============================================ ================= echo in Windows environment, the Oracle database's automatic backup script echo 1. use the current date to

2015 first blog, Oracle time period query, comparison of TO_DATE and TO_CHAR, to_dateto_charPreface:During time period query, when TO_DATE is used, including the start date, not the end date;When TO_CHAR is used, the start date or end date can be

Redis research-portal, redis Portal When LZ was working on FreeLink, the open-source call center project, the calculation and maintenance of Agent phone statistics used Redis knowledge, and simply learned Redis a little. The following describes the

Using datafile copy to rename a data file, datafilecopy Ideas: O use RMAN to copy data files O offline O switch file name. This step changes the file name corresponding to the data file in the control file. O recover data files O online data files

Test SQL left join on and where efficiency, sqljoin Recently, many of my predecessors used left join on, so I checked it online for a long time. I felt that it was not great. So I tested it. Although not rigorous, it has already reflected general

Batch export the shell script and informaticaobject of the ICA object #!/bin/bash # -----------------------------------------------------------------------# Script Name: inf_impobj.sh# Purpose: To batch export mappings or workflows to xml files #

SQL statement execution sequence and SQL statement SequenceUnlike other programming languages, SQL is most characteristic of code processing. In programming languages with large numbers, the code is processed in the encoding order, but in SQL, the

Read xml to generate code example, xml code example Read xmlGenerateCorrespondingLua parsing protocol code: # Include # include "tinyxml2.h" # include # include using namespace tinyxml2; using namespace std; std: ofstream file ("readProto. lua ",

Mysql imports the C ++ implementation and encapsulation of the source database SQL, mysqlsource Many people have had headaches for this issue before: I want to have a database script that can be imported without installing the mysql client, but

Oracle dbms_random.value, dbms_random.value Dbms_random is a package that can generate random values or strings. There are two usage methods for value () in the package:If there is no parameter in the first type, a 38-bit precision value is

Oracle returning into, oraclereturning The returning into statement is used to return the value after the statement is executed. The specific results before or after execution are returned, as described below: The returning into statement of the