Database Administrator

Detailed steps for creating the ipvs-XL Cluster Recently, the company's business needs to use ipvs-XL clusters. There is not much network information about this part of knowledge. After a period of query and various detours, the installation was

Oracle Enterprise Manager Cloud Control 12c R4 installation ConfigurationPrepare Software Em12.1.0.4_linux64_V45344-01.zip Em12.1.0.4_linux64_V45345-01.zip Em12.1.0.4_linux64_V45346-01.zip  Install the Operating System (OEL6.5) After loading OS and

Oracle 11g R2 rac rman backup script example 1. Switch RAC to archive Mode 1. Modify the archive mode of the database. Generally, archive is configured and the flash back area is used when RAC is installed. you can skip the steps below if you have

MonjaDB is a MongoDB GUI client tool that provides intuitive MongoDB data management functions and supports Windows, Mac, and Linux. MonjaDB is an Eclipse plug-in that must be installed first. Main features: Easy to use WYSIWYG edit

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

[Translated from mos] Does oracle Support Symbolic Links Under rdbms home ?, Does oracle Support Symbolic Links Under rdbms home? Reference Original:Does Oracle support Symbolic Links in the RDBMS home? (Docid 813116.1) Applicable:Oracle

Database index advantages and disadvantages Why create an index? This is because creating an index can greatly improve the system performance.First, you can create a unique index to ensure the uniqueness of each row of data in the database

Teach you how to use Pandas pivot tables to process data (with learning materials) and pandas learning materials Source: bole online-PyPer Total2203 words,Read5Minutes.This article mainly explains pandas's pivot_table function and teaches you how

Seven transactions of Spring and seven transactions of springSpring transactions include seven levels: REQUIREDREQUIRED is the default transaction level of Spring. If a transaction exists, the current transaction is supported. If no transaction

Access to Create a Table SQL statement Create Table to set AUTOINCREMENT for Automatically increasing columns, SQL statement createtable Access Table creation SQL statement Create Table setting AUTOINCREMENT for Automatically increasing Columns SQL

I. Basic Introduction SQLite is a self-contained, serverless, zero-configuration, and transactional relational database engine. Because it is very small, it can also be built into your application as an embedded database. SQLite is used in Solaris 1

50 SQL Query Techniques, query statement examples, 50 SQL statements Student (S #, Sname, Sage, Ssex) Student tableCourse (C #, Cname, T #) CurriculumSC (S #, C #, score) Orders tableTeacher (T #, Tname) Instructor table Problem:1. query the student

Address: http://www.itpub.net/thread-1801066-1-1.html I recently saw several posts in the forum discussing buffer busy waits. Here I will talk about my views.Let's first talk about how this wait came about.The origin of buffer busy waits.When n

Why percona-xtrabackup We have discussed MySQL Cold Standby, Hot Standby, mysqldump, and hot copy to ensure data consistency. Because mysql cold backup, mysqldump, and mysql hot copy cannot achieve Incremental backup, Incremental backup is used in a

Alertsid. log error message: Fri Sep 27 15:18:39 2013Started redo scanFri Sep 27 15:18:39 2013Errors in file/oracle/admin/lixora/udump/lixora_ora_23439.trc:ORA-00314: log 2 of thread 1, expected sequence #335 doesn't match 331ORA-00312: online log 2

The reason is that the client character set is not set during the export, or the settings are incorrect. It's okay to change it to DB.Check the character set (select userenv ('language ') from dual ;)The exported character set is SIMPLIFIED

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

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

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

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