Database Administrator

Handling of ORA-39700 with UPGRADE option errors Scenario: Use rman to recover a database from a different machine, and perform the most critical step. An error is reported when the database is opened. The details are as follows: SQL> startup mount;

Node where RAC Archive log is written incorrectly Multiple customers have asked several times that archive logs of node2 In the RAC environment are written to the archive path of node1. This problem causes some customers to be unable to read logs

Redis database (string and hash type) I. string type String is the simplest type in Redis. A key corresponds to a value. redis string can contain any data object, such as JPG images or serialized objects. The operations on the string type are as

How to delete a database in Oracle 11 without using DBCA This short tutorial will show you how to delete a database from Oracle 11 without using DBCA (Database Configuration Assistant. 1-SID of the imported database, if not defined Export

Navicat shortcut, navicatHot Keys Mian windows   Keys Action CTRL + G SettingsLocationFolder CTRL + # (# represents0to 9) Open Object Window from Favorites List F6 Console CTRL + H History

Oracle performance optimization operation 12: Use Case statements to merge multiple scans, oraclecase We often have to calculate different aggregation based on multiple sets of data tables. For example, the following example uses three independent

Application of nextVal and currVal in the database., nextvalcurrval X. nextVal gets the next sequence value of x sequence, and x. currVal gets the current sequence value of x sequence. Note:X.CurrVal must be referenced beforeX. NextVal; otherwise, a

Steps for installing 11gR2 ASM single instance and 11gr2asm instanceEnvironment: Platform: VisualBox 4.3.12OS: Oracle Linux 5.8 Grid Infrastructure: 11.2.0.3Database: 11.2.0.31. Install the Operating System (omitted)2. Configure the software

Database Optimization-vertical segmentation and Application in actual projects, vertical segmentation I was in charge of a project (China Telecom BDC project), and the purchased Database hardware was a small unit of P590. After the stress test, the

Oracle Performance Optimization Operation 9: shielding useless indexes and optimizing oracle Performance Example of "oracle performance optimization operation 8" In actual queries, there are also queries involving DisposalCourseFlag = 6. If the

Database Design Principles 1. The relationship between the original document and the object can be one-to-one, one-to-many, and many-to-many. In general, they are a one-to-one relationship: an original document corresponds to only one entity. In

How a single commit and multiple commit affect the IOPS of the system.Zookeeper The name and sensitive number desensitization statement in this article: In order to protect personal privacy, the real name of the expert is desensitized and replaced

Oracle performance optimization operation 4: Remove "IN", "OR" whenever possible, oracle Performance Optimization The Where clause containing "IN" and "OR" usually uses a worksheet to invalidate the index; If a large number of duplicate values are

Simple oracle query, simple oracle Data Query uses the SELECT command to extract information from the database table. Syntax structure: simple query SELECT * | column name | expression FROM table name WHERE condition order by column name Syntax

Summary of connection timeout in Hibernate + C3P0, Recently, the background always encounters a connection timeout problem when several game zones concurrently notify the background to write statistics. The following exception is thrown, causing

MySQL slow Query Slow query (slow log)It can help us locate specific SQL statements for SQL statement optimization. For example, slow query logs record the SQL statements whose execution time exceeds the given value, so as to locate the

Oracle environment variables and identifiers that you don't pay much attention to, and oracle environment variablesSign (?) Represents the ORACLE_HOME Environment VariableEg:SQL> ALTER TABLESPACE TEMP ADD DATAFILE '? /Dbs/temp02.dbf 'size 200 M;Sign

Stored Procedure Implementation paging, stored procedure Paging USE [HDIS]GO/***** Object: StoredProcedure [dbo]. [AspNetPager] Script Date: 12/30/2014 09:00:35 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCreate procedure [dbo]. [AspNetPager]

DB notes (Oracle), db notes oracle DB notes (Oracle) 1. Oracle Installation, Service Startup, database creation, and User Creation (omitted ). Ii. Select statement: (1) Single Row functions: 1. Expression and null calculation, the result is null,

Asmack source code entry, asmack source code The initialization of Smack involves two steps: 1. initialize system properties-initialize system properties through SmackConfiguration. These attributes can be obtained through the getxxx () method. 2.