Database Administrator

Oracle uses sqluldr2 to export data Sqluldr2 isThe OCI-based text export tool is small and convenient. It is similar to the exp provided by Oracle and supports exporting custom SQL statements, local data, and client data. It is fast and efficient.At

MySQL replication introduction and SetupMySQL Replication MySQL replication is a MySQL Server (slave) that replicates logs from another MySQL Server (master) and then parses the logs and applies them to itself, similar to Data Guard in Oracle. MySQL

Simple springboot example and springboot example 1. What is spring boot? Takes an opinionated view of buildingproduction-ready Spring applications. Spring Boot favors convention overconfiguration and is designed to get you up and running as quickly

Mysql table partitions are partitioned by day, and mysql partitions by day MySQL table partitioning refers to splitting a table into several small tables according to the set conditions. MySQL 5.1 and later versions support table partitioning,

Talking about the function and principle of database index, talking about database index A database index is an identifier attached to a table field to increase the query speed. Many people mechanically understand the index concept and believe that

Summary of the Differences Between on and where filtering in SQL connection query statements, sqlwhere Preface I believe that SQL queries are simple and simple for every programmer. Generally, you only need to add, delete, query, modify, and use the

Use some DataSet functions to log on to the website, and use dataset to log on to the website. First, I have to complete registration and store my personal information in the database. Secondly, some objects in this section are stored in some

Comparison between MySQL and Oracle five stored procedures & functions, mysqloracle Stored Procedure & Function No. Category ORACLE MYSQL Note 1 The statement for creating a stored procedure is different.

'Db file scattered read' is another common wait event. It is generated when Oracle reads multiple blocks from the disk to the non-sequential ("") Cache of the Buffer Cache. The maximum read value is3. because the blocks that use full table scan and

This article describes how to install MySQL 5.6 in the source code of centos. The centos version is 5.8. 1) first, you need to go to the MySQL official website to download the Source Code tar package. Click MySQL Community Server and select Source

In the previous article, the memory management of SQL Server resources), I introduced some theoretical knowledge about memory management of SQL Server. This article uses this knowledge to solve some common problems in reality. I. Optimization of

Databases store data and perform mass computing.SQL commandsTo store, query, and collect statistics to solve problems in the real world. As the amount of data increases dramatically and business rules become increasingly complex, a dedicated method

Yesterday, I shared two articles on the cursor: A Case Study on the Performance of the cursor script, and a case study on the performance of the cursor script, the cursor is briefly described in the article. Today, I found a blog article about

I. Solve the Problem of ORA-07445 downtime in Oracle 9.2.0.6 Database Fault symptom: XX network database goes down. view the log and find the following content: Wed Jun 8 20:24:17 2005Errors in file

I. INSERT and REPLACE Both INSERT and REPLACE statements INSERT new data into the table. The syntax of these two statements is similar. The main difference between them is how to process repeated data. 1. General INSERT usage The INSERT statement in

Web development involves two aspects: layout and content.On the layout, the CGI Module of PERL is powerful and easy to use. In just a few lines, HTML webpages can be dynamically generated. To be fair, you must use a database to manage the content.

When you create a session with Oracle, a dedicated sorting area is located in the server memory to provide the sorting space for the session. However, this sorting space is limited. If the number of records exceeds this sorting space, disk sorting

There are two very small processes in the Oracle database, but their role is very huge. Because it is relatively small, it is often ignored by the database administrator. This time I will remind you not to ignore the role of these two processes. If

Deduplication and data compression can greatly reduce data storage performance requirements and reduce data backup by more than 90%. Reducing backup data can reduce hardware and management costs. However, small and medium-sized enterprises and

This article describes the basic configuration and installation of Mirror for SQL Server 2008. Preparations 1. The Principal, Mirror, and Witness instances are installed in the same version. Currently, they are in SQL Server 2008 SP1. 2. you need to