Database Administrator

Impact of/dev/shm on Oracle 11g: ORACLE introduced an Automatic Memory Management feature from the 11g version. This feature requires more shared Memory (/dev/shm ), therefore, if you decide to apply this feature, make sure that the shared memory is

Recently, you need to manually refresh a materialized view after the documents are successfully submitted. The solution was to call dbms_refresh.refresh ('materialized view name') on the After Update trigger of the table. An error was reported

There is a need for a job to record all its value-added service operation information It is impossible to delete the original data when recording, so I thought, is there a syntax for MYSQL, instead of selecting the original data and then updating,

I wrote a MySQL backup script in Linux. This is the first version. Only one database can be backed up. Every night at, I run the script with a timer and it will be automatically backed up. In the future, multiple databases can be backed up. If the

MySQL automatic backup tool in Linux-the second version is well developed based on the first version (see. It mainly includes custom database hosts and Backup Paths. Multiple databases can be backed up, regardless of the number of databases. You can

During the process of installing Oracle10g clusterware, installation may often fail due to errors. In this case, you need to clear all installed information to ensure that the reinstallation is successful. This work varies slightly on different

1. Install the OS requirement packageBinutils-2.17.50.0.6-2 (x86_64)Compat-db-4.2.52-5.1 (x86_64)Compat-libstdc ++-296-2.96-138 (i386)Compat-libstdc ++-33-3.2.3-61 (x86_64)Compat-libstdc ++-33-3.2.3-61 (i386)Control-center-2.16.0-14 (x86_64)Gcc-4.1.1

1. MongodbVersion: mongodb-linux-x86_64-static-legacy-1.8.1.tgz: Http://www.mongodb.org/downloadsMongodb provides two download editions: mongodb-linux-x86_64-1.8.1.tgz and mongodb-linux-x86_64-static-legacy-1.8.1.tgzDifference: the "legacy static"

In MYSQL, you can use the create function command to call different. so shared library files. Before compilation, add the following options: -- with-mysqld-ldflags =-rdynamic. A minor problem occurred during re-compilation, possibly because the

Mysql. user SelectHost,User,Password FromMysql.User; Grant All Privileges On*.*ToMonty @ localhost identifiedBy '123' With Grant Option; SelectHost,User,Password FromMysql.User; Display:   +----------- + ------ + ---------------------------

This article analyzes the problem of slow MySQL database servers and proposes corresponding solutions. 1. Check the system status Check the status of the system by using some operating system tools, such as CPU, memory, swap, and disk utilization.

My personal experience in configuring a mysql cluster. Installation preparation:1. Required software.Management node:MySQL-Cluster-gpl-management-7.1.9a-1.rhel5.i386.rpmMySQL-Cluster-gpl-tools-7.1.9a-1.rhel4.i386.rpmSQL node:MySQL-Cluster-gpl-server-

How To Connect C to the MySQL database in Linux: # IncludeStdlib. h> # IncludeStdio. h> # IncludeMysql. h> Int main (int argc, char * argv []) { MYSQL * conn_ptr; Conn_ptr=Mysql_init(NULL ); If (! Conn_ptr ){ Fprintf

A database on the Oracle server encountered an 'ORA-12516: TNS: The Listener could not find the available process' error that meets the protocol stack requirements. To solve this problem, first check the number of existing processes in the database,

The SQLite library contains a command line named sqlite3, which allows you to manually enter and execute SQL commands for the SQLite database. This document provides a brief description of sqlite3.Start To start the sqlite3 program, you only need to

1. Basic syntax(1) create a sequenceCreate sequence [user.] sequence_name[Increment by n][Start with n][Maxvalue n | nomaxvalue][Minvalue n | nominvalue][CYCLE | NOCYCLE][CACHE | NOCACHE][ORDER | NOORDER];Increment by: Specifies the interval between

Recently, I want to check the filling rules of a field in the table, and the results are very confusing. I want to use SQL statements to determine how a field starts with a letter rather than a Chinese character: 1. if lengthb (substr ("", 1,1) = 2

Some time ago, when I encountered such a problem, one day I suddenly encountered #2013-Lost connection to MySQL server at 'reading initial communication packet 'during database backup ',System error: 0Pay attention to the red part. Different error

1. Create a stored procedureProc code Create or replace procedure changesalary (p_employeeid number, p_newsalary number) is Begin Update employees set salary = p_newsalary Where employee_id = p_employeeid; If SQL % notfound then

1. Use the SHOW statement to find out the current database on the server: mysql> SHOW DATABASES; +----------+ | Database | +----------+ | mysql | | test | +----------+ 3 rows in set (0.00 sec) 2. Create a database, abccsMysql> create