Database Administrator

Use HugePages to optimize memory performance Copyright:During reprinting, please use hyperlinks to indicate the original source and author information of the article and this statementHttp://blog.csdn.net/wenshuangzhu/article/details/440955651.

Modifying Instance name SID in Oracle Modify the Oracle Instance name System Environment: CentOS 6.5ORACLE version: 10.2 1. Check the original database instance name$ Echo $ ORACLE_SIDOrcl $ Sqlplus/as sysdba> Select instance from v $

The conversion from the datetime2 data type to the datetime data type generates a value out of the range, datetime2datetime This error occurs when you use Entity Framework to operate databases.This error is strange, in the garden saw a brother

In-depth explanation of Null in SQL and SQLNull NULL represents unknown in the computer and programming world and is uncertain. Although the Chinese translation is "empty", this null is not empty ). Null indicates an unknown state and future

OBIEE SampleAppv406 Automatic startup configuration, obieesampleappv406 SampleApp introduction:   SampleApp is an all-in-one service that demonstrates almost any top-level features that can be imagined in OBIEE. It is a VirtualBox virtual machine

Sqlserver cache plan-Clear the cache plan that is only used once, And Cache The plan cache is very large and will only be cleared once using the cache plan, instead of the entire cache. declare @ sid varbinary (64) declare cur01 cursor forselect

Create and modify temporary oralce tablespace, oralce SpaceA temporary tablespace is a disk space used to store the temporary data generated when you execute the order by lamp statement for sorting or summarizing. By default, all users use temp as

One SQL statement interview question: for students who take all courses, SQL statements For a job interview a few days ago, there was an SQL question: three tables are provided: students, courses, and scores. A seemingly simple problem made me

SAA-SQL access advisor (oracle 11.2 and later), saa-sqladvisor I recently used SAA and found that many blogs on the Internet actually have problems using it in subsequent versions after oracle 11.2, Either the version change syntax is changed or

Install mysql in Linux and mysql in LinuxI. Simple Installation# Yum install-y mysql-server mysql-develIf an installation package conflict is reported:File/usr/share/mysql/ukrainian/errmsg. sys from install of MySQL-server-5.5.18-1.rhel5.i386

Modify the tomcat user password and tomcat User Password Original Works are from the blog of "Deep Blue blog". You are welcome to reprint them. Please note the following source when reprinting them. Otherwise, you will be held legally liable for

Mysql basic syntax summary, mysql basic syntax# Creating a tableCreate database mytestUSE mytestCreate table userInfo (UserId int primary key AUTO_INCREMENT not null, # auto_increment is automatically increasedUserSex INT (4) DEFAULT '0', # DEFAULT

Auto increment of ID fields in the SQL _Oracle table and SQL _oracle Field Original Works are from the blog of "Deep Blue blog". You are welcome to reprint them. Please note the following source when reprinting them. Otherwise, you will be held

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

[Translated from mos] a thorough understanding of rman compression, mos Article rman Compression A thorough understanding of rman CompressionSource:A Complete Understanding of RMAN Compression (Document ID 563427.1) Applicable:Oracle

Use the alter system check datafiles command, alterdatafiles The alter system check datafiles command seems to have been seen in the White Paper, so I searched for it in the SQL reference in the official document. The description of this statement

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

Install mysql in Linux and mysql in LinuxI. Simple Installation# Yum install-y mysql-server mysql-develIf an installation package conflict is reported:File/usr/share/mysql/ukrainian/errmsg. sys from install of MySQL-server-5.5.18-1.rhel5.i386

[Mysql] add, delete, modify, and query Mysql Databases in Java, Java System class, And javamysql This part is also the content of the so-called JDBC and website data sources. It makes the name very similar. In fact, it is only the content of adding,

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/