Database Administrator

GreenPlum database fault recovery test This article describes gpdb master fault and recovery testing and segment fault recovery testing. Environment Introduction:Gpdb version: Binary version 5.5.0OS: CentOS linux 7.0Master segment: 192.168.1.225/24

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

Alter table tablename add (column datatype [default value] [null/not null],...); Alter table tablename modify (column datatype [default value] [null/not null],...); Alter table tablename drop (column ); Alter table is used to add, delete, and

The project team needs to install Oracle on a remote HP minicomputer. The hardware information of the system is as follows: The software information is as follows: 1. Download the correct Oracle Installation version HP-UX can run on HP's own

Select sum (bytes) from dba_segment: waiting for 'gc cr request', dba_segmentgcSO: 0x5533efea0, type: 4, owner: 0x554631060, flag: INIT/-/0x00 if: 0x3 c: 0x3Proc = 0x554631060, name = session, file = ksu. h LINE: 12624 ID:, pg = 0(Session) sid: 388

Sqlite Study Notes 2: Create a database and sqlite Study Notes In the last note, an sqlite executable file is generated, and cd is executed under the directory where sqlite is located: Sqlite3 MyDataBase. db A database named MyDataBase. db is

Chapter 1 Securing Your Server and Network (9): use Kerberos for authentication, securingkerberosSource: Workshop Without the consent of the author, no one shall be published in the form of "original" or used for commercial purposes. I am not

The root User Name in ubuntu cannot enter mysql, how to view the user name and password, how to modify the root password, and tumysqlMysql-u root-p Press enter. after entering the password, the system prompts "access denied... ues password YES/NO"

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

The problem occurs when the remote db2 is used to create a data source and the test connection fails. Many people say that it is a driver problem. Copy db2cc. jar to a lib directory, and the experiment fails;   When I saw a buddy's blog, I finally

1. What is ASM? ASM is called Automatic Storage Management (Automatic Storage Management). It is a new feature launched by Oracle 10 Gb. This is a volume manager provided by Oracle to replace the LVM provided by the operating system. It not only

This document describes the storage format of DateTime and how to use DateTime. This document describes the rounding of the DateTime type. 2. rounding issues) The conversion between DateTime and String is always accurate. For example, if "20060923 03

After introducing the transaction concept in SQL Server, we can continue to introduce this article. We can include the entire package in SSIS in a transaction. But what if a table needs to be locked during package execution? The built-in transaction

How to configure SQL Server for remote backup? The following describes the configuration method: (ASE version 12.0 or later) On the local machine: 1. modify the interfaces file and add the Backup Server entry (Backup Server name, address, and port

After being set to "suspicious", I was puzzled that I had not encountered such a situation before. I asked a few seniors who still did not find the problem. Finally, I have solved the problem. Now I want to share my solution with you: First, the

BKJIA featured translations] in the previous articles, BKJIA briefly described several new features of Oracle 11g R2, referring to the Oracle 11g topic ). Finally, let's make a summary to introduce some of the new features in Oracle 11g R2, which

We need to pay attention to the execution of search and so on during MySQL SQL statement execution. BKJIA recommends the MySQL database getting started and proficient tutorial. Case sensitivity when executing the SEARCH Command By default, MySQL

From the perspective of users and developers, Windows Phone 7 brings us many new and exciting features. At the same time, the current Windows Phone 7 series does have shortcomings that disappoint many users. One typical pity is that Windows Phone 7