Database Administrator

The following method is a general summary of the massive data processing methods. Of course, these methods may not completely cover all the problems, however, such methods can basically deal with the vast majority of problems encountered. The

In Oracle RAC, in addition to the TAF Method Based on the client, there is also the TAF Method Based on the server. You can regard the TAF method of the server as an upgraded version of the TAF method of the client. The TAF of the server must be

When I first started using mysql, I first wanted to differentiate the case sensitivity of column names. I found many methods on the Internet, so 1. After mysql is installed in linux, the default value is: case-sensitive for table names, not

When a report is displayed in Cognos, the "no available data" is displayed because there is no data. So I want to use an image instead. There is a "no data content" in the chart attribute. After clicking "open", there are three options: 650)

Shell is an interface between the operating system and the user. It can explain the commands issued by the user, start the application, and use the system functions to manage user data. Shell can run multiple processes at the front end or backend

I. Introduction to Aix Aix is one of the versions of Unix operating systems. It is mainly used on the IBM Xeon 6000 series computers. Other Unix systems, such as SUN's Solaris, HP Unix, and Linux. Currently, the Aix system versions include Aix 4.x

After installing an oracle 11.2.0.3 rac test environment on the 64-bit centos5.8 system, it is found that acfs and advm cannot be used, and the acfs and volume tabs on the ASMCA graphic interface are gray! This is because acfs does not support the

On a production AIX server, the DB2 database needs to be backed up. The SQL2059W error is reported in the backup. The details are as follows: $ Db2 backup db happydb online to/backup include logsSQL2059W A device full warning was encountered on

Oracle logic import and export tool exp/imp Exp/imp introduction: Exp/imp is the oldest two command line backup tools survived by oracle. It is widely used in small database dump, tablespace migration, table extraction, detection logic, and physical

Sheng Ge 1.1 million drops on Data Guard past and present Note: More details are available ~ 116 page From birth-> out-of-service full-lifecycle DG edition [departure form] 650) this. width = 650; "src =" http://www.bkjia.com/uploads/allimg/131228/22

Databases are designed for transactions and data warehouses are designed for topics. Databases generally store online transaction data, while data warehouses generally store historical data. Database Design is designed to avoid redundancy as much as

Index View: Generally, all views are virtual tables, that is, the view itself does not store data and is a query. when accessing a view, SQL SERVER automatically accesses the base table data according to the view definition. Views with unique

Monitoring over 250 configuration parameters and thousands of measurements is not an easy task for Oracle administrators to monitor the overall health of their Oracle databases. Oracle provides a variety of tools to monitor performance, but this is

Preface In a single application environment or system with relatively simple business, the bottleneck of system performance problems is often self-evident. The premise for solving the problem is that locating the problem is easier to solve, however,

Informix-SQLVersion6.05.UD1 Application 1. Create and delete databases, base tables, and indexes 1. Syntax conventions: Indicates a required parameter.{...} Indicates required items.[...] Indicates the option(...) Indicates a part of the statement.|

Detailed configuration process of Apache2 + php4.3.6 + MySQL4.0.20 + SSL: First install and put all the required files under the root directory: 1. MySQL-client-4.0.20-0.i386.rpm 2. MySQL-server-4.0.20-0.i386.rpm 3. httpd-2.0.49.tar.gz 4.

Oracle Enterprise Manager is a management framework that enables you to manage a Complete Oracle environment, including databases, iAS servers, applications, and services. Diagnose, modify, and optimize multiple databases. Tasks are scheduled at

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

A colleague using the Informix database needs to use wildcards to search for the TEXT column. Although Informix supports wildcards in the LIKE and MATCH declarations, this does not include TEXT columns. The solution for outputting data to SQL Server

AWR (Automatic Workload Repository) is a new tool provided by Oracle 10 Gb to collect database statistics. It mainly includes the AWR memory area, historical data storage files, ASH and other components. The main content of the AWR report includes