dba

Case: In order to reduce the burden of the core database, we use the logical standby technology to separate the influence of physical reading on the core database. However, a report application has used a large number of intermediate tables in the

This article is also suitable for Oracle DBA and MySQL DBA Reading Bare devices apply to Linux and Windows In Oracle and MySQL is also supporting the bare devices!! Introduced Everybody sees this title must be confused, bare equipment?? A nude

Oracle Oracle 8i Installation manual under Redhat 7.1~7.3 The following take linux7.3 as an example 1. Preparatory work: 1). List of software: compat-egcs-6.2-1.1.2.16.i386.rpm compat-egcs-c++-6.2-1.1.2.16.i386.rpm compat-egcs-objc-6.2-1.1.2.16.i3

Build an application to extract the estimated execution cost of the query from its XML Showplan. Users can only submit queries that cost less than a predetermined threshold to a server running SQL Server 2005, ensuring that the server is not

This article is based on two software ――sql Server and Excel. This article will help you understand how to seamlessly connect the two software to the output of the data. In this way, the reports and information you provide will help them work more

Sometimes the database hangs up, the library will be ORA-00704 error, and the root cause of the ORA-00704 error is access to obj$, Oracle needs to roll back the data in the paragraph, and access to the rollback segment when the need for the undo

Oracle| Program Oracle Configuration Instructions Lixin (University of Petroleum, East China) School of Computer and communication engineering, Dongying 257061, Shandong; 1. Objective After the Oracle installation is successful, some basic

Recently in an enterprise to do an internal system, the database is SQL2000, in order to ensure the security of data, need to do daily after work to do data backup, and mail to notify the administrator of the backup situation. Backup database is

SQL Server database upgrades require a significant amount of planning and testing by DBAs. Most of the time, there may not be any problems with the upgrade process, but some potential threats must not be overlooked. In this article, SQL Server

Login: Enter user name (for example: USER01) Password: Enter user password if the username and password are correct, the user will login successfully. At this point, a command prompt of $ or # appears, representing the operating system commands that

Oracle gives user authorization _oracle user authorization _oracle user authorization Grant (Authorization) command The following is the USER01 authorization for the user created, as follows: Grant Connect, resource to User01; (2) REVOKE (REVOKE)

1. Basic Database Information Version information: Sql> select * from V$version; BANNER ---------------------------------------------------------------- Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-prod Pl/sql Release

Oracle 1, uncompress and unpack downloaded files One step procedure (uses less disk spaces and is faster): Zcat lnx_920_disk1.cpio.gz | Cpio-idmv Zcat lnx_920_disk2.cpio.gz | Cpio-idmv Zcat lnx_920_disk3.cpio.gz | Cpio-idmv Two Step procedure:

Over the past decade, Oracle has become one of the most professional databases in the world. For IT professionals, it is important to ensure that Oracle's powerful features are used to improve the productivity of their companies. One of the most

The three states of the database have similarities, and here's a quick summary. This article describes the state of Quiesce. RESTRICT, Quiesce and Suspend (i): When the database is in the QUIESCE state, only the DBA session can operate, and the

oracle| Security | Data with the popularization of computers and the development of the network, the database is no longer just the topic that the programmer is proprietary. and Oracle database is by virtue of its outstanding performance, easy to

oracle| optimization Over the past decade, Oracle has become one of the most professional databases in the world. For IT professionals, it is important to ensure that Oracle's powerful features are used to improve the productivity of their companies.

In each enterprise development process, almost all need to set up a DBA position. The question is when to recruit the company's DBA and how to choose the right DBA. If you are the boss of a small and medium sized business, then when the enterprise

The complete practice of MySQL backup and recovery One, backing up the environment settings between databases 1, create the database test1, create the table TT Insert the following data mysql> Create database test1; Query OK, 1 row affected (0.0

Oracle Although the Windows platform Oracle has been installed a few back, but Linux has not tried. Look at the documents on the web, it seems more complex than Windows installed, change system parameters, create User&group, check the necessary