Database Administrator

Solution to Oracle temporary tablespace being too large There are two ways to solve the problem of temporary tablespace too much in Oracle. One is to increase the size of the temporary tablespace and the other is to create a temporary

Steps and solutions for installing Redis in Linux This document details the steps for installing Redis in Linux and the solutions to related problems. Step 1: Decompress the installation package on the Windows platform and copy the package to

How to Use MongoDB performance analysis tool mongostat Mongostat is a MongoDB performance analysis tool used to check the running status of mongodb. Test: Test/node-131/# restart stat -- helpUsage:Using stat Monitor basic MongoDB server statistics.

MySQL official source cannot be started after direct yum upgrade from 8.0.3 to 8.0.4 Server Environment: CentOS 7.4.14 Problem: MySQL cannot be started normally View logs 2018-02-23T02: 10: 08.371209Z 0 [System] [MY-010116]/usr/sbin/mysqld (mysqld 8.

The temporary tablespace and undo tablespace used to import data from Oracle impdp are full. For Oracle data migration, we may use the expdp/impdp method. Sometimes large tables and lob fields may consume large temporary and undo tablespaces.

Joint primary key (joint index) Index Analysis in SQL Server (MySQL) Some people have recently asked this question, but they have not studied the specific use logic of the joint index before. They have read many articles and obtained some

C language programming example of MongoDB in Linux The following describes the C language programming example of MongoDB on the Linux platform. Assume that MongoDB has been installed. 1. download and install the MongoDB C language driver Here the

Oracle tablespace deletion Problems and SolutionsProblem 1: An error ORA-29857 was reported during tablespace Deletion Table space deletion statement:DROP TABLESPACE SAC INCLUDING CONTENTS AND DATAFILES;According to the MOS document:How To Resolve

Ubuntu 10.10 Oracle 10g graphic tutorial Environment: Host XP, 3 GB memory, VMware: Ubuntu10.10, hard disk 30 GB, memory 1024 MB The installation of virtual machines is not described. 2. Update ubuntuSudo apt-get updateSudo apt-get upgradeOracle is

SQL Server attaches Database Error 5123 correct solution Because I have a database tutorial based on SQL Server 2005, the sample database used in the tutorial is AdventureWorks for SQL Server 2005, and my computer is equipped with SQL Server 2008,

Use Toad for remote Oracle 12C data connection 1. Install Oracle12c on the local machine. If you want to install a database on the local machine, select to install data. If you only need to connect remotely, skip this step without installing a

Mysql-related applicationsCommonly used MySQL commands are full. Connection MySQL format: mysql-h host address-u username-p User Password 1. Example 1: connect to MYSQL on the local machine. First, open the DOS window, enter the directory mysqlbin,

12 MySQL/MariaDB security best practices for Linux and mariadb Best Practices MySQL is the most popular open source database system in the world, and MariaDB (a MySQL Branch) is the fastest growing open source database system in the world. After

Why does database middleware not support join? Does middleware support join? Some netizens have doubts that database middleware only supports four types of SQL in the article "Let you design database middleware: Partition key common Query IN

Detailed description of the PostgreSQL Partition Table (partitioning) application instance, postgresql Partition Table Preface Vertical table sharding is required in the project, that is, data is split into n tables according to the time interval.

Library cacheHandle stores the lock and pin information. In addition, both the Library cache handle and child cursor have lock and pin. These are called library cache lock and library cache pin. Library cachelock/pin is used to control concurrent

Many people know that SQL injection and SQL parametric query can prevent SQL injection, but not many know why it can prevent injection. This article focuses on this issue. You may have seen this article in some articles. Of course, it is okay to

1. select the most suitable field attribute MySQL can support access to large data volumes, but generally, the smaller the table in the database, the faster the query will be executed on it. Therefore, when creating a table, we can set the field

Editor's note: the goal of database optimization is to avoid disk I/O bottlenecks, reduce CPU utilization, and reduce resource competition. However, you must be careful not to optimize it blindly. Related Articles: Database optimization design

BKJIA Summary: in the previous article, we read performance considerations for DB2 concurrent connections. This time we will focus on performance optimization in the complex DB2 application environment. The current production environment is very