Database Administrator

MySQL 5.5.x notes for source code compilation and Installation 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

Use shell scripts to view SQL statements with high resource consumption in Undo When undo usage is checked, when Undo_management is set to auto, it is often seen that undo is constantly scaling and adjusting itself. Sometimes we can see that Undo is

Database startup reports ORA-27154 ORA-27300 ORA-27301 ORA-27302 Error Today, my colleague encountered an Oracle startup problem, SQL> startup ORA-27154: post/wait create failed. ORA-27300: OS system dependentoperation: semget failed with status: 28 

Oracle mass data migration-use shell to enable multiple dynamic Parallelism In Oracle data migration, there may be hundreds of tables, some of which are large and some are small.If multiple parallel processes are enabled, resource allocation may

PostgreSQL replication cluster Overview PostgreSQ replication, high availability, Server Load balancer-related clusters. Here is an overview for future reference. PostgreSQ has the following various replication-Based Cluster solutions, most of which

Oracle uses shell scripts to view procedure information A schema may contain a large amount of procedure. Sometimes, to view specific information, you must use tools such as toad and plsql dev. Sometimes, you can try to get rid of the graphic tool,

The run selected revisions of dbv does not respond. dbvrevisions When an SQL statement under revisions has an exception, such as deleting a column that does not exist, the foreground does not respond. In fact, there is a response, but the returned

ORACLE10G is installed on Centos6.4 and oracle10gcentos6.4 Note: This installation is only limited to the installation of ORACLE10G on Centos6. for installation of other versions of the operating system, please refer to the official oracle

How to copy data from an SQL server to another SQL server, sqlserver Platform Description: two SQL server2005 servers are installed with two identical databases. Recently, due to project requirements, we need to copy the database data on one server

Quickly generate a database dictionary SELECT TableName = case when c. column_id = 1 then o. name ELSE n'' END, TableDesc = ISNULL (case when c. column_id = 1 then ptb. [value] END, n''), Column_id = C. column_id, ColumnName = C. name, PrimaryKey =

Oracle rman is restored to remote, remote, and remote The original database server uses rman to back up the entire database, and then restores the same database on the remote server.1.1 original server backup database Step 1: view the database

[Architecture problem solving: 1] solution to 4031 errors: Architecture 4031III. solution 4031 error method :( ora-4031 error cause: a large number of hard parsing, resulting in chain chunk are changed very small, at this time a large SQL will not

Performance of non-simultaneous login between Oracle client and Oracle version, oracle client  **************************************** ******************************** ************** Original Works are from the blog of "Deep Blue blog". You are

Official Oracle and oracle website Baotou: Create or replace package ProdureceCursorData isType curtype is ref cursor; Type type_record is record ( Deptno NUMBER (2 ), Dname VARCHAR2 (14 ), Loc VARCHAR2 (13) ); PROCEDURE Procedure1 (cur out curtype )

WAS cluster series (15): shutdown and startup of WAS cluster services, was Cluster **************************************** ******************************** ****************  Original works, from the blog of "Deep Blue, Welcome to reprint, reprint,

The mysql query field value is a number, and the mysql field value is a number.The SQL statement that I want to query where the field value is a number is as follows: select * from tj_item_result where tj_value REGEXP '^ [0-9]'How does mysql query

[MongoDB] Configure a Windows Service for MongoDB, mongodbconfigure In this blog, I will mainly attach great importantance to how to create a windows service for mongodb. The method described in the next is referred from the official website of

WAS cluster series (11): cluster creation: Step 9: Release the verification program, was Cluster(1) install the lab packageClick OK to go to the following page: Click "Next", for example: Note that the following steps are important. You need to

11g rac minor problems encountered when installing and running ASMCA: ASMCA detected pre 11gR2 ASM, but it does not have a local instance configure, win3211gr2client Problem description: 11g rac installation, GI has been installed, the status of

Oracle bug 12415167, oracle12316167 drop table t1;create table t1 (c1 char(2) primary key, c2 char(1) not null);insert into t1 values ('A ','A'); select t1.c1 from t1 where t1.c1 in (select c2 from t1 union all select '0'||c2 c2 from t1); select /*+