Database Administrator

Summary: Recently, we have been conducting business stress tests to improve the system's transaction processing capabilities. The transaction processing volume is nearly three thousand from the first 10 thousand to today, and some optimization

I created a storage process for sending emails a few days ago and wanted to automatically send the daily running status of the database to my mailbox. I did not expect the problem to occur the next day, A large number of xxx_j000_xxx.trc files are

At three o'clock P.M., the server was shut down and recovered several minutes later. remote connection to the Windows virtual machine showed abnormal shutdown.   The website is abnormal, and the database is damaged due to abnormal shutdown and data

By default, MySQL processes "data out of bounds" and other abnormal data according to the following rules.1. For numeric data or time data columns, values beyond the valid range will be stage to the nearest value range boundary;2. If the string data

In database operations, we often encounter garbled code, which is really disturbing. Although we haven't fully understood some of the principles, we can summarize some experiences, guide later. In general, we 'd better set the unified encoding mode

At a.m. on July 22, May 10, a text message was sent to the police. The XXX Business Database went down and was busy with various problems, so it was only possible to troubleshoot it at night. Let's take a look at the alarm information first, 650)

When using a stored procedure, we usually only need to grant the corresponding permissions to the account that calls the stored procedure. However, in fact, the stored procedure defines whether the user can directly execute the stored procedure, if

This article was sponsored by 51cto.com and first launched in the dark world. In the previous article, I introduced how to use Navicat for SQLServer. Today I will introduce its fellow teacher Navicat for Oracle. Navicat for Oracle is a client tool

What is row Migration & Row link? # The following description is from Oracle 11gR2 Document 1. Line Link The row is too large to fit into one data block when it is first inserted. In row chaining, Oracle Database stores the data for the row in

Redo master-slave replication at night, and adjust my. cnf of the slave database by the way. In the morning, I forgot to restart the slave database. After I run the command and enable slave, an error is returned. Last_ SQL _Errno: 1286Last_ SQL

A recent project requires a high-availability master-slave synchronization of mysql + keepalived, which is of course easy to configure. However, it is easy to think about how to restore data as quickly as possible after the master database is

When the client connects to the oracle database through the network in the form of "connect user name/password @ connection string", the listener needs assistance. After the connection is established, even if the listener fails, the established

Introduction: In recent years, all-in-one cloud servers have been surging. Many IT industry-level companies have successively launched their own all-in-one servers. As the name suggests, an all-in-one machine is a cloud server with superior

According to the customer's requirements, we need to move the oracle Database Control Files, data files, and online log files from the local disk to the storage to prepare for the subsequent cluster work. Therefore, we have prepared two solutions,

As an Oracle database developer or DBA, you will often encounter this problem in practice: when trying to create a unique index for a column or several columns in the database table, the system prompts the ORA-01452: you cannot create a unique index

You need to pay extra attention when creating synonyms that contain database links. Otherwise, problems may occur. If the synonym points to the object of the current user, there will be no problem: SQL> CONN YANGTK/YANGTK @ YTK is

1. query the execution plan of the statement being executed (that is, the actual statement execution plan)Select * from v $ SQL _plan where hash_value = (select SQL _hash_value from v $ session where sid = 1111 );The id and parent_id indicate the

The ORACLE database consists of three types of files: data files, control files, and online log files. The database administrator may consider moving database files due to disk space changes or adjustments based on database disk I/O performance. The

Field Type of Informix Field Type Description Field Length and default value Char (size) It is used to save string data of a fixed length (size) byte. Fill in space for less than the fixed length of each line). The

Platform: windows 2000 server sp3 Database: Oracle 9.0.1.1.1 Field Description: The user complained that data cannot be processed for multiple units at the same time. The error message displayed during execution is: SQL> exec