Database Administrator

Oracle Data replication is a technology that implements a distributed data environment. It creates a distributed data environment by copying data on different physical sites. It is different from distributed databases. In distributed databases,

Amanda (Advanced Maryland Automatic Network Disk archive Advanced Maryland Automatic IC Network Disk ArchiverI have heard of network backup software since I first came into contact with Linux, but I have never used it. When I need to back up data, I

OS environment: The RedHat Linux 2007 Virtual OS installed in Virtual PC 9.0 is a bare operating system and has not been installed with any other software. Mysql version: 5.1.7 ========================================================== ==============

When MySQL5 source code is compiled, No curses/termcap library found is displayed, but the installation of curses termcap prompts that the library has been installed.The path can be added during compilation, that is./Configure-with-named-curses-libs

The principle of replacing the cryptographic algorithm is to use the replacement method for encryption, that is, replacing characters in plain text with other characters to form the ciphertext. For example, the plaintext letters a, B, c, and d are

Database Version: SQL> select * from v $ version; BANNER----------------------------------------------------------------Oracle Database 10g Enterprise Edition Release 10.2.0.5.0-64biPL/SQL Release 10.2.0.5.0-ProductionCORE 10.2.0.5.0 ProductionTNS

I. SCN description I have also compiled several Oracle SCN articles as follows: An in-depth study on the relationship between the time modification problem and SCN of the Oracle DB Server System Description of Oracle Blockscn/commit scn/cleanout scn

Synchronize and copy data from a remote Oracle Server to a local backup database Create or replace PROCEDURE "SYNC_DATA_FROM_DBLINK_DB"BEGINDECLARECURSOR c_TabNames ISSelect tname from tab;V_TabName c_TabNames % ROWTYPE;V_ SQL VARCHAR2 (500

Dblink is used to perform regular synchronization from Oracle to oracle. A synchronization just made on the card center is used as an example. Recommended reading: Use Oracle DBLink for table Synchronization Use Oracle DBLink Oracle accesses

MySQL replication process: each time a write operation is executed, it stores a copy in its own database. At the same time, this write operation is also stored in a binary log file, and save them as events. Therefore, each write operation or

When viewing the SQL Execution Plan, we will find that there are many table connection methods. This article introduces the table connection methods to better understand the execution plan and understand the SQL Execution principles. I. Connection

Oracle bug Document ID 549781.1 Versions affected from 10.2.0.2.0 to 11.2.0.3.0 An error is reported, but the expdp log indicates that the operation is successful. oracle indicates that the exported dmp file is good. This error can only be ignored

Confirm environment: Source database: System: RedHat Enterprise 5.4 Database Version: Oracle 10.2.0.1.0 IP: 10.37.100.100 Target database: System: RedHat Enterprise 5.4 Database Version: ORACLE 10.2.0.3.0 IP: 10.37.100.101 Tablespace to be

MongoDB is a high-performance, open-source, and non-pattern document-type database. It can be used in many scenarios to replace traditional relational databases or key/value storage methods. Basic concepts: NoSQL It generally refers to

The number and type of BUFFER headers in the buffer cache can be viewed through the preceding table, and you can see the SQL query results you have previously understood: ZN @ PROD> select * from t8; X Y--------------------1 2 ZN @ PROD> select

For frequent index update, the delete operation produces index Frag, which affects index efficiency and increases index IO. 1. Index fragmentation analysisTest Index fragmentation:SCOTT @ devcedb> select count (*) from obj;COUNT

This is just a simple MySQL setting. However, many images are simple, but security is ignored. Therefore, you must be clear about the details and meanings of the settings. MySQL remote connection settings The steps are as follows: 1. log on to the

ORA-15041: the direct and indirect impact of diskgroup space exhausted on your database environment? Disk Space Problems and ORA-15041 errors related to the ASM disk group can have a serious impact on the database environment, as shown in Database

1. Order During the historical data transfer-out test, through continuous optimization, including SQL adjustment and database adjustment, we can see from AWR that it is basically difficult to improve performance, therefore, we are prepared to try

If you want to prohibit an IP address from accessing the Oracle database, you can use the Valid Node Verification function. 1. Set in $ ORACLE_HOME/network/admin/sqlnet. ora: TCP. VALIDNODE_CHECKING = yes TCP. EXCLUDED_NODES = NODES = (finance.us.