Database Administrator

Oracle group statement Inquiry Learning notes 1. The group by statement does not have the sorting function in Oracle. order by must be used to sort the statements according to the predefined results. 2. cube extension of group With test(Select 1 id,

Oracle object-oriented and set This is a summary of my recent learning experience. 1. Oracle object-oriented We all know that SQL is set-oriented, but it is undeniable that there are many places in oracle that reflect the object-oriented thinking.

Simple installation steps for Oracle 10gR2 Clusterware 1. Install the Operating System (omitted)Note: I use the OEL 5u5 version here. Because it comes with the environment variable installation package provided by Oracle, It is very convenient to

How Does Oracle ASM Add a new disk to a disk? Applicable platform: AIX hp linux win Solaris Applicable versions: all databases 10.1.0.2 to12.1.0.1 Applicable to rac and standalone Take the RAC environment as an example: Assume that Oracle is an

Install MySQL 5.6.22 in CentOS 6.4 This article describes how to install MySQL 5.6.22 in CentOS 6.4 for your reference. 1. Download the MySQL installation package1) http://dev.mysql.com/downloads/mysql/ open web site: Select Platform: choose

Merge datasets in Oracle (Change multiple rows to one row) In Oracle, the dataset is merged (multiple rows and one row), and the relationship between table A and table B is one-to-many. Requirements: Query all the data in Table A and merge A

Create your own Oracle interpretation plan 1. Explain the plan When an explain plan is used to generate an expected execution plan for a query, the output includes the following: Each table accessed by SQL; Method for accessing each table; The join

Basic tutorial on getting started with Redis Redis is an open-source, advanced key-value storage perfect solution for building high-performance, scalable Web applications. Redis inherits three main features from its many competitions: The Redis

The reason why the Oracle task process is not executed after it is submitted /* Run the following command in SQL * Plus */-- Check steps when the task is not running-- 1. Check whether the instance session is restrictedSelect instance_name, logins

Knowledge about MySQL database operations in CentOS 6.5 In CentOS 6.5, you can use Shell to modify the initial MySQL password, enable remote logon, and authorize remote logon users. I recently wrote a Shell script for automated deployment. I need to

OGG synchronizes two Oracle databases Here is a simple example to illustrate how goldengate synchronizes two Oracle databases.The content is as follows:1. Configure the database information.2. Install golden gate.3. Configure golden gate.4. Test

MySQL import data load data infile usageMySQL import data load data infile usage basic syntax: load data [low_priority] [local] infile 'file _ name txt '[replace | ignore]Into table tbl_name[Fields[Terminated by 'T'][OPTIONALLY] enclosed by

Configure master-slave synchronization for the MySQL database 1. Environment Description: DB master: 172.16.1.55DB slave: 172.16.1.562. Server-id configuration (/etc/my. cnf ):The master database configuration server-id is smaller than the slave

Oracle 11g transparent gateway connected to sybase Database I have already compiled two documents about connecting the Oracle transparent gateway to the mysql database and the SQL Server database. I thought that I would not connect to other

Oracle 10g RAC OCFS2 Cluster Storage migration Abstract In the RedHat 5.4 64bit environment of an Oracle 10g RAC ocfs2-Based Cluster, You need to replace the storage and upgrade the 8GHBA card. The process is summarized as follows: Preparation: 1.

Oracle uses a cursor to query a string that combines the names of all fields in a specified data table. Application Scenario: refer to the Code for querying all field names of a data table on the Internet, and use a cursor to generate a list of

After rman incrementally restores the dg gap, the master database adds a new data file, rmangap1) On the standby database, close (MRP)SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;2) On the standby database, obtain the minimum scn

Reconstruction of abstract factory and reconstruction of factory We are familiar with the abstract factory. We have seen it when learning the design model. I also saw it when I started refactoring. However, I have to get a glimpse of it on the paper.

Install mysql using the rpm package and mysql using centos Steps for installing mysql: First,Http://www.mysql.com/downloads/mysql-4.0.htmlDownload MySQL-client-5.0.96-1.glibc23.x86_64.rpm and MySQL-server-5.0.96-1.glibc23.x86_64.rpm Second,Install

[ORACLE] DUMP the redo log, undo and table sections, and redoundo1.1 Use oradebug -- Start the task Oradebug setmypid -- Set the dump file name Alter session set tracefile_identifier = undo -- View the dump file SQL> oradebug tracefile_name; C: \