Database Administrator

Oracle 11g Data Pump details Oracle Database 10 Gb introduces the latest data pump technology, the role of Data Pump Export Import (EXPDP and IMPDP) 1. Logical backup and logical recovery 2. move objects between database users 3. move objects

Sort out common MongoDB operation commands Mongodb operation commands (note that all commands starting with "db." Must be used to access the specified database before the operation)Connect to the database:/Usr/local/mongodb-3.0.4/bin/mongo 192.168.6.

Oracle 11g elastic uard automatic start service Oracle 11g elastic uard automatic start service Only for better performanceJust to do better Script name: oracledg #! /Bin/bash# Chkconfig: 2345 98 01# Description: Oracle database migration uard

Oracle dblink causes too many remote database sessions The database of the on-site reporting network company could not be connected. I checked the database processes = 1500 and session = 2200 first. I think it is very big. Few people use this

Sedna does not support xml schema and sedna XMLSCHEMA. Book. xsd:   Book. xml: The Call Of Wild

HBase learning Summary (3): HBase data model and working mechanism, hbase Model I. HBase Data Model The logical entities in HBase mode include:(1)Table): HBase uses tables to organize data. The table name is a String consisting of characters that

Golang Custom Data Type query and insertion of point data in postgresql, golangpostgresqlGolang Custom Data Type query and insertion of point data in postgresql The Code is as follows: Package mainimport ("bytes" "database/SQL" "database/SQL/driver"

Sqldatabase optimization: cutting, database connection pool-[Examination System], sqldatabase connection As mentioned in the previous article, developers need to pay attention to cpu and memory. SQL logs cannot be ignored. SQL logs show the error

Install and use MySQLdb and MySQLdb I. Installation Install the compiled version (this method is simple and convenient ): Http://www.codegood.com/downloads Download the package from your system and double-click it to install it. Import MySQLdb to

Redis client protocol implementation, redisprotocol On the official website, you can visit http://redis.io/clientsto find some redis clients that have already been proven. For more information, see. In fact, the previous article http://blog.csdn.net/

Oracle sets the User Password usage time, oracle sets the User Password How do I set a password to force a regular password change?Assume that the password must be modified after 10 days, and the grace period is 2 days: Call the computer time

Add, delete, modify, query, and modify objects associated with hibernate ------ add, hibernate ------This article serves as the study notes for the hibernate course for Ma soldiers at Beijing shangxue.com.In this section, we will look at the

Hive Join and hivejoin Https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Joins LanguageManualJoins Join Syntax Hive supports the following table join syntax structure: Join_table: Table_reference JOIN table_factor [join_condition] |

MySQL Optimization-query and mysql Optimization Reprinted please indicate the source: http://blog.csdn.net/l1028386804/article/details/46580589 Basic select syntax in MySQL Select attribute list from Table Name and View list [where condition

MySQL isolation level, mysql isolation 1. read uncommitted, read uncommitted. Transaction A can read the data modified but not committed by transaction B. Dirty read 2. read committed, read committed. Transaction A can only read the data committed

The new 11g feature ENABLE_DDL_LOGGING initialization parameter and the new oracle11g feature ENABLE_DDL_LOGGING starts from 11g, but there are bugs in 11.2.0.2 and 11.1.0.7. This bug is described: Bug 12938609-ENABLE_DDL_LOGGING does not log RENAME

SQL Structured Query Language and basic Mysql operations, Structured Query Language SQL Structured SQL Query Language Data operation (Management) language (DML, DataManipulationLanguage) (DQL + DML)DQL query: obtain data.DML management: add, delete,

. Net connection to oracle Database --- Shinepans, oracle --- shinepansFAQ: 1. the reference solution is missing. Add reference: using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using

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.

Data Table field attribute query, data table field attribute --- Query all database table namesSelect id, name from sysobjects where xtype = 'U' order by name--- Query all the field attributes of a tableSelect * from syscolumns where id = object_id