Database Administrator

RMAN backup and recovery-parameter file Restoration In RMAN, "restoration" and "restoration" have different meanings. "restoration" refers to accessing the previously generated backup set to obtain one or more objects, then restore these objects at

Usage of the count function in MySQL The count function is a function used to count records in tables or arrays. Here we will introduce the usage and Performance Comparison of the count function in MySQL. Count (*) returns the number of rows to be

Quick Configuration Guide for Oracle 11g Data Guard physical standby Database OriginI recently conducted a physical standby Database Configuration experiment for Oracle 10g and 11g, and found that Data Guard is actually very easy, but there is a

Install Oracle database management software SQL Developer in Ubuntu 14.04 This is the second article about building Oracle Development Environment logs. Article 1: Build a PHP5 + Apache2 + Oracle environment in Ubuntu 14.04 This article will install

MySQL slow Query There are some places where there are rivers and lakes and databases. The problem of SQL optimization is a long way to go. We can't help but have bad SQL. What should I do? Fortunately, all major databases have the collection

MySQL pre-processing technology usage Test MySQL Preprocessing Technology: 1. Reduce server pressure2. Prevent SQL injection. Pass the dangerous characters in the past as parameters.3. Forcibly split an SQL statement into two parts: the first part

Perfmon indexes for SQL Server Performance Optimization Perfmon is a Windows system performance monitoring program. Monitors CPU usage, memory usage, hard disk read/write speed, and network speed.Processor/% Privileged TimeThreshold Value: If the

Archiving logs in the slave database of Oracle Dataguard are not synchronized Environment: RAC + single-host DataguardProblem: when the slave database is started to the ADG mode, the archived logs in the background are not synchronized. 1. the

Jdbc connection string for Oracle pluggable Databases When I deploy a database of a third-party system on the server, the server database version is Oracle 12c. I created an instance. Access is normal. Later, the project owner told me that Oracle 1

MySQL table query command and MySQL table Operation Command1. Basic query statementSyntax:Select attribute listFrom table name (View) List[Where condition expression 1][Group by attribute name 1 [having condition expression 2][Order by attribute

Mysql partition management, mysql Partition The purpose of a hash partition is to evenly distribute data to each partition after hash calculation based on a column. Compared with range and list partitions, the hash partition does not need to

Configure the snmp service in linux and snmp in linux-- How to Configure snmp on Linux-- Attach an iso CD image file firstMount-o loop/soft/rhel-server-6.4-x86_64-dvd.iso/mnt/cdrom-- Check whether the snmp package is installed first.# Rpm-qa | grep

ADO. NET database access technology, ado.net Database Access 1. Definitions of ADO. NET ADO. NET comes from the COM Component Library ADO (ActiveX Data Objects), is a new generation of Microsoft. NET database access model, which is currently used by

Record a "weird" mongodb process exit event and mongodb process exit event In shell, the mongo process is started through mongo args &. After logging out of shell and re-login, the mongo process is found to be gone. The following output is found in

SQL is required. Note chapter 17th to create and manipulate tables. SQL is required.17.1 create a table There are two ways to create a table.(1) Most DBMS have interactive table creation and management tools(2) tables can also be directly

How to back up Oracle batch processing on Windows (with scheduled tasks or third-party timing software, you can achieve automatic backup), oracle Batch Processing@ Echo start to back up oracle Data@ Echo offSetSet curdir = "D: \ backup"Echo % curdir

Path to mathematics-sas memo (18), path to sas memo 18Data _ null _;X = 15.63;Y = 15.13;Xx = ceil (x );Yy = ceil (y );Put xx = yy =;Xx = floor (x );Yy = floor (y );Put xx = yy =;Xx = int (x );Yy = int (y );Put xx = yy =;Xx = round (x, 0.1 );Yy =

Pentaho schema workbench graphic tutorial,Pentaho schema workbench graphic tutorial   The following is a simple example to describe how to use schema workbench. The table example shows a simple sales table, product, product category, and customer

Redis data persistence, redis dataIn general, there are two persistence solutions: RDB and AOF.The RDB method creates a time point-based snapshot for the dataset at a certain interval.The AOF method records the write operations received by the

Mysql5.5 master-slave synchronous replication configuration, mysql5.5 master-slave Synchronization In the previous article "mud: learning the principles of mysql database master-slave synchronous replication", we introduced the basic principles of