Database Administrator

Install Percona Server in rpm package Percona XtraDBIt is an enhanced version of the InnoDB Storage engine and is designed to better use and update the performance of computer hardware systems. It also contains some new features in high-performance

CentOS6.5x64 install 64-bit Oracle 11g in silent mode 1. Download the 64-bit Oracle11g source file and upload it to the Linux server. 2. Package installation check and installation: Install the tool using yum: Yum-y install binutils compat-libstdc ++

How to compile and run PL/SQL code snippets from a Case Study PL/SQL is a process-oriented structured programming statement developed by Oracle for database business logic requirements. In the Oracle kernel, there are two important components:

Oracle Linux 5.5 (64bit) Installation of Oracle 11g R2 RAC graphic tutorial 1. Preparations before installation:Operating System: Oracle Linux 5.5 64bitCluster software: GI 11.2.0.1Database: database rdbms 11.2.0.12. Resource preparation:Oracleasm-2.

Some basic knowledge about databases (1) ------ database engine, ------ Database Engine MySQL database provides 13 different storage engines to handle different data processing. Most people who have used MySQL should know the two storage engines

Oracle Performance Analysis 5: Index Structure and scan mode of data access methods, oracle Index The previous article describes full scan. This article describes the index structure and scan methods, and describes each scan method later.When Oracle

Oracle10g (32, 64-bit) is successfully installed in win7 (32, 64-bit ). Win7-32-bit installation 32-bit oracle10g, win7-64 32-bit installation, 64-bit oracle10g can refer to this case. Reference:

Java oci connection oracle throwing java. lang. UnsatisfiedLinkError: ocijdbc11..., ocijdbc11 First, the oracle client is successfully installed. Use the sqlplus tool to connect to the local service name configured by TNSNAMES. ORA, for

Using oracle official documentation (11 GB) -- Exploring Concept and oracleconcept Example of using oracle official documentation (11 GB) The following is the official oracle document interface. To learn oracle Well, reading the official documents

Run the DBCA command on a set of DB servers and report the following error: [Oracle @ game_db ~] $ Dbca Exception in thread "main" [Oracle @ game_db ~] $ [Oracle @ game_db ~] $ ExportDISPLAY = 1921.68.3.189: 0.0 [Oracle @ game_db ~] $ Dbca Exception

New Features of Oracle DB 12c: raw device bare devices are no longer supported, oracle12c New Feature of Oracle DB 12c: raw device is no longer supported. Reference:Announcement of De-Support of using RAW devices in Oracle Database Version 12.1 (Doc

SQL Study Notes (19) ----------- about MySQL database optimization and mysql database Optimization A mature database architecture is not designed with high availability, high scaling, and other features at the beginning. It is gradually improved

Pub/Sub publish and subscribe, pubsub publish and subscribeRelated commandsPSUBSCRIBEPUBLISHPUBSUBPUNSUBSCRIBESUBSCRIBEUNSUBSCRIBEPub/SubSUBSCRIBE, UNSUBSCRIBE and PUBLISH implement the Publish/Subscribe messaging paradigm where (citing Protocol)

SQL Study Notes (17) ---------- MySQL Command, mysql import SQL FILE command Mysql Common commands   Mysql installation directoryDatabase directory/Var/lib/mysql/Configuration File/Usr/share/mysql (mysql. server command and configuration

SQLite tutorial (4): built-in functions, sqlite tutorial built-in functions 1. Aggregate functions: The aggregate functions supported by SQLite are also supported in many other relational databases. Therefore, here we will just give a brief

To perform time operations in SQL, You need to master four time functions: dateadd, datediff, datepart, and datename.Dateadd is to add or subtract a time on a specified date.For example, if you add a 3-day select dateadd (day, 3, '2017-05-06 ') on

MongoDB data model and index learning summary, mongodb ModelMongoDB data model and index learning Summary 1. MongoDB Data Model: MongoDB data storage structure:MongoDB uses BSON (binary json, binary encoding) data format for document (large files

JDBC database programming and jdbc programming books **************************************** ****************************************************** Original works, from the "Xiaofeng residual month xj" blog, welcome to reprint, reprint please be

In the morning, A friend sent an email to a SSIS connection to Oracle. The specific error message is as follows:     Cause:   1. Because BIDS are 32-bit applications, even on 64-bit machines, they cannot use 64-bit applications. Therefore,

Manage Azure SQL database authorization Security When planning the deployment of Microsoft Azure SQL Database, you must consider all the security measures that need to be implemented in the deep defense policy. In the previous article, we have