Database Administrator

15 useful MySQL/MariaDB performance tuning and Optimization Techniques MySQL is a powerful open-source Relational Database Management System (RDBMS ). It was released in 1995 (20 years ago ). It uses Structured Query Language (SQL), which may be the

I. IntroductionI have been using Linux for a long time. I have never studied hard tasks and system learning. Recently, I have to use MySQL in Linux for my work. I thought that I had experience using SQL Server in Windows and thought it would be easy

Configure Oracle Gateway 12 to connect to SQL Server 2014 In recent work, we need to connect to SQL Server 2014 based on Oracle. We can configure Gateway to implement this function. This Gateway is actually implemented through dblink. That is, the

Install MongoDB and PHP MongoDB Driver in Ubuntu 14.04 Description MongoDB is a very famous NOSQL database. The following is the installation of MongoDB in Ubuntu 14.04, as well as the configuration for PHP (driver Installation, etc.). This method

Rman backup method-Incremental backup and rman backup method incremental Usage type: the system load is concentrated in a certain period of time, such as 8 hours during the day, and is usually idle at night. Therefore, data can be backed up at night.

Chapter 3 Protecting the Data (1): Understanding permissions, chapterprotectingSource: Workshop Without the consent of the author, no one shall be published in the form of "original" or used for commercial purposes. I am not responsible for any

Chapter 2 User Authentication, Authorization, and Security (4): restrict the management permissions of the SA account, authenticationSource: Workshop Without the consent of the author, no one shall be published in the form of "original" or used for

Deploy Oracle 10.2.0.5 on Red Hat Enterprise Linux 6.4, deploy10.2.0.5 I. installation and configuration of Linux 1. Select Desktop when installing the system. 2. Set the eth0 Nic to a static IP address, add the subnet mask, gateway, and DNS, and

[Translated from mos] how to change the password of Database User sysman (this user is the schema of DB Control Repository) mossysman Change the password of the Database User sysman (this user is the schema of DB Control Repository) Reference

PL/SQL single-row functions and group functions A function is a program with zero or multiple parameters and a return value. Oracle has a series of built-in functions in SQL, which can be called SQL or PL/SQL statements. functions are mainly divided

This article builds the mirror demonstration for the non-domain environment, for the domain environment establishment, can refer to above: http://blog.csdn.net/dba_huangzj/article/details/28904503Source:

Oracle rman backup and RestorationRMAN supports Incremental Backup: databases, tablespaces, and data files.Only used blocks can be backed up as backup setIng between tablespaces and data files: dba_data_files/v $ datafile_headerIn noarchivelog mode,

Comparison table of operations between MongoDB and MySQL and comparison table of mongodb Comparison tables and differences between MongoDB and MySQL MySQL and MongoDB are both open-source common databases, but MySQL is a traditional relational

SQL Server Performance Tuning methodology and common tools, SQL Server Tuning In earlier articles, we mentioned the DETECT methodology in Performance Tuning. Here we will briefly review the DETECT methodology. Discover the problem: found the

MySQL programming on linux (4): Data Import and Export and backup, mysql Import and Export[Copyright statement: respect originality. Reprinted and reprinted. Retained for Source: blog.csdn.net/shallnet. this document only serves for learning and

Client Character Set, oracle client Character SetThis part is supported by oracle globalization. For more information, see the documentation.First, let's talk about the database character set. When we use dbca to create a database, we will let you

SQL server, db2, oracle Stored Procedure dynamic SQL statement example, db2oracle Oracle Create or replace procedure a_testAS t_ SQL VARCHAR2 (2000); t_a VARCHAR2 (20); t_ B VARCHAR2 (20); t_c VARCHAR2 (20); t_d VARCHAR2 (20); BEGIN t_c: = 'F'; t_d:

ERROR 2049 (HY000): Connection using old (pre-4.1.1), hy000pre-4.1.1 The MySQL server is installed in the test environment and cannot be successfully logged in upon login. It prompts that the old authentication protocol is rejected. The specific

ORA-01003: no statement parsed, ora-01003parsed Environment: delphi 5, BDE, oracle10 Delphi with tStoreProc call stored procedures appear ORA-01003: no statement parsed. Solution: the stored procedure name assigned by tStoreProc. StoredProcName

Test Data Management: creative solutions and Data Management Solutions Mario Matthee is a tester, Consultant, certified Master Scrum and very unqualified mountain motorcycle drivers (learning ). He is keen to introduce young IT experts