Database Administrator

Oracle UNDO monitoring Oracle 10 GB and later versions have a new feature, that is, automatic adjustment of the undo retention time, which greatly simplifies management. For the undo tablespace of autoextend on, the undo_retention parameter is set

Automatic Backup of asm disk header after Oracle 10.2.0.5 Before Version 10.2.0.5, the ASM disk header was not automatically backed up. You must manually run kfed read or dd to back up the disk, From 10.2.0.5 onwards, the ASM disk header will be

MySQL optimization summary on Linux Currently, most of the MySQL running environments are on Linux. Here we provide some general and simple policies on how to optimize MySQL on the Linux operating system. These methods help improve MySQL performance.

Online expansion of database UNDO tablespace Expand the database UNDO tablespace online and log on to the Oracle database server with an Oracle account Method 1: View the tablespace name and file location: Select tablespace_name, file_id, file_name,

Does Operations on blob fields in Oracle produce a large number of redo operations? Check whether the blob field produces a large number of redo operations. The answer is no. Here is an experiment to test whether the Oracle database version is 11.2.0

MySQL 5.6-innodb import Improvement Before MySQL 5.6, the idb file for importing a single innodb table must be aligned with the tablespace id. If the tablespace id is inconsistent, you need to increase the tablespace id by creating a new table in

Detailed description of ROWID in Oracle 10g First use select * from v $ version; to query the current version of the Oracle database SQL> select * from v $ version; BANNER----------------------------------------------------------------Oracle

How to update a table using query results in Oracle Oracle uses the results of one query to update the data of another table. The simulation experiment is as follows. Use the query results of table t2 to update data with the same id as table

In-depth analysis of Oracle Library Cache In-depth analysis of Oracle Library Cache Each object in the database cache is divided into multiple parts in the database cache for storage. Oracle aims to achieve more flexible memory management, because

ORA-01843: not a valid month, ora-01843valid This problem was encountered during the code today, because oracle is rarely used and the query is located. Suddenly dummies, there are a lot of posts that are due to the problem of nls_date_language,

[Translated from mos] oracle NUMA support and 11gr2numa support are enabled in Oracle db 11gR2.Enable oracle NUMA support in Oracle db 11gR2Reference Original:Enable Oracle NUMA support with Oracle Server Version 11gR2 (Document ID

How to optimize QuerySet query by the select_related and prefetch_related functions of Django (1), djangoqueryset When the database has a foreign key, the use of select_related () and prefetch_related () can greatly reduce the number of database

In mysql5.6.19, The subquery cannot use the index. mysql5.6.19 Index The table structure is simple. Create table 'oplogs '('Id' int (10) unsigned not null AUTO_INCREMENT,'Kind' varchar (45) not null default '','Op' varchar (100) not null,'User'

[Translated from mos] After recreating the control file, the Missed Database Supplemental Log Information and databaseAfter the control file is rebuilt, the Supplemental Log Information of the Database (Missed Database Supplemental Log Information)

JDBC and mysqljdbc In the previous article "Let's talk about Java EE", we will explain what norms are and what their functions are. In this article, we will elaborate on JDBC.JDBC JDBC (Java Database Connection) is also a specification in Java EE.

3. Database paradigm The database three paradigm is certainly not unfamiliar to everyone. The official explanation is very abstract and difficult for beginners to understand. I forgot to read this knowledge. Whenever someone asks me, you must first

Delete the selected row of the DataGridView and update the database. The previous article published the DataGridView control to display data. DataGridView often appears when dealing with databases and is also very useful. Using the DataGridView to

Oracle GoldenGate (ogg) 11.2.1.0.20 is the last ogg version that supports oracle db 10 Gb, oracle11.2.0.4 Reference Original: Oracle GoldenGate 11.2.1.0.22 Patch Set Availability (Doc ID 1669160.1) This article does not translate and only

The restoration after the MySQL database is deleted. In the morning, I accidentally deleted a database I just created yesterday! Fortunately, the log feature is enabled in mysql. The following describes how to restore a deleted database: First, save

Simple use of mybatis and simple use of mybatis Package to be used: (here is only one version, other Baidu) Mysql-connector-java-5.1.6-bin Mybatis-3.2.2 First look at the project directory: Configuration File mybatisconfig. xml: -->