Database Administrator

Set the maximum number of MySQL connections in CentOS to 1040 too persistent connection Set the maximum number of MySQL connections in CentOS to 1040 too persistent connection When the maximum number of connections is small, the error "1040 too

Oracle blocking) Blocking is a common situation for DBAs. especially poor application design blocking can cause serious performance degradation until the database crashes. For DBA, it is necessary to know how to locate the system blocking, who is

Learning notes on Redis installation and deployment1 Overview Currently, most NoSql databases are essentially key-value pairs, and Redis is no exception. As a cache database, Memcached has the following advantages: (1) in terms of speed, Redis is

Oracle recursive functions Oracle start with connect by usage Connect by prior recursive algorithm in oracle In Oracle, the start with... connect by prior clause connect by is used in structured queries. Its basic syntax is:Select... from tablename

An error is reported when RMAN backs up the entire database and archives logs. An error is reported when RMAN backs up the entire database and archives logs. Hi.I lost few previous archivelogs, and can't run "backup database plus archivelog

MySQL binary case sensitive Why is MySQL Case Insensitive ?? I was almost dazzled. Make another query. This is the result of Shenma. You can use binary to convert a string to a binary string for comparison. After adding binary, it

MySQL implements Minus and Intersect) MySQL does not implement the Minus and Intersect functions, just as it does not implement the cube function. You can use SQL to implement the same function, which is troublesome. Drop table t1; Drop table

RMAN full backup script Objectives:1. the backup script is automatically executed at midnight every week.2. Full database backup, control files and archive log files are backed up at the same time.3. the backup is retained for 14 days and

Introduction to Oracle insert all statements In Oracle, the insert ALL statement is described as follows: 1. insert all unconditionally Create table t1 (product_id NUMBER, product_name VARCHAR2 (80), month number ); Insert into t1 VALUES (111,

Oracle Database Development In the Oracle database system, tables are the basic objects of databases, and all data in the database exists as tables. Environment-Oracle 11g I. Table typeCommon tables in Oracle Database systems include: heap

How to solve the problem that the maximum number of MySQL connections exceeds the limit Recently, the User database name has already more than 'max _ user_connections 'active connections error is reported on the website. It is necessary to study

Oracle 8.1.7.4 database fault recovery solution instance The customer's database version is 8.1.7.4. the disk where the data file is located is faulty. After the fault is rectified, the data file needs to be recovered and set to online;ORA-00376:

Detailed Oracle 11G restart uard restart process Scenario: restart the database, do not restart the linux system, so you do not need to consider listening programs,# Linux input lsnrctl start1. Close the database1.1 shut down the master

Create index hang (row cache lock) for the partition table in the RAC Environment) Create a bitmap index on a large table (Partition Table) today. After a period of execution, hang will wait for the event to be row cache lock. Query: SQL> Select

ORA-00922: Option Missing or invalid, ora-00922 missing 1. Error description ORA-00922: Option Missing or invalid 2. Error cause 3. Solution Oracle is 11GR2 64-bit, system: win7 64-bit, always prompt "ORA-00922: Option Missing or invalid"

Chapter 1 Securing Your Server and Network (2): SIDs for management services, securingsidsSource: http://blog.csdn.net/dba_huangzj/article/details/37927319, topics Directory: http://blog.csdn.net/dba_huangzj/article/details/37906349 Without the

Db_keep_cache_size control range test, dbkeepcachesize In the new questions of the ocm examination, you need to create a table for storing keep, but there are some differences regarding whether the parameter should be modified. Some people say that

Sap uses VMD_EI_API => MAINTAIN to create supplier master data, sapvmd_ei_apiFRM_VENDOR_CREATE.DATA: LV_FLG.DATA: LS_MAIN TYPE VMDS_EI_MAIN,LS_MESG TYPE CVIS_MESSAGE,LT_MSG TYPE BAPIRET2_T,LWA_MSG TYPE BAPIRET2,LT_VEND TYPE VMDS_EI_EXTERN_T,LWA_VEND

Does the branch block of Oracle composite B * tree index contain non-pilot column key values ?, Branchblock I haven't touched the underlying details of the database for a long time. A little guy came to me a few days ago and had to say that the

Role of TNS in Oracle, role of OracleTNS What is TNS? TNS is a part of Oracle Net. It is a tool used to manage and configure the connection between the Oracle database and the client. In most cases, to communicate with the database, TNS must be