Database Administrator

Oracle Database Architecture Analysis Shows the Oracle database architecture, We can see that the Oracle database server is roughly divided into two main parts: 1. Oracle instance (upper part of the database instance) 2. database (lower part of the

Rebuild SCOTT users and SCOTT stories Oracle was first learned from the dept and emp tables under scott, and is still used to testing under scott. Sometimes to facilitate testing, scott users need to be rebuilt to provide a completely new test

ORA-03137: TTC protocol internal error: [12333] [1] problem Background: The Oracle database version is 11.2.0.1, and the operating system is CentOS release 5.9. The detailed error message is as follows: Dump

Oracle 11g, oracle11g General requirements for software environments RHEL 5. x System and RHEL 6. x System Graphical desktop environment + development tools + Chinese Java support -- When installing in RHEL 6. x, ksh needs to use the 5. x software

Rac _ production database log group corruption handling, rac logs Original Works are from the "Deep Blue blog" blog. Be sure to indicate the source when reprinting. Otherwise, you have the right to pursue legal liability for copyright. Deep Blue

MySQL Study-MySQL architecture in-depth analysis, mysql-mysqlMySQL Study-in-depth analysis of MySQL Architecture MySQL Architecture   It consists of connection pool components, Management Service and logging tool components, SQL interface components,

Differences between sedna xquery in windows and Linux, sedna xquery The source uses the example of yesterday to load book. xml into the collection named novel in the books database. The Call Of WildJack London32.5$2015-7-6Wuthering HeightsEmily

Mongodb introduction, mongodb Brief description: MongoDB is a distributed file storage-based database. Written in C ++. It is designed to provide scalable, high-performance data storage solutions for WEB applications. MongoDB isRelational

Vertica database operations, vertica Database Delete a primary key (the primary key value of the Vertica database is not unique ):SELECT ANALYZE_CONSTRAINTS ('fb _ s. c_log ');Find the key name, and then:Alter table fb_s.c_log drop constraint

SQLite Quick Start Guide 1. Introduction SQLite is an open-source embedded Relational Database Engine for SQL database with self-contained, zero configuration, and transaction support. It is highly portable, easy to use, compact, efficient, and

Mongodb distributed cluster (3. sharding), mongodb ClusterOverview The above two blogs are about the mongodb cluster configuration and do not involve the distributed architecture. This blog is about the distributed architecture of mongodb, which

Mongodb distributed cluster (1. Master-slave replication), mongodb master-slaveUnderstanding of distributed Clusters There are many explanations on the concept of distributed clusters. I prefer "distributed clusters" as two concepts, that is,

MySQL technology insider-InnoDB Storage engine-Reading Notes (2), mysql-innodbMySQL technology insider-InnoDB Storage engine-Reading Notes (2) Mysql is always indispensable for php development. Series blog link

Mongodb Study Notes 03. mongodb Study NotesMongodb Study Notes 03-query expression Not equal to, greater than, less ! =: Db. stu. find ({name: {$ ne: 'billvsme '}) name is not 'billvsme' >: Db. stu. find ({age: {$ gt: 18}) older than 18 >=: $

Powerdesigner vba creates tables and columns, powerdesignervba Creating powerdesigner tables and columns manually is very troublesome. Therefore, we need to use vba for implementation. We can refer to

Pick Release, Pick Confirm, and pickconfirm of sales orders using APIs DECLARE x_return_status VARCHAR2 (2); x_msg_count NUMBER; x_msg_data VARCHAR2 (2000); returns NUMBER: = 1.0; returns VARCHAR2 (200); x_msg_details VARCHAR2 (3000); x_msg_summary

If mysql has an id, set data to increase by 1. If no id exists, add it. Java month Calculation Comparison, mysql. java INSERT INTO invite_rejectlog_num (player_id,MONTH,count,last_modify_time)VALUES

Cause of SQL Text "** SQL Text Not Available **" in the Oracle ash Report: oracleash Guess: Why "** SQL Text Not Available **" appears in SQL Text in the Oracle ash report The HVR data synchronization software is being tested today. Due to the large

Locate an interesting error in selecting the Execution Plan (involving SYS_OP_C2) and execute the plan sys_op_c2. These two days and guangfen's brother read a question, which is interesting and the process is tortuous... Symptom: 1. 11g library,

Question 2: MySQL ---------- Second Highest Salary, salary Write a SQL query to get the second highest salary fromEmployeeTable. +----+--------+| Id | Salary |+----+--------+| 1 | 100 || 2 | 200 || 3 | 300 |+----+--------+ For example,