Database Administrator

Install Oracle on bare devices on AIX Recently, new systems have been released. I have not prepared documents for installing Oracle on AIX. I have prepared a document for future reference. The simple steps are omitted here. 1. view the system

Solve OEM garbled Characters During Windows Access Problem description It is found that the oem button is always garbled when Windows is used to access Oracle installed in Linux. The solution is as follows: OEM introduction and button

EM database reconstruction manual deletion of Database Because the original database has been deleted, you need to use the listener when redoing the oem. At this time, the following error is reported: [Oracle @ localhost ~] $ Emca-repos recreate Jul

Optimize Oracle with full table Scan Today, development has met a very BT demand.Find all friends of a person, query all works of all friends, and sort them in reverse chronological order to obtain several records,Then associate the Work Comment

Oracle Study Notes: Use of the graphic management tool EM Use of common Oracle learning notes tools-EM Graphics Management Tool em Server 1 Ensure Listening Starts -----> grid Lsnrctl status Or Netstat-tunlp | grep 1521 If not Lsnrctl start 2.

Why MySQL transactions cannot be rolled back When using MySQL, if you find that the transaction cannot be rolled back, but the Hibernate, Spring, JDBC and other configurations do not have obvious problems, don't worry, first check whether the table

MySQL myisam solution for concurrent read/write Mysql myisam solves the problem of concurrent read/write. MyISAM is very efficient when reading operations are dominant. Once a large number of read/write concurrency occurs, the efficiency of MyISAM

MySQL-5.5.38 universal binary Installation 1. System Environment: CentOS 6.5 _ x86 2、mysql-5.5.38-linux2.6-i686.tar.gz The file name format for the MySQL binary distribution is mysql-VERSION-OS.tar.gz, where VERSION is the VERSION number (for

CentOS 5.3 installation and configuration Oracle 10g Manual start and self-start service The following is a text description of the installation process on Oracle 10g, CentOS 5.3 1. Download and decompress 10201_database_linux32.zip to the database

[Translated from mos] What is the maximum value of Db_recovery_file_dest_size? dbrecoveryfiledestWhat is the maximum value of Db_recovery_file_dest_size?Reference Original:What Is Maximum Size For Db_recovery_file_dest_size In Oracle 10.2, 11.1, 11.2

An error in ora-12170, mosora-12170 is reported when a remote machine is connected to a db on windows.Error ora-12170 reported when connecting to db on windows from remote machineReference Original:Windows: ORA-12170 Attempting to Connect from

Stage Summary-how does shell access mysql and shellmysql? For the previous project, a script is required to manage mysql, I originally wrote one in C, because it was confusing with shell at the time. Later I found that C is not convenient to shell,

Oracle UNDO monitoring and oracleundo monitoringOracle 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

Crmsql queries table information and crmsql Information -- Query the object corresponding to the specified lookup fieldSelect name, OriginalLocalizedName from MetadataSchema. EntityWhere objecttypecode in (Select objecttypecode from dbo.

The updated or deleted row values cannot make the row unique, or change multiple rows and multiple When I tried a table, I added several pieces of data to it. Later I found that the values of the fields originally intended as primary keys are "NULL"

Why does the SQL run very slowly when the COST is very small due to the misunderstanding of the execution plan ?, Execution Plan cost Reprinted please indicate the source: http://blog.csdn.net/guoyjoe/article/details/38321477   PM on March 31, My

[Oracle] User Creation and permission management, oracle permission management # Creating a user requires the administrator privilege SQL> create user lzz identified by lzz123; // a common user is created, but not unlocked # change the password for

Modify the MySQL database port number. Modify the configuration file when the database service starts. First, shut down the Database Service and modify the configuration file: When you modify the configuration file, there are several areas that

In-depth analysis of LRU for physical reading (least recently used), lru resolution Reprinted please indicate the source: Http://blog.csdn.net/guoyjoe/article/details/38264883 A set of LRU linked lists include the LRU main chain, LRU auxiliary

MySQL List partition (3), mysqllist Partition For details, see MySQL partition 1. Example: Here is my personal learning summary. How does mysql partition existing tables? I am also looking for a method. mysql has been able to partition