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

Case study of incomplete records of RAC split-brain logs due to not configured diagwait1. Fault A rac with the CRS version 10.2.0.4. After the server goes DOWN at the second node, the server goes DOWN at the first node.2. CRS log analysis 2.1 2-node

Mysql char varchar blob text performance details, varcharblob Char Fixed Length, up to 255 bytes. If the storage space is not full, a space will be filled on the right side of the data. Varchar The maximum length is 65536 bytes. When the varchar

Atitit. Get connection hibernate4, atitithibernate4 Atitit. Get connection hibernate4   1. SessionFactoryUtils method (recommended) 1 2. ConnectionProvider method () 1 3. Ga self-implementation method (not recommended) read hb configuration file 1 4.

OLAP learning and instance building, and OLAP learning instance Building OLAP learning and instance Building Theoretical preparation: I. OLAP 1. What is OLAP? OLAP (On-LineAnalysis Processing) is a fast analysis technology that shares

Error reported when centos65 was installed on pg935: jade: Command not found, centos65pg935When centos65 is installed on pg935, the following error occurs: jade: Command not found.1[Root @ pghost1 postgresql-9.3.5] #. /configure -- prefix

When kettle logs on to the loading job, the following error occurs: Can't find Job 1, kettlejobCause of error: Job 1 is a temporary new job. I did not save the database or local file, so the file cannot be found during loading.Solution: directory C:

[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

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

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.

Collation of numbers and Chinese characters in oracle and introduction to REGEXP_SUBSTR, oracleregexpsubstr Requirement: There is a column NAME, varchar2 type, the content is as follows The preceding statements are sorted by order by name, but

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

ORACLE Installation and oracle Installation Statement:Original Works are from the blog of "Deep Blue blog". You are welcome to repost them. Please indicate the source when you repost them. Otherwise, the copyright will be held legally

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,

Analysis of pub/sub function in Redis, Xinxing redis The pub/sub function is the publish/subscribe function, that is, the publish and subscribe function. In an event-based system, pub/sub is a widely used communication model. It uses events as the

ORACLE 10G Official documentation Demonstration: Search for manual database creation statements, oracle database creation Original Works are from the blog of "Deep Blue blog". You are welcome to reprint them. Please note the following source when

Character Set OverviewA brief overview of the oracle031 Character Set: A character set corresponds to the encoding. 1. Functions and meanings of character setsCharacter encodingUsageDatabase Character Set(1) used to store CHAR, VARCHAR2, CLOB, LONG,

[Translated from mos] How to obtain the growth information of datafile backup, mosdatafile How to obtain the growth information of datafile backup? Source:HOWTO get information about the growth of the datafile backup (Document ID

Know the file # Of datafile and find out which backuppiece the datafile belongs, F:\oracle\product\10.2.0\db_1\BIN>sqlplus / as sysdbaSQL*Plus: Release 10.2.0.4.0 - Production on Mon Feb 23 09:41:48 2015Copyright (c) 1982, 2007, Oracle. All Rights

Know the archived log sequence # And find out which backuppiece the archived log belongs ., F:\oracle\product\10.2.0\db_1\BIN>sqlplus / as sysdbaSQL*Plus: Release 10.2.0.4.0 - Production on Mon Feb 23 08:41:41 2015Copyright (c) 1982, 2007, Oracle.