Database Administrator

How to diagnose cursor pin s wait on x Series 1, cursorpinFirst, clarify one thing: cursor pin s wait on x is the symptom (result), not the root cause.Mutex related wait event "cursor: pin S wait on X"General cause:Frequent and hard parsing (High

Etl design issues Http://blog.csdn.net/lili72 Background 1: With the increase of data access and processing, more and more production scripts are generated. Due to the lack of standardized management by the early-stage developers, the scripts are

Python2.7 automatically creates virtual machines and python2.7 virtual machines Python2.7 automatically creates one or more virtual machines (the IP address is the virtual machine name) [1]. [Code][Python] Code jump to [1]? 12345678910111213

[Database] supports easy-to-understand connection between left and right databases. I had been confused about the external connections in the database, but I didn't have a thorough understanding of it. Today I finally created a table and compared

How to delete a large number of small trace files in oracle, oracletrace When files are deleted in batches on the AIX platform, the following error occurs: Ksh:/usr/bin/rm: 0403-027 The parameter list is too long Cause: This is mainly because the

Modify the default maximum number of connections in Oracle. The maximum number of connections in oracle is 100 by default, and the default value is 150 when creating a database, It is mainly subject to the processes system parameter (it should

Commonly used sql2 and sqlserversql2 in SQLServer -- Create table [dbo]. [BI_Dim_Date] (-- YYMMDD [DateF] [nvarchar] (20) NULL, -- French Date Format [DateKey] [nvarchar] (10) NULL, [Dim_Year] [int] NULL, [Dim_Month] [int] NULL, [Dim_Day] [int] NULL,

The paging code becomes invalid due to a strange issue. Previously, I encountered a page failure problem on the interface, which had plagued me for several days. The problem was solved when the backend was located as a sorting failure

Use sqoop to import mysql Data to hadoop and sqoophadoop The installation and configuration of hadoop will not be discussed here.Sqoop installation is also very simple. After sqoop is installed, you can test whether it can be connected to mysql

Very Large Memory and HugePages Series 2-configure Large pages, largehugepages How to configure hugepages on linux Glossary: Memlock-max locked-in-memory address space (KB) 1. Configuration/Etc/security/limits. conf memlock Parameter Memlock is

[Chapter 2. configuration (Setup )],2.1. Engine Files Each node requires some attributes to connect the node to a database and register it with a parent node. These attributes are defined in a file named xxxx. properties, which is placed in the

How to synchronize data from a table by using ricds?1. Create a channel insert into sym_channel(channel_id, processing_order, max_batch_size, enabled, description)values('test', 1, 100000, 1, 'channel test for table test') A channel is a set of one

[Practice] mariadb audit and mariadb Audit --- Create the directory mkdir/usr/local/mysql/mysql_logs/auditlogchown mysql: mysql/usr/local/mysql/mysql_logs/auditlog/-- 2. INSTALL the audit plug-in show global variables like 'plugin _ dir'; INSTALL

PostgreSQL database backup and recovery technology comparison, postgresql database There are three completely different methods to back up PostgreSQL data: · SQL dump · File system-level backup · Online backup I,SQL dump The pg_dump application tool

Solve the mysql database garbled problem during SSH development, sshmysql (1) ensure that The encoding method used for database creation is the same as that used for database connection! (2) configure the filter in the web. xml file

The length of group_concat in MYSQL is limited! The default value is 1024.In mysql, there is a function called "group_concat", which may not be able to detect problems during normal use. When processing big data, the content will be intercepted,In

PostgreSQL quick creation of empty table TIPS, postgresql empty table tipsMySQL has an excellent Syntax "create table... like", which allows you to quickly copy a table and create its copy. PostgreSQL also has similar syntax and is more flexible,

Use of Mongodb underlying java driver framework tools and mongodb toolsTo use MongoDB, you must properly design the document structure to meet specific requirements. For example, if a document is randomly selected and skip is used to skip a random

Note the following when using oracle 11g ASM: 11 gasm 1. Configure at least two data groups (replica groups are used to store data files; fra replica roup is used as the archiving and backup of the flash back area). I/O performance problems are

Oracle inserts timestamp data, and oracle inserts timestamp Table Structure: create table TEST( ID INTEGER, BIRTHDAY TIMESTAMP);Insert a date to a TIMESTAMP field using JDBC Import java. SQL. connection; import java. SQL. driverManager;