Database Administrator

This article demonstrates how to use Oracle ROLLUP grouping functions to experience the charm of Oracle functions in the field of statistical query. The ROLLUP grouping function can be understood as the simplified usage after the Group By grouping

DATETIMEType is used when you need to include the date and time information at the same time. MySQL retrieves and displays DATETIME values in 'yyyy-MM-DD HH: MM: ss' format, the supported range is '2017-01-01 00:00:00 'to '2017-12-31 23:59:59 '.

1. Oracle client Configuration 1. find the oracle installation directory → db_1 → NETWORK → ADMIN → modify the listener. ora file and tnsnames. open ora notepad and check whether the host is the host name of the current computer. If not, change it

I have studied several free database software to reduce the license fee. Here are some personal tokens for reference only. The first research is the well-known DB2, a database software that I have never been familiar with in my mind. It is said

Adjust the Byte of the CHAR/VARCHAR2 field of the table to CHAR Use the following SQL script: SetServeroutputOn DECLARE Sqlstr varchar2 (4000 ); CursorSqlcursIs SelectOwner, table_name, column_name, data_type,

I will briefly describe some practical and common parameters of goldengate. 1. Parameters for Bidirectional replication to avoid circular Data Replication First, describe circular replication, which is described on the official website: In a

PostgreSQL has a very useful built-in function, generate_series, which can be used to generate a series of filled data according to different rules.I. Syntax generate_series(start,stop) --int or bigintgenerate_series(start,stop,step)

Part 1: Test conditions A. IP Address 192.168.1.52 node1 192.168.1.53 node2 192.168.1.55node1-vip 192.168.1.56 node2-vip 10.10.10.52 node1-priv 10.10.10.53 node2-priv 192.168.1.60 racdb-cluster-scan B. Version: Oracle 11gR2 (11.2.0.2) Part 2: Test

MySQL remote Incremental Backup: #! /Bin/sh    # MySQL Info Sqluser = root Sqlpsw = root /Usr/bin/mysqladmin-u $ sqluser-p $ sqlpsw flush-logs --Default-Character-set = GBK DATADIR =/data/mysql BAKDIR =/home/backup/mysql/daily TEMPDIR =

If you want to restart the listener, you cannot find it. [Oracle @ node1 ~] $ Srvctl stop listener-n node1CRS-0210: cocould not find resource ora. node1.LISTENER _ NODE1.lsnr. View listeners [Oracle @ node1 ~] $ Srvctl config nodeapps-n node1-lThe

1. Modify the/etc/oratab FileDb1:/home/Oracle/product/11.2.0/db_1: Y$ ORACLE_SID: $ ORACLE_HOME: Y2. Modify the Startup File $ ORACLE_HOME/bin/dbstart.Change ORACLE_HOME_LISTNER = $1 to ORACLE_HOME_LISTNER =/home/oracle/product/11.2.0/db_1.3. Modify

Explore TRIM FunctionsThe simplest function of Oracle TRIM is to use it to remove spaces at the beginning and end of a string row. This function is also the most frequently used function.However, the Oracle TRIM function is actually capable of

This document will introduce the following content: 1. Configure master-slave replication for mysql2. Configure semi-sync3. SSL-based Replication4. Copy Filtering5. Master Model I. System Environment Master: 192.168.56.101Slave: 192.168.56.102MySQL-5

Integrity and consistency are the core content of a database in business applications. MySQL uses the InnoDB engine to implement transaction processing ), therefore, more checks and restrictions are required for data tables using the InnoDB engine.

I just solved the problem of asynchronous io. I 'd like to describe how to set asynchronous IO in Oracle.First, check whether the package of asynchronous io has been installed on the operating system. If not, install it through rpm and check the

Environment: Sys @ ORCL> select * from v $ version where rownum = 1;BANNER----------------------------------------------------------------Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-ProdSys @ ORCL>! Uname-Linux localhost. localdomain 2.

Are you doing everything you can to optimize the performance of the SQL Server database? If your database contains a large number of tables, putting these table partitions into an independent file group may benefit you a lot. The Table Partitioning

For Oracle 10g, Oracle no longer provides support and download services, and Oracle does not provide support for installing Oracle 10g client on Windows 7. Generally, you can download vista_w2k8_x86_production_client of version 10203 or 10204. If it

MongoDB does not provide the installation package. You can download the package directly to learn how to use it. Installation: 1. Run: D: \ Tools \ mongodb \ bin> mongod -- dbpath "E: \ MyProject \ Web \ mongo \ data" on the console. Note that

Manage databases 1. create a database: create database name; 2. Connect to the database: use database name; 3. delete a database: drop the database name; Manage tables 1. create a table: create table Name ( Table Name Data Type (length ), Table Name