Database Administrator

Today, I received a case from my friend database. When I created a database in DBCA, I removed the option of automatic statistics collection. The database has not collected statistics for six months. The method to enable this feature is as follows:

Settings of the backspace and direction keys in SqlPlus In the just-installed Oracle, we will find that using SqlPlus is very poor, not only is the backspace key not easy to use, but also the direction key cannot call up history. There are several

To some extent, any software that we take advantage of will add to our learning and life. This blog will talk about how I feel when using Power Designer.   *************************　PowerDesignerCommon

Catalog Database:Catalog indirect: db2 catalog database on/db2sys [dir_name]Catalog remote: db2 catalog database as at node example: db2 catalog tcpip node NODESUN remote 192.168.1.1 server 50000 ostype aix db2 catalog db SUNDB as SUN at node

21. Examine the description of the EMP_DETAILS table given below:Name NULL TYPEEMP_ID NOT NULL NUMBEREMP_NAME not null VARCHAR2 (40)EMP_IMAGE LONGWhich two statements are true regarding SQL statements that can be executed on the EMP_DETAIL table?

I used Windows 7, started learning PHP and MySQL, and bought Head First PHP & MySQL. you can obtain the relevant information and source code of HeadFirst series books from Head First Labs. 1. Download the XAMPP Development Kit Download the popular

This article mainly introduces the installation and configuration-free mysql5.6.19 process. Many mistakes have occurred throughout the process. After finishing the process, we will record a successful process for your reference. Go to the mysq

Preface: Oracle is a typical C/S structure. The server provides oracle service instances, which are mainly used for database management, object management and storage, and data Storage, query, database resource monitoring, monitoring, and other

1. Operating System CentOS release 6.2 (Final)   2. Create users and groups [Root @ mymaster1 ~] # Groupadd mysql [Root @ mymaster1 ~] # Useradd-r-g mysqlmysql   3. Unzip the installation package (decompress it to the location where you want to

Zookeeper Oracle 10g rac start/stop archiving Mode  If the Oracle database runs in archive mode, you may need to suspend the archiving of the database during database maintenance. After the maintenance is complete, restart archive mode.To switch

To ensure database integrity and consistency, You need to execute multiple SQL statements to achieve the desired purpose. In a one-to-many database relationship, such as the relationship between the card number category and card number. If you want

This article introduces the database design based on the three-paradigm of the data room charging system. It only meets the basic functional requirements and does not contain additional information for storage.   Review The Design of Relationship

In the QlikView, you can select certain configurations to easily convert chart types. You can select a chart to view details such as a bar chart, bar chart, or vertical chart. After selecting the option shown in the Fast Type Change option, a

MySQL's order by involves three parameters:A. sort_buffer_size sort cache.B. read_rnd_buffer_size second sorting cache.C. max_length_for_sort_data has the maximum sorting constraint for normal columns.Let me briefly describe the sorting rules of

What is Hbase?Before talking about Hase, let's take a look at two concepts: Row-oriented storage and column-oriented storage. For row-oriented storage, I believe everyone should know that the RDBMS we are familiar with is of this type. Row-oriented

Yesterday, the insert into a select from B statement was used in the stored procedure. When the bigint field is inserted into the int field in the application, the value is truncated. The inserted value is no longer the expected value. Because

1. The installation of mysql is relatively simple. You can download the mysql installation program directly from the official website to complete the installation process. There are many installation tutorials online. There is no need to pay

The update operation nodes of GoldenGate are not synchronized.Fault description: synchronization cannot be implemented after update is performed on node 1 and node 2.Solution Process:1. Regular inspection: Check the Process status: normalGGSCI (gc1)

ZookeeperChange the oracle cluster NIC (Changing a Network Interface) If the NIC name, ip address, gateway, and subnet mask remain unchanged before and after the NIC, no additional operations are required at the cluster level! Next, use the new

Part 1 Database SQL language Saving important table information during database storage and related suggestions   1. Saving important table information in the Stored Procedure In many stored procedures, table data may be updated, inserted, or