Database Administrator

Scenario 1:[Oracle @ www.bkjia.com ~] $ Sqlplus/as sysdbaSQL * Plus: Release 11.2.0.1.0 Production on Tue Jun 26 20:52:47 2012Copyright (c) 1982,200 9, Oracle. All rights reserved. Connected:Oracle Database 11g Enterprise Edition Release

In this article, we will learn how to install and use the PostgreSQL module, includingChkpass,Fuzzystrmatch,IsnAndHstoreThe. Module adds different functions to the database, such as management and monitoring tools, new data types, operators,

I. IntroductionNoSQL databases become more and more popular because of their scalability. Using NoSQL databases can bring you more benefits. MongoDB is an open-source NoSQL database compiled in C ++ with high scalability. This article describes how

Syntax of the Create Package CREATE OR REPLACEPACKAGE [body] packagenameIS END; Sample: CREATE OR REPLACEPACKAGE overloadedIS PROCEDUREInsby (namein VARCHAR2 ); PROCEDUREInsby (numbin PLS_INTEGER ); ENDOverloaded; /

Deploying Spring applications to CloudFoundry.com is simple, as SpringSource says. After you register your Cloud Foundry beta account, install CloudFoundry in STS for Eclipse. Here is a blog detailing how to install it. I will not describe it

During the weekend, developers used a machine for testing and installed a one-click installation package lnmp. As a result, I got rid of the mysql-server installed on the original rpm on this machine, but I don't know how they got it, the files

Manually add control filesMethod 1,1. Modify the control file information in the parameter file spfile.SQL> alter system set control_files ='/Database/oradata/yang/control01.ctl ','/Database/oradata/yang/control02.ctl

Mysql ddl maintenance skills During ddl maintenance of tables (such as adding fields), mysql locks the table. Unlike Oracle, mysql only updates the dictionary table, which is extremely fast, this is because mysql uses an intermediate table to

CentOS, apache2.2.4, database Mysql-5.0.18. Use the mysql source package for installation, or use the mysql Binary Package or rpm package for installation. 1. Add a logon user and group: # Groupadd mysql # Useradd-g mysql 2. Decompress

Background:An incomplete SCN-based recovery was previously implemented. During the restoration attempt, the _ allow_resetlogs_uption parameter was used. After resetlogs, the current control file used by Oracle does not allow recovery from this

When optimizing MySQL configuration, add skip-name-resolve to check the startup log when you restart MySQL. Warning Information is found. 120726 11:57:22 [Warning] 'user' entry 'root @ localhost. localdomain 'ignored in -- skip-name-resolve mode. 1

1. download the latest version of postgresql: http://www.postgresql.org/ftp/source/ 2. decompress the file:Tar zxvf postgresql-8.3.7.tar.gzCd postgresql-8.3.7 3. Configuration:./Configure -- prefix =/usr/local/pgsql 4. Compile:Make 5.

When performing a multi-table joint query, if we view its execution plan, we will find a connection method between multiple tables. I was planningSqlplusThe execution plan is used, but the format looks

I.Description A friend's library cannot be opened. The error message is as follows: Errors in filef: \ app \ administrator \ diag \ rdbms \ orcl \ trace \ orcl_ora_assist.trc (incident = 89062 ): ORA-00600: Internal error code, parameter: [4194], [78

MySQL has been supporting stored procedures since MySQL 5.0 and has been using the latest version of MySQL 5.5 for several years. Although the exception handling in MYSQL is not perfect, it is sufficient to handle most applications. Exception

In the traditional undo management mode, Oracle treats undo and data block equally. There are three drawbacks: 1) at the beginning of the transaction, the segment header for storing the transaction table is not in memory, and the server process

At the beginning, we first use an experiment to introduce the transaction: Sys @ ORCL>SelectXid, xidusn, xidslot, xidsqn, ubablk, ubafilFromV $Transaction; No RowsSelected The corresponding transaction information is not found. Use hr to

Typical Oracle recursive algorithms are used. For example, under a multi-level department, a sub-department cannot be the parent department of the parent department. For example, the father department has a son department and B son department. The

A zero-level Incremental backup is equivalent to a complete backup, which contains all used data file blocks.RMAN> backup incremental level 0 database; Level 1 differential backup is the default Incremental backup. This backup only contains the

Content One of the most notable features of import is the import mode, because to a large extent, the mode determines what to import. Apply the specified mode to the operation source, such as the source or dump file set, or another database