Database Administrator

ORA-21779: duration not active problem solution The user tells a RAC environment database to generate a large number of ORA-21799 error messages in the log, the alert Log part is truncated as follows: Mon Jan 06 10:27:24 2014Errors in file d: \

An example of DB2 data recovery: SQL0928N The environment is AIX 6.1 and DB2 9.7.0.7.First, check whether the db2 master process exists. Ps-ef | grep db2sys If the database does not exist, use db2start to open the database. The backup media is a

Mysql INNODB Engine lock principle test, mysqlinnodb engine lock How does mysql INNODB Engine lock work? Let's test it. Mysql> select version ();+ ----------- + | VERSION () | + ----------- + | 5.5.20 | + ----------- + 1 row in set (0.00

MySQL master-slave replication and read-write separation, mysql master-slave read-write The so-called read/write splitting is to prepare two types of MySQL Databases in advance, one for update (master) and the other for query (slave ). When the

Phpmyadmin connects to remote mysql and phpmyadminmysql Phpmaadmin connects to remote mysql Procedure . Make sure phpmyadmin already exists. If not, go to the terminal. Go to the phpmyadmin installation directory, where C: \ wamp \ apps \

Mysql database version control dbv, mysql database version dbv Version Control software includes svn git and so on. These tools control the source code version very well, but what about database version control? The traditional method is to export

MemSQL, SQLFire, Oracle XE performance comparison test, memsqlsqlfire 1. Software Version Memory SQL 3.1 Pivotal SQLFire 1.1.2 Oracle 11g XE   2. Test Environment Host OS: Windows 7 64-bit Professional Edition CPU: i7-3770 3.4 GHz Memory: 16 GB Hard

WAS cluster series (17): Operation Flow for modifying a configuration under WAS (Single Node + Cluster), was Cluster **************************************** ******************************** ****************  Original Works are from the blog of

Let's look at the database -- (4) transactions and database transactions. What is a transaction? Simply put, it is what you do or what you do. A term refers to a program execution unit that accesses and may update various data items in the database.

Export and Import mysql Data in linux Export all data in the entire database 1. Enter the following in the linux Command Line: mysqldump -u userName -p dabaseName > fileName.sql FileName. It is best to add the path name to SQL. Export the data

Analysis of OCP questions 053-16 MEMORY_TARGET, ocp053-16 16. Setting which of the following initialization parameters enables Automatic Memory Management?A. MEMORYJARGET B. MEMORY_MAX_TARGET C. SGATARGET D. PGA AGGREGATE

BIEE connects to SQLServer business data source (Linux environment), bieesqlserverBy default, the mssqlserver data driver is installed on biee11g. You do not need to reinstall the server. The configuration process is mainly based on ODBC. This

MySQL Data processing functions and mysql Data ProcessingData processing functions sometimes process the data obtained from database tables. For example, replace lowercase letters with uppercase letters. This process can be performed on the client

[Translated from mos] Get the session id of the running job, mosjobObtain the session id of the job.Reference Original:How to get the session Id of the Running Job (Doc ID 1604966.1)Applicable:Oracle Database-Enterprise Edition-Version 9.2.0.8 and

MongoDB-NoSQL, nosql Comparison between mongoDB and SQL: The biggest difference from a common database is structured and unstructured. NoSQL: Generally, it refers to non-relational databases. Compared with relational databases, in fact, its previous

How to obtain the correct base estimation and base EstimationOriginal article: http://www.oracle.com/technetwork/issue-archive/2013/13-jan/o13asktom-1886639.htmlI have a question about joining with collections and cardinality estimation. the

The error message "pldeveloper" appears when PL/SQL Developer connects to a 64-bit database. Original Works are from the blog of "Deep Blue blog". You are welcome to reprint them. Please note the following source when reprinting them. Otherwise, you

Redis-cli command summary, redis-cli Summary Redis provides a variety of commands to operate databases and data types. These commands can be used on Linux terminals. Redis-cli command Summary 1. Connection operation-related commands Quit: disconnect)

Mssql returns the table creation statement. mssql returns the creation statement. If OBJECT_ID ('SP _ create_table_ SQL ', 'P') is not nullddrop proc sp_create_table_sqlgocreate proc sp_create_table_ SQL (@ tablename varchar (255 )) as begin -- exec

Configure jumbo frame for RAC optimization and jumboframe for rac Optimization Configure jumbo frame for RAC Optimization) First, let's talk about the concept of MTU: in network communication, there is a concept of MTU (Max Transmission Unit), that