Database Administrator

Oracle blocking) Blocking is a common situation for DBAs. especially poor application design blocking can cause serious performance degradation until the database crashes. For DBA, it is necessary to know how to locate the system blocking, who is

MySQL binary case sensitive Why is MySQL Case Insensitive ?? I was almost dazzled. Make another query. This is the result of Shenma. You can use binary to convert a string to a binary string for comparison. After adding binary, it

Detailed description of Oracle user Creation 1. User conceptsThe user, that is, the user, is generally the "person" who accesses the Oracle database ". In Oracle, users can control various security parameters to maintain database security. These

Error Log enabling in insert and Analysis In normal work, sometimes a batch of data needs to be inserted, which may be temporary tables, external tables, common tables, subqueries, and other forms, similar to the following formatInsert into xxxx

Oracle exp imp backup and recovery of table space data Oracle backup is divided into logical backup and physical backup. Logical backup is exp/imp; physical backup includes cold backup, hot backup, and RMAN backup. Exp/imp has three modes: Table

Detailed Oracle 11G restart uard restart process Scenario: restart the database, do not restart the linux system, so you do not need to consider listening programs,# Linux input lsnrctl start1. Close the database1.1 shut down the master

Relationship between OracleServiceXXX and Oracle instances in windows, oracleservicexe In fact, oracle in windows is completely dependent on OracleServiceXXX in the window service when the oracle instance is started. This XXX is the oracle Instance

Images and raster of 2014Esri global user conference, 4esri raster1. Now Esri has used images as part of the GIS solution. What is its specific strategic deployment? Over the past decade, Esri has planned to manage and develop image and raster

C # "like" is used in the program to query access database queries that are empty, Today, we found a particularly strange problem during the development process: the like query in access is executed in the Access database and the query results can

Retired Note 1 # MySQL = lambda SQL: SQL + 'source Code 4 Explain Plan ', The Mysql query execution process is roughly divided into four stages: Syntax analysis (SQL _parse.cc ) > SQL _resolver.cc # JOIN. prepare Generate logical query plan (SQL

Db_keep_cache_size control range test, dbkeepcachesize In the new questions of the ocm examination, you need to create a table for storing keep, but there are some differences regarding whether the parameter should be modified. Some people say that

Adjusting the size of oracle sga causes ORA-00851 and ORA-00844 errors, sgaora-00844Today, I adjusted the sga size. As a result, the following error is returned when I restart the database.SQL> alter system set sga_max_size = 1024 M scope =

[Translated from mos] use the asmcmd cp command to move the datafile from the file system to the asm disk group-for 11gR2, asmcmd11gr2Use the asmcmd cp command to move the datafile from the file system to the asm disk group-for 11gR2Reference

[Translated from mos] mosasm How to reclaim the asm disk space Reference Original:How To Reclaim Asm Disk Space? (Docid 351866.1) Applicable:Oracle Database-Enterprise Edition-Version 10.2.0.1 and laterInformation in this document applies to any

Thoroughly understand oracle Standard Quantum queries and oracle Standard Quantum queries Oracle scalar quantum queries and user-defined functions are sometimes more convenient to use, and developers often use them. It doesn't matter if the data

[Data analysis Interview Questions] One interview question, my answer, and the answer to the data analysis interview questions I attended a data analysis interview with a company in Hangzhou this afternoon. I am familiar with some of the questions,

Xtrabackup migrate an INNODB table, xtrabackupinnodb Mysql database. I want to delete a table. The primary key of this table is used as the foreign key of multiple other tables, InnoDB, and cascade deletion is set. This operation obviously

Mysql merge table introduction, mysqlmerge table In Mysql databases, Mysql Merge tables are somewhat similar to views. Next let's take a look at the advantages of Mysql Merge tables and hope to help you. Advantages of Mysql Merge table:A: Separate

Rman backup optimization ideas, rman backup This chapter does not discuss the principles of rman backup, but only provides some ideas. 1. Select the compression algorithm of oracle11g as intermediate; 2. added the rman backup channel. The above two

Server. ScriptTimeout = 1000000'Xtype = 99 ntext is similar to text. The difference is that the ntext type adopts the unicode standard character set.'Xtype = 35 text is used to store a large amount of text data.'Xtype = 231 nvarchar is used to