Database Administrator

Install Greenplum source code in CentOS 7 Cluster composition: One host and one slave node. System Environment: Operating System: CentOS 7, 64-bit, 7.4.1708 (in/etc/RedHat-release) CPU: AMD Fx-8300 8-core Memory: 8 GB Hard Disk: 120 GB GNOME: 3.22.2

Oracle Database full recovery and Incomplete recovery, and perform user management for multiple generations recovery, oracle user management Comparison between full recovery and Incomplete recovery: 1. Full recovery: restores the database to the

Deploy IBM _ DB2 products on dozens, hundreds, or thousands of clients and servers based on UNIX and Linux platforms, including IBM DB2 Universal Database (DB2 UDB) and DB2 Connect, this seems like a daunting task. This article describes how to

Football and oracle series (5): The directX library missing in the voda14 game is similar to the oracle rpm package, fifa 14rpm **************************************** ******************************** ************** Original Works are from the blog

WAS cluster series (3): Build a cluster: Step 1: prepare files, was Cluster Note: "pointing track" is "Click order", which is the effect after clicking Environment Project point Metrics WAS version 7.0 Operating

I found a on the internet, and I think this book is quite good. It is suitable for programmers who are new to Oracle to read it. This book starts with some of the most basic knowledge and works with easy-to-understand examples to help you get

Cost Calculation Method in execution plan, execution plan cost Concept: Blevel: Binary Height = index height-1 Clustering_factor: Cluster factor, number of blocks in the table to be scanned after index scan, clustering_factor Index scan calculation

[Introduction to Data Mining]-Introduction to Data MiningIntroduction to Data Mining Reading NotesPrerequisites for data mining: rapid advances in data collection and storage technologies. Data Mining is a technology that combines traditional data

The AWR import failed today and damaged the awr of the database. It can only be rebuilt. After reconstruction, an error is reported in awr. SYS @ hcndb> beginDbms_workload_repository.modify_snapshot_settings (3 interval => 30,4 retention => 14*24*605

Last Review: This article mainly describes the Neo4j Spatial project and space data (vector) storage. This article describes how to integrate Neo4j Spatial with Neo4j Server and GeoServer. Noted: it is feasible to integrate with Geoserver, but

Recently, Oracle released the latest version of MySQL Workbench 6.0, including the Community version and the enterprise version, to improve the development and management of MySQL databases. MySQL Workbench is a unified visualization tool designed

"Unable to upgrade database... because SQL Server of this version does not support non-release version of this database (539)" solution, sql539 When you use SQL2012 to append a database, the following error is reported: "You cannot upgrade the

The alarm logs sent by netizens are originally about a deadlock. Another problem is that the logs written from the redo log buffer to the redo log file cannot be allocated with new logs, private strand flush not complete wait event. This is a redo

Five tips for Instagram to improve PostgreSQL performance, postgresql Performance Optimization As Instagram grows, Postgres continues to serve as a solid foundation for Instagram and stores a vast majority of user data. Less than a year ago, we also

PostgreSQL tutorial (13): database management details, postgresql details I. Overview: A database can be considered as a name set of an SQL object (database object). Generally, each database object (table, function, etc.) belongs to only one

MySQL auto_increment gap problem, mysqlautoincrement Link to this book (http://www.jianshu.com/p/cca59b515e20) We often use the auto_increment field in MySQL, especially the innodb engine. I also often use it. I only know that mysql can ensure

Addnode. sh failed, log file error PRKC-1025 & java. lang. OutOfMemoryError: Java heap space,Environment: Linux 5.5 + RAC 11203  Problem description: The command to add a cluster member is as follows: $ GRID_HOME/oui/bin/addNode. sh-silent

SQL statement + select top usage of "Fetch 10th to 20th records from a data table", 10th SQL statements 1. First, select top usage: For more information, see the differences between select top n * from and select * from. Select * from table --

Install Oracle12cR1 on Oracle Linux 6.5 in VirtualBox, oraclevirtualbox My Oralce Linux 6.5 is running on VirtualBox. Basic settings is 4G memory, 50G hard-disk, auto partition when install OL6.5.   ** Following series of operations need root

In general, it is impossible to avoid any problems during the migration of DB2 database applications. This article will introduce some problems that may occur during the migration of DB2 database applications. BKJIA has previously introduced how to