Database Administrator

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

Resolution case with ORA-39154 errors when impdp is executed A data table Import and Export Operation encountered a ORA-39154 when using impdp import, it took some time to solve.Below I actually restored this error in the test environment, and

In Linux, MySQL forgets the root user password. Today, when receiving a MySQL server, I found that I forgot the password of the root user of MySQL. I found that no root user password exists in various documents. Therefore, I need to modify the

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

How to set the ASH buffer size Ash Buffer is a memory area used in a loop in SGA to store the active session information captured by MMON. MMNL dumps the content of Ash buffer to AWR every 60 minutes after filtering, the corresponding view is

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

One of the TimesTen series: TT migration and backup, one of the timesten SeriesTimesTen can use ttMigrate for migration, similar to Oracle exp/imp.The usage document is very detailed, or you can execute ttMigrate -- help to view it.I will only

Detailed explanation of ACID features and acid features ACID is: Atomicity, Consistency, Isolation and Durabilily ). 1. atomicity The atomic attribute is used to identify whether the transaction is completely completed. Any update of a transaction

[ORACLE] analyzes 23 oracle sessions and performance statements, and 23 oracle session statements.**************************************** ********************************* *** Original article: blog.csdn.net/clark_xu Xu changliang's column**********

Hp-ux slvm, slvm At first, I heard the name "hp-ux slvm. After searching, find a pdf document: , fourth edition in September 2009, find the slvm explanation: The shared LVM (SLVM) allows multiple systems in the Serviceguard cluster to share (read/

Shang Silicon Valley-mybatis-(one-to-one Association), Silicon Valley-mybatis- Demand: Query Class information by class id (with Teacher Information) Project Structure: Create tables and data: CREATE TABLE teacher(t_id INT PRIMARY KEY

Monitor the running status of database things and database things Select dbt. DATABASE_ID, DB_NAME (DBT. DATABASE_ID) 'database name', DBT. TRANSACTION_ID,. NAME,. TRANSACTION_BEGIN_TIME, case. TRANSACTION_TYPE WHEN 1 then' read/write TRANSACTION

MongoDB installation and simple commands, mongodb installation commands Mongo http://www.mongodb.org/downloads Vue tool download http://www.mongovue.com/downloads/ Create a folder and put the unzipped mongo file. Make a variable and specify the

Differences between Mysql versions and those downloaded from the official website Differences between Mysql versions and download from the official website   I. Differences between Mysql versions: 1,MySQL Community Server Community version, Open

[Translated from mos] The buffer memory parameter is used to adjust the performance of rman ., MosrmanUse the buffer memory parameter to adjust the performance of rman.This article is translated from the mos article: RMAN Performance Tuning Using

Oracle data type-2, oracle-2 5. NUMBERIt is used to store zero, positive, fixed-length negative, and floating point numbers. The NUMBER data type can be set to NUMBER (P, S) Format to define the precision and range of numbers. Here: p indicates

Student Information Management in Mysql c api, mysqlapiZookeeper With the embedded MySQL Server library, you can use MySQL servers with all the features in client applications. The main advantage is that it increases the speed and simplifies the

MySQL can change the root password in four ways (for example, windows), mysqlroot Method 1: use the set password commandFirst, log on to MySQL.Format: mysql> set password for username @ localhost = password ('new password ');Example: mysql> set

After you move the core object table dependency $, the database is not started.Move table:SQL> startupORACLE instance started.Total System Global Area 281018368 bytesFixed Size 2083336 bytesVariable Size 88081912 bytesDatabase Buffers 184549376

Redis Research (8)-Ordered Set Type 1, redis research set type I. Introduction Sorted set Associates each element in the set with a score. Therefore, you can obtain the first N elements with the highest or lowest scores, and obtain the elements in