Database Administrator

1. Migration of ASM files ASM file migration refers to migrating database files located on the file system to the ASM disk group, or migrating database files located on the ASM disk group to the file system. As shown in: Ii. migrate from the file

  Active Directory snapshot Management Through the Active Directory snapshot function, we can easily see the information in the original AD before recovering the AD information, such as users, groups, OU and other information. Let's do

High Availability of SQL ServerEvery time we talk about the high availability of SQL Server, many DBAs, especially SQL Server DBAs, feel a pain: Because we all think that SQL Server cannot or is difficult to implement SQL Server. There are also a

Here, we will not talk about those major aspects, such as understanding the overall situation of the entire IT environment. If you already know this, you need to face these living databases. here we have summarized some general ideas to face a

BKJIA database channel also recommends the database index and query topic. I believe this topic will help you better understand this article. In order to get information from a book, how can we make it more effective? Should I carefully read the

In the previous two slides, I shared with us the role of SET QUOTED_IDENTIFIER and introduced a simple string segmentation function. This time, I will introduce how to find out the types, field sizes, whether it can be blank, whether it is a primary

According to the Informix Data Warehouse System implementation methodology, we can divide the data warehouse implementation into the following steps: 1. Business Demand Analysis Business Requirement analysis is the basis for data warehouse

The interconnection of different database platforms is generally called the heterogeneous service of databases. Currently, all major databases can achieve such Heterogeneous Interconnection, but the specific implementation technologies of different

For a long time, multimedia information has been stored in the computer as files and managed by the operating system. However, with the development of computer networks and distributed computing, multimedia information has been efficiently managed

Oracle Database is a very popular database system. Many large websites use Oracle. It is favored by users because it has the following outstanding features: 1. Supports high-performance transaction processing for large databases and multiple users.

Oracle Database 10 Gb provides a tool for significant improvement: Automatic workload information library (AWR ). AWR is installed with the database to collect statistics and export metrics. Fast driver testing By running the awrrpt. SQL script in

BCP is a command line tool used in SQL Server to import and export data. It is based on DB-Library and can efficiently import and export large batches of data in parallel. BCP can be used to export tables or views of a database, or filter tables or

Introduction Database Security refers to protecting the database to prevent data leaks, changes or damages caused by illegal use. Whether the system security protection measures are effective is one of the main indicators of the database system.

When you perform a sun cluster dual-host switchover, unexpected power failure, or other situations, the shared disk may sometimes fail to be mounted. You need to use FSCK to repair the shared disk. After the restoration is completed, the database

Enterprises with geographically dispersed subsidiaries are geographically dispersed, resulting in scattered business data. The company and its subsidiaries are located in different cities or regions in different cities, in terms of business, apart

I often see some people ask, MSSQL occupies too much memory and continues to grow; or it has been set to use memory, but it does not use so much. What is this? First, let's see how MSSQL uses memory. The biggest overhead is generally used for data

Bkjia.com exclusive Translation]Oracle has made great efforts in simplifying memory management over the past few years. Since Oracle 9i implements automatic PGA management through the PGA_AGGREGATE_TARGET parameter, Oracle 10g implements automatic

High Availability is a key requirement for important database applications. IBM DB2 9.5 provides many features to meet this requirement. If you are not familiar with DB2 on the distributed platform, or have been using it for a while, you may find

For a long time, data migration or extraction between heterogeneous databases is required. If Oracle Data is extracted from SQL, You Can Use ODBC, OLEDB, and other methods to extract SQL data from Oracle, most of them are implemented through

MySQL is a very popular small relational database management system. Currently, MySQL is widely used in small and medium websites on the Internet. Because of its small size, fast speed, and low total cost of ownership, especially the open source