Database Administrator

MySQL installation, configuration, usage and JDBC Link Download: URL: http://dev.mysql.com/downloads/mysql/5.5.html#downloads Select No thanks, juststart my download. Mysql-5.5.36-win32.msi 33.7 M Mysql-5.5.36-winx64.msi 35.3 M   Navicat

Undo tablespace Overview Brief summary of UNDO:1. the segments in the general tablespace are manually created. The undo tablespace is similar to the general tablespace, but the undo tablespace and the undo tablespace are automatically generated.

Install mysql in CentOs Rpm (hands-on instruction) and centosrpm First, upload the mysql-rpm package flashFXP required for rpm installation to/usr/local/ : Link: http://pan.baidu.com/s/1i3rb2Gt password: 5pk8 1: # file/sbin/init // check that

Modify instance SID in Oracle and instance sid in oracleModify the ORACLE Instance nameSystem Environment: CentOS 6.5ORACLE version: 10.21. Check the original database instance name$ Echo $ ORACLE_SIDOrcl$ Sqlplus/as sysdba> Select instance from v $

[Ubuntu14.04] Build the PHP5 + Apache2 + Oracle environment and ubuntu14.04php5 RT A recently developed project where the database uses oracle. Oracle itself supports Red Hat, which is not good for ubuntu. If ubuntu needs to install oracle, the

[NoSQL] install MongDb and nosqlmongdb in Linux 1. Go to the official website. 2. decompress the MongoDb package and rename it to mongodb: tar -zxvf mongodb-linux-x86_64-2.6.8.gzmv mongodb-linux-x86_64-2.6.8.gz mongodb3. Create a folder for storing

12.1 upgrade roadmap and 12.1 upgrade Roadmap Minimum version of the database that can be directly upgraded to Oracle 12c Release 1 (12.1) --- direct upgrade   Source Database Target Database 10.2.0.5 12.1.x 11.1.0.7

Transaction Management in JavaEE-transaction Overview (1), javaee transactions Today, I want to talk about transaction management. Readers may or may not understand it. It is actually very simple (Please bypass it yourself ). I wanted to reference

Oracle 10g modified character set to UTF8 and oracleutf8 After ORACLE is installed, the character set settings are incorrect. Therefore, you must modify the character set as follows: System Environment: CentOS 6.5 ORACLE version: 10.2 1. log on to

MySQL Stored Procedure instance The Mysql stored procedure is actually a function, which can execute multiple SQL statements and create temporary variables.For example, the main functions of the following stored procedure are:(1) create two

Mysql writes Chinese garbled characters, mysql writes Chinese Characters Garbled text is a common problem of programmers. The following describes several common cases. It is common in three aspects: Page, foreground-to-background value transfer, and

Path to mathematics-sas memo (7), path to mathematics-sas memo Show variable name Libname saslib "H: \ sas "; /* Varnum indicates the name of the variable sorted by the observed position. The default value is in alphabetical order */ DataSaslib.

Oracle Database fragmentation management, **************************************** **************************************** 1. tablespace fragments ************************************** **************************************** ** ---- 1. view the

Prepare for the ocp_ SQL topic "DELETE" and prepare for ocp_sqldelete. Original Works are from the blog of "Deep Blue blog". You are welcome to reprint them. Please note the following source when reprinting them. Otherwise, you will be held legally

Stored Procedure output parameters, return values, returned tables, and C # calls, Output variables, return values, and result sets can be defined during stored procedures. The default return value for each stored procedure is 0. Next, a new Stored

[Translated from mos] When OGG adds Supplemental Logging, the error message is Block Corruption and mossupplemental. OGG add Supplemental Logging fails, and Block Corruption is reported)Source:Add Supplemental Logging Fails Due To Block upload

[Translated from mos] how to detect and solve the damage to the datafile OS header (Block Zero -, How to detect and resolve corruption of datafile OS header (Block Zero)-ORA-27047 DBV-107 ORA-1157/ORA-27048 Source:How to Detect and Fix a previous

Summary of methods used by the SQL SERVER database to determine whether an object exists. -- Whether the database existsIf exists (select * from master .. sysdatabases where name = n '')Print 'exists'ElsePrint 'not exists' -- Determines whether the

Vernacular Oracle: Hotspot table optimization summary, vernacular oracle1. Optimize the SQL related to the hotspot table. If the SQL Execution takes too long, it will hold latch for a long time. For statements with a small number of returned results,

In-depth analysis of a complete transaction, in-depth analysis of the complete transactionOracle029 deeply analyzes a complete transaction2. Diagram of the operational process of a transactionUndo segment composition: Segment header and rollback