Database Administrator

Oracle index merge coalesce operation Index rebuild and rebuild online are common problems in the O & M environment. However, in either case, the rebuild of the big data index object is a large-scale operation that consumes resources. Time Window

Oracle manually switches log files and clears log files Oracle switch log file groupLog File groups are used cyclically. When a group of log files is full, the Oracle system automatically switches to the next group of log files. When necessary, the

A ORA-15031 error is prompted when root. sh is executed Recently, an Oracle Grid infrastructure (GI) installation problem was solved. The problem occurred while executing root. sh and the following error was displayed: Disk Group OCR creation failed

RMAN change tracking The change tracking function of RMAN improves the performance of Incremental backup by recording the changed data blocks in each data file in the change tracking file. If change tracking is enabled, RMAN uses a change tracking

The role of temp tablespace and the role of temp tablespace The role of temp tablespace: Temp tablespace is mainly used for sorting operations [such as creating indexes, order by and group by, distinct, union/intersect/minus/, sort-merge, join,

Several useful functions in mysql, useful functions in mysql1. FROM_UNIXTIMEPurpose: display the time stored in INT (11) in MYSQL in the "YYYY-MM-DD" format. Example: select mtime, from_unixtime(mtime) from topics limit 10; 2. CONCAT (str1, str2

[Mysql] Change the root password and create an account with the same permissions as root, mysqlroot You may need to change the root password because it must work with the Mysql database password on the server. You cannot always use Ctrl + H to

File system and database comparison, file system databaseComparison between file systems and databases This article compares common file systems and database technologies from the perspective of Single-host systems. There should be many

Records the SQL statements executed by MySQL, and records the SQL statements executed by MySQL. Comparing Oracle functions to learning Mysql will always discover highlights Using the log mining skill in Oracle, you can find all records that have

Solution for installation of oracle 12c to 69% on windows, 12c69%1. Environment 1.1 software environment and Installation Method Software environment: Win7_64bit + oracle 12c_64bit (12.1.0.2) Installation solution: Only database software is

Scp risk awareness and scp Risk Awareness I would like to express my thanks to elders who have given me some advice.   man scp -l limit Limits the used bandwidth, specified in Kbit/s   [root@rhel63single arch]# scp

To completely uninstall oracle11g, follow these steps:To completely uninstall oracle11g:1. Choose "start"> "Settings"> "Control Panel"> "Administrative Tools"> "services" to stop all Oracle services.2. Start-> Program-> Oracle-OraHome81-> Oracle

Relationship between locks and isolation levels One. net project, occasionally some strange problems, recently made up effort to troubleshoot and found that it is caused by a deadlock, the following is a deadlock situation map tracked using SQL

Why should a riak cluster have at least five nodes and five riak clusters? Link: http://blog.csdn.net/ddjohn/article/details/43523983 First, ensure that you have correctly installed riak. When you use Riak Fast Track to quickly create three nodes

11gR2 and 11gR2Minimum version of the database that can be directly upgraded to Oracle 11g Release 2 (11.2) --- direct upgrade Source Database Target Database 9.2.0.8 or higher 11.2.x 10.1.0.5 or higher 11.2.x

Undo tablespace overview, undo Table OverviewOracle028undo tablespace OverviewBrief summary of UNDO:1. the segments in the general tablespace are manually created. The undo tablespace is similar to the general tablespace, but the undo tablespace and

In oracle database, a datafile can be dropped, databasedatafile Refer to the mos article:Unable to Drop a Datafile From the Tablespace Using Alter Tablespace Command (Document ID 1050261.1) This datafile cannot be dropped because of any of the

Call the Oracle stored procedure in java, and the javaoracle Stored ProcedureCalling the Oracle stored procedure in java This article describes how to call the stored procedure of Oracle through java. 1. Write the Stored Procedure Create or replace

Innobakcupex cross-instance Incomplete recovery steps, innobakcupex cross-instance On the basis of Hot Standby, MySQL can achieve full or incomplete recovery of the original Instance. In many cases, DRBD or MHA is deployed on the original instance.

Redis persistence-RDB working principle and problems, redis-rdb Working principle of Redis persistent RDB mode: Redis persistent RDB mode. Redis uses the copy on write mechanism of the fork command. When a snapshot is generated, the current