Database Administrator

Clone and install the database in Oracle 10g and 11g Sometimes in many work environments, if the configurations of several machines are similar to each other, we don't need to install the database software over and over again. We can complete the

Oracle 10g modify SGA_TARGET In Oracle10g, Oracle introduced the sga_target initialization parameter to implement ASMM (Automatic Shared Memory Management), that is, set the target value of an SGA and the maximum value of SGA, database to

MySQL database master-slave and master-master replication configuration demonstration Experimental System: CentOS 6.6 _ x86_64 Prerequisites: Prepare the compiling environment in advance, and disable both firewall and selinux. Tutorial Description:

Oracle 11g partition maintenance (4) -- Exchanging Partitions Swap Partition You can convert a partition (or sub-partition) into a non-partition table by exchanging data segments, or convert a non-partition table into a partition (or sub-partition)

Install MySQL in CentOS 7 Let's talk about how to install the MySQL database in CentOS 7. I hope it will help you. Download the source from the MySQL official website and use yum for installation: # Wget

MySQL tuning and use must-read MySQL should be the most popular WEB backend database. WEB development languages have developed rapidly recently. PHP, Ruby, Python, and Java have their own characteristics. Although NOSQL has been mentioned more

How to increase the Oracle tablespace Increase the Oracle tablespace size: one is to add data files to the tablespace/the other is to increase the size of the original data file in the tablespace 1. Add data files to the tablespace: Alter

Oracle display the usage of the object space show_space, oracleshow_space Tom wrote a script to view the object space usage of the Oracle database.The following shows how to use it: -Tool source code CREATE OR REPLACE PROCEDURE show_space(p_segname

MongoDB Series 4: MongoDB and Java Because of the different versions, the API may also be different. This tutorial uses version 3.0. 1. The jdbc driver version of mongodb used is: mongo-java-driver-3.0.0.jar 2. This section briefly introduces the

Beckham _ redis web management interface tool installation, Beckham _ redisRedisWEB management interface tool InstallationI. OverviewIi. File DownloadIii. Installation Process   I. Overview 1. redis is developed based on C/S. That is to say, as long

Hadoop for. NET Developers, hadoopdevelopersHadoop for. NET Developers (1): Understanding Hadoop Over the years, big data has become an exciting source for the analysis industry. For the purpose of this blog series, I will loose define this term to

MySql installation-free version l configuration method, mysql installation-free version l I had a hard time getting started with mysql for the first time. The installation was always unsuccessful and the service could not be started. Later, I

Entity misspelled names, lessons learned, and lessons learned from entity misspelled There was a problem in this project, but it was not a big problem...   In V3.0, we used Hibernate to map objects to databases. At that time, someone misspelled an

SQL statement used to query and delete duplicate data in a data table 1. query duplicate data in the table. Select * from peopleWhere peopleId in (select peopleId from people group by peopleId having count (peopleId)> 1)2. Delete

SQL table connection basic syntax and SQL connection basic syntax SQL connections can be divided into internal connections, external connections, and cross connections. 1. Inner join: the inner join query operation lists the data rows that match

Understanding the MySQL architecture of MySQL and the mysql ArchitectureCollationRecently, I have been busy with projects, working overtime, and launching projects, so I have no time to study. This is not the case. Just a few days ago, I took some

Learning notes for five types of Redis objects and five learning notes for redis When using Redis, we directly access String, List, Hash, and Set objects ), sortedSet. Basic commands include String (get set) List (lpush rpush lpop rpop lrange) Hash (

String is split into multiple rows of data (oracle function), multiple rows of oracle Address-http://blog.csdn.net/qq525099302/article/details/47146537 -- Create a split type (used in the function) create or replace type strsplit_type as table of

MySQL database operation commands and mysql commands Note: MySQL databases are case-insensitive. 1. Create a database:Create database Thinkgamer; 2. delete a database:Drop database Thinkgamer; 3. Select a database:Use Thinkgamer; 4. Create a data

SQL Server I/O device Error !!!, Sqlserver In the file 'd: \ data \ BooksDB. during the read operation at the offset of 0x0000011d10400 in mdf, the operating system has returned error 1117 to SQL Server (unable to run this request due to an I/O