Database Administrator

Add auto-incrementing column in Oracle This is because the database of the other party is Oracle during project creation, and the identity () cannot be the same as that of MSSQL during auto-increment. Create sequence UserID_sequence -- create a

Oracle learning-in-depth analysis of Buffer Cache Oracle learning-in-depth analysis of Buffer Cache Server process and database buffer cache: When the server needs a block, it needs to read the block in series steps: 1. First, the server uses the

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

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

Oracle index Suppression Preface: in many cases of Oracle Database optimization, you can increase the database performance by adding indexes. However, in some cases, DBA cannot do anything about it, because all the indexes have been created, but the

MySQL implements Minus and Intersect) MySQL does not implement the Minus and Intersect functions, just as it does not implement the cube function. You can use SQL to implement the same function, which is troublesome. Drop table t1; Drop table

Oracle Database Development In the Oracle database system, tables are the basic objects of databases, and all data in the database exists as tables. Environment-Oracle 11g I. Table typeCommon tables in Oracle Database systems include: heap

Rubbing people and chores-constantly updating, and constantly updating1. After finishing the lv layout and adding datafile, we can find the big tablespace ....2. Add a bare device datafile without r3. Access the cde interface through the xmanager

[Translated from mos] The v $ undostat view is not updated every 10 minutes. v $ undostat has only one row (one rows) and mosundostat. The v $ undostat view is not updated every 10 minutes. v $ undostat has only one row (one rows) Reference Original:

SQL Server notes, SQL Server notes Question 1: remove the red mark I have never seen any red symbols. I tried to paste these symbols into notepad and found it garbled. I tried to paste it into the SQL query analyzer and found it blank. For such

Oracle Database Backup Data is missing Oracle databases have been used in the project. Since I have been focusing more on the ORM ing framework, I have barely paid attention to Oracle features, and I do not know many things, in addition, the

Write hive udfs and hiveudfs1. Configure the environment 1. Introduce the jar package: hive-exec-0.8.0.jar and hadoop-core-0.20.2.jar2. Compile udf function 1. extends UDF2. redefine UDF evaluate function. Package com. qunar. hiveudf; import java.

[Oracle] OGG error while loading shared libraries, sharedlibraries [Oracle @ jp ogg] $./ggsci ./Ggsci: error while loading shared libraries:/u01/app/oracle/ogg/libclntsh. so.11.1: cannot restore segment prot after reloc: Permission denied Disable

Chapter 1 Securing Your Server and Network (2): SIDs for management services, securingsidsSource: http://blog.csdn.net/dba_huangzj/article/details/37927319, topics Directory: http://blog.csdn.net/dba_huangzj/article/details/37906349 Without the

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

Role of TNS in Oracle, role of OracleTNS What is TNS? TNS is a part of Oracle Net. It is a tool used to manage and configure the connection between the Oracle database and the client. In most cases, to communicate with the database, TNS must be