Database Administrator

Oracle 11g TNS connection error ORA-12532 troubleshooting TNS connection errors are common problems for Oracle users. In practice, due to the complexity of the user terminal environment, various TNS connection problems often plague daily users.

MySQL Performance Optimization-Block Nested-Loop Join (BNL) 1. IntroductionI believe that many developers/DBAs are still not satisfied with the way MySQL processes multi-Table associations or the performance when using MySQL. Join queries submitted

OGG-03510 troubleshooting OGG migration, the target end has been upgraded to 12C, so with the 12 version of OGG, the parameter is still using the previous 11g, but when starting the application process prompts OGG-03510 error, as follows: The source

GoldenGate Security Configuration When implementing GoldenGate, security is often ignored. However, as a complete GoldenGate system, basic security settings are still necessary, such as password encryption. GoldenGate has the following five Security

Mysql Data File Deletion, operating system level recovery file, mysql level Under what backup conditions is the Data File deleted and restored?Restrictions 1. Do not use data blocks to be restored2. The file system is not damaged. Use tool

Mysql optimization and mysql Performance Optimization 1. view the mysql server configuration information show variables. You can also use show variables like 'key % '. 2. view the status values of the mysql server running show status, which is the

The path to oracle Learning (6) two practical examples, the path to oracle1. Simple data insertion example -- Created on 2015/6/15 by LYH declare v_fnumber varchar2 (10): = 'qw'; v_fname varchar2 (10): = 'lyh'; v_fage int: = 10; v_fsalary int: = 101

Partition Table (2): Partition Table alter table scales add partition (partition p2 values less than (2015)); alter table log drop partition p0; show variables like '%partition%'; alter table user reorganize partition p0,p1,p2 into (partition p3

Memcached client summary, memcached Summary This article will briefly introduce the features of memcached from the perspective of memcached usage, from the client, protocol, and server. Memcached is a high-performance distributed K-V memory storage

Msyql TPS v1: Calculate the msyqltps within the specified time Requirement: Calculate the TPS between-during daily business peaks. Idea: 1. records TPS-related historical values at every morning. obtain TPS-related values at any current time minus

How can we find the 'library cache pin' In the RAC environment to wait for the Blocker of the event )?, Racblocker How to find the 'library cache pin' In the RAC environment and wait for the Blocker of the event) ReferenceHow to Find the Blocker of

Common commands of MongoDB First, install the database. You can use windows or linux, but linux is recommended. I use ubuntu12.04. you can download the database at the following URL, it is usually a 64-bit system. If you use a linux system, you can

Mutual conversion of SCN timestamps and mutual conversion of scnSQL> select * from v $ version where rownum = 1;BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.

SQL language division, SQL language divisionIn terms of functions, the SQL language can be divided into three categories: DDL, DML, and DCL.1. DDL (Data Definition Language)Data Definition Language, used to define and manage the languages of all

MySQL partition, mysql table Partition In mysql, the learn directory structure is as follows: Let's take a look at the definition of sales in the table: show create table sales \G *************************** 1. row

Six Modes of the oracle learning starter series and six of the oracle getting started Series Six of oracle learning starter Series Mode In the previous article, we learned to record the database structure, memory structure, and processes in the

Summary of problems encountered when installing cmake and mysql in linux, cmakemysql First, problems encountered during cmake installation: 1. When using the yum command to install the package, I don't know why it never works. Then I need to prepare

More depressing than ORA-24777: do not allow the use of unportable database links, ora-24777 linksAn error is reported when the synchronization function is on site. The content is as follows: java. SQL. BatchUpdateException:ORA-24777: do not allow

Data cleansing note Original Works are from the blog of "Deep Blue blog". You are welcome to repost them. You must specify the source when you repost them. Otherwise, you have the right to pursue legal liability for copyright. Deep Blue blog: http://

Getting started with SQuirreL SQL Client 2 --- plug-in use, squirrel2 ---Next article: getting started with SQuirreL SQL Client 11. The directory where the plug-ins are stored is under the installation directory, and The./plugins/jar folder contains