Database Administrator

Oracle Enterprise 8.0.5 produced by ORACLE won the favor of many users for its superior performance,It provides developers with a wide range of embedded functions, PL/SQL support, multi-platform, Application Server integration, etc.Great flexibility.

Role of Audit1. Review suspicious activities2. monitor and collect data about specified database activitiesAudit type1. STATEMENT Audit statement auditing)2. Permission Audit privilege auditing)3. OBJECT audit object auditing)Audit informationThe

ORA-01650: unable to extend rollback segmentname by NUM intablespace NAME Cause: the preceding ORACLE error is caused by insufficient tablespace In the rollback segment, which is also the most common ORACLE error message of the ORACLE Data

The customer requested that the mysql-5.1.32 be a gbk version I downloaded the Binary source code from mysql.com. You don't have to compile and install it yourself. Later, we found the latin1 language ~ Search online for a long time, a useful

Speaking of Cache caching, The BKJIA database channel has previously published the topic MySQL memory management: Cache art, which is recommended to you. Cache and Buffer are two different concepts. Simply put, Cache accelerates "read" while buffer

We know that sybase SQL Server uses Transaction to track changes in all databases. A transaction is the unit of work of SQL Server. One transaction contains one or more T-SQL statements that are executed as a whole. Each database has its own

It provides a strong guarantee for the Agricultural Bank system to collect vertical and horizontal business data in a timely manner and generate statistical reports according to different requirements for comprehensive business activity analysis.

During the installation of Oracle10g RAC, it is extremely important to exercise caution when setting the network. The following lists the network configurations of my Oracle10g RAC environment for your reference. 1. settings of the hosts

Question: How to import and export data between Oracle and Access tables in FORM programs. Answer: Preparations: 1. Install OCA. Run the Developer's installation disk, select Custom installation, and select Oracle Open Client Adapter for ODBC for

1. on a Windows machine with Oracle9i Standard Edition or Oracle9i EntERPrise Edition installed (IP: 192.168.0.2), You must select the Transparent Gateway (Oracle Transparent Gateway) to access the Microsoft SQL Server database. The initpubs. ora

Several problems encountered during the configuration of the Sybase library today have not been found for a long time, so they are recorded here. 1. Enable the dump transation log on checkpoint option. use master go dump transaction

Oracle partitioning improves the manageability, performance, and availability of many applications. Through the partition function, you can further segment the table, index, and index organization table to more accurately manage and access these

DML performance is low. One of the most serious causes is the existence of useless indexes. All SQL insert, update, and delete operations will become slower when they need to modify a large number of indexes when each row of data is changed. Many

In application systems, especially online transaction processing systems, data query and processing speed have become the criteria for measuring the success or failure of application systems. Using indexes to accelerate data processing has become an

In the past decade, Oracle has become one of the world's most professional databases. For IT experts, IT is to ensure that their company's productivity is improved by leveraging the powerful features of Oracle. One of the most effective methods is

The time consumed when preparing to use the Oracle execution plan mechanism to improve query performance new SQL statements is the most important component of the Oracle SQL statement execution time. However, by understanding the internal execution

1. Export/Import (Export/Import) The Export can be used to extract data from the database, and the Import can be used to send the extracted data back to the Oracle database. 1. Simple Export of data (Export) and Import of data (Import) Oracle

Q: How can I solve the SQL Server alarm problems? A:For specific solutions, refer to the following: ◆ Check whether you have used the latest SQL Server service pack. This is because many SQL Server warnings (Alerts) vulnerabilities have been fixed

Oracle and Microsoft are two major database products in the history of database development. This leaves little room for selection of databases, either Microsoft or Oracle. However, there is a big difference between them. Today, I will talk about

Because the MySQL server has a variety of installation and distribution capabilities and can run on a variety of operating platforms, it also has a variety of Start and Stop methods. You can use one of them according to your actual situation. When