Database Administrator

If the primary database fails, Microsoft's SQL Server may crash. Let's take a look at how to deal with such events and learn how to use the Enterprise Manager and query analyzer to repair the primary database. As an administrator of Microsoft SQL

Mysql-stadard-5.0.24-linux-i686.tar.gz does not need to be compiled. I installed it in the/usr/local/directory. Two commands 1. tar-zxvf mysql-stadard-5.0.24-linux-i686.tar.gz # extract the mysql-standard-5.0.24-linux-i386 name under the current

Create a custom pinyin function in SQL:Create function f_GetPy (@ Str nvarchar (400 ))Returns nvarchar (4000)AsBeginDeclare @ strlen int, @ re nvarchar (4000)Declare @ t table (chr nchar (1) collate Chinese_PRC_CI_AS, letter nchar (1 ))Insert @ t

This article uses instances to analyze the solutions for Website access failures caused by database deadlocks. Problem: the website cannot be accessed. After the host is restarted, the website runs normally. Solution: Database deadlock. Cause of

The Oracle database provides several different methods for starting and disabling databases. This article describes the differences between these methods and their respective functions.1. Start and close the Oracle databaseFor most Oracle DBAs, the

I learned to learn mysql on my own initiative. Of course, I had to install mysql before learning. So I went to the website to find it. I found a lot of articles, but they were a long article, let me see this. When can I see it? It is also a

Combination 1: MySQL + PHP + Linux/FreeBSD/SolarisCombination 2: Oracle + PHP + Linux Combination 3: Oracle +. NET + WindowsCombination 4: MySQL +. NET + Windows Solution:Build a LAN with two computers. A dedicated server provides database support.

If you use Oracle10G, you may find that many junk tables appear in the database, such as: BINjR8PK5HhrrgMK8KmgQ9nw =, it generally does not affect normal use, but in the following cases, we must delete it 1. These tables occupy space 2, if the use

When you use start with connect by nocycle prior When performing recursive data search So the performance of the following two sections of code must be significantly different when you use it, please note that the code can be directly read below to

First understand under what circumstances Oracle will generate a ORA-01555 error: Assume that there is a 60 million-Row Table testdb. It is estimated that it will take two hours to scan the entire table once. The reference process is as follows: 1.

Environment: CentOS 6.2 64bit VMWare Workstation 7.1 In Linux, the automatic memory management of Oracle 11 GB cannot specify the total memory size greater than this/dev/shm. Otherwise, the following error occurs: ORA-00845: MEMORY_TARGET not

Using shell scripts to monitor and manage Oracle databases will greatly simplify DBA workload, such as common instance monitoring, monitoring, and alarm log monitoring, and database backup, AWR report automatic mail, etc. This document describes how

Table Creation Oracle includes five constraints, including primary key constraints (primary key, the value of this attribute cannot be blank, and cannot be repeated. By default, this column is automatically indexed) and foreign key constraints

We all know that each archivelog information is recorded in controlfile. Of course, after deleting these physical files under OS, the archivelog information is still recorded in our controlfile, the Oracle OEM manager displays visualized logs. After

This article records some Oracle Table Access Operations For the stored procedure of displaying the execution plan in Oracle, see (1) TABLE ACCESS FULL Scan a table from a full table and access the table through a full table scan. Example: SQL> exec

Download the installation patch p8202632_10205_linux-x86-64.zip for Oracle RACs. Patches for clusterware and database are included in this patch. 1. Upgrade the clusterware package 1) Stop all resources first. crs_stop-all is not recommended.

1. Error The operating system and database are installed by the service provider. After a few months, I remembered that the database was used. The following error occurs during startup. SQL> startupOracle instance started. Total System Global Area 49

Oracle index access method This article records some Oracle index access operations For more information about table access, see: For the stored procedure of displaying the execution plan, see (1) INDEX UNIQUE SCAN A unique index scan means a single

When CentOS 5 is upgraded to mysql5.1 to start the service, the following ERROR occurs: [Error] error message file '/usr/share/mysql/english/errmsg. sys 'had only 481 ERROR messages, But it shoshould contain at least 641 error messages. Solution:

The Database Installation Guide on different Oracle platforms provides some recommended system parameter settings for Oracle deployment. However, the recommended value is a general conclusion, it does not completely meet different needs. Using