Database Administrator

New Features of Oracle 11g-HM (Hang Manager) In this article, we will introduce the new features of Oracle 11g-hang Manager. We need to note that HM only exists in the RAC database. When we diagnose database problems, we often encounter

Install DB2 V10 and Data Studio V3 in a Linux (Ubuntu) Environment This document describes how to install a DB2 database in Linux. The Linux version used is Ubuntu 12.04. The DB2 version is DB2 Express-C V10.1 Linux 32-bit, that is, the Community

Upgrade _ Oracle graphical upgrade (dbca database creation after upgrade)-upgrade 10.2.0.1.0 to 10.2.0.5.0 and dbca10.2.0.5.0 **************************************** ******************************** ************** Original Works are from the blog

Clob is saved as a local xml file. After modification, it is uploaded. clobxml I wrote a small program with my friends over the past two days. The functions are as follows: First, save the database clob as a local xml file, modify the xml file, and

Before Oracle 11g, the physical Standby database (physical Standby) cannot be opened when applying redo, but can only be mounted. Starting from 11g, when applying redo, the physical standby database can be in read-only mode, which is called Active

Use kettle to batch download files and kettle to batch download files Use kettle to batch download files In the latest projects, you need to download files in batches and import the results into the data. kettle is indeed competent through some

Requirements for Oracle 11.31 database installation on HP-UX IA64 11.2 systems: I. Swap memory requirements Between 4 GB and 8 GB then 2 times RAM.Between 8 GB and 32 Gbit/s then 1.5 times RAM.More than 32 GB then 32 gb ram. Ii. JDK

Vertica "ERROR: Too many ROS containers exist", verticacontainers Original article: Vertica "ERROR: Too many ROS containers exist" Recently I encountered a problem when using Vertica. After running Vertica for a while, it always encountered the

Mybatis type conversion when using generator to automatically generate code, mybatisgenerator Use the generator of mybatis to automatically generate code, but in the oracle database, number (6, 2) is always automatically converted to BigDecimal, and

SQL Server trigger and SQL Server trigger Brief Introduction: A trigger is a special stored procedure, which is automatically executed only when a specific event occurs. Stored Procedures and triggers are a collection of SQL statements and flow

View and modify the maximum number of connections in ORACLE, and view the maximum number in oracleZookeeper Step 1: On the cmd command line, enter sqlplus Step 2: Enter the user name and password as prompted 1. view the processes and sessions

HBase Write Request analysis, hbase Write Request As a distributed NoSQL database system, HBase not only supports wide lists, but also provides high performance for random read/write. HBase can maintain transaction consistency while performing

Understanding about ora-01000: a point beyond the maximum number of opened cursorsORA-01000: maximum open cursors exceededERROR at line 1:ORA-01000: maximum open cursors exceeded Problem Analysis:1. When the cursor is open, an error occurs and no

Install and configure an openstack Virtual Machine. When you need to modify the ip address, you can modify the ip address in the database. Since many tables are created when the openstack environment is configured, the local ip address is configured.

The ultimate goal of data replication is to synchronize the data of one server with the data of another server, which can achieve data redundancy or load balancing of services. A master server can connect multiple slave servers, and the slave server

Use the earlier version of Xtrabackup to restore the full backup file created by the later version of Xtrabackup.Recently, we want to restore the data of multiple MySQL servers backed up by xtrabackup to another MySQL Server and start multiple

SQLite tutorial (II): C/C ++ interface introduction, sqlite tutorial I. Overview: Five of the C/C ++ interfaces provided by SQLite are core interfaces. In this blog, we will mainly introduce their usage and the core SQLite objects they involve, such

Based on data analysis, whether automatic vehicles consume more oil than manual vehicles, and automatic data analysisOverview This is a multivariate regression equation used to reveal the relationship between vehicle fuel consumption and vehicle

Oracle 12c agent install for windows, oracle12c   There are two methods to deploy the agent in Oracle EM12c: one is to install the agent "push" directly to the managed end through the EM12c console through ssh, this method is relatively simple on

Expanded group by for report development and expanded group by for reports In practical use, for example, in a data warehouse, multi-dimensional analysis of data is often required, not only the results of standard grouping (equivalent Group by), you