Oracle

Meaning explanation:Q: What is NULL?A: When we do not know what the specific data, it is unknown, you can use NULL, we call it empty, Oracle, contains null values of the table column length is zero.Oracle allows fields of any one data type to be

This article mainly introduces the advantages and disadvantages of SQL Server, Mysql, Oracle Three kinds of databases, the need for friends can refer to the followingfirst, SQL ServerAdvantages:Ease of use, scalability for distributed organizations,

Oracle Study-aix6.1 Building Oracle 10GR2 RAC (4)I. Installation of CRS patchesbefore installing CRS, you need to install patch p6718715_10203_aix64-5l, or you will see a "node not found" error during installation. [[email protected]/]

Oracle common commands and functions, do a collation, for later use, easy to consult.Common commands:Connection SqlplusCommand line to run CMD entry, such as logging in the SYS mode, the command is as follows:(1). Sqlplus "sys/zhb126 as SYSDBA"(2).

Does Oracle support symbolic links under the RDBMS HOME (symbolic links)?References:Does Oracle support Symbolic Links in the RDBMS home?(Doc ID 813116.1)Suitable for:Oracle server-enterprise edition-version 9.2.0.1 to 11.2.0.3 [Release 9.2 to

OS:Oracle Linux Server Release 5.7Db:Oracle Database 11g Enterprise Edition Release 11.2.0.3.0-64bit Production1. Check the Listening status:sql>!lsnrctl StatusLsnrctl for linux:version 11.2.0.3.0-production on 12-nov-2013 01:36:29Copyright (c) 1991,

Preface: The First contact database, want to download an Oracle demo (although I heard that the general large enterprises only use), to the official website to download a simple version of the XE version, installation should be careful to remember

1, block, the concept of bufferThe concept of section block and the concept of the block are introduced.The concept of buffer2. The meaning of buffer cacheReduce IOPhysical IO: Disk readLogic IO: Memory readConstruction of CR blocks: later

In the previous version of Oracle, your username password is case insensitive, but in 11g, the case of the database default password is sensitive, so we know the fact that JDBC will turn it into uppercase when it gives the Oracle password, it's a

Transferred from: http://blog.csdn.net/cuker919/article/details/8767328Recently, due to the high CPU usage of the database, VCs often switch automatically, causing many problems.Recently learn about the database AWR Analysis database SQL execution

I. AWR reportAWR generates report data by comparing the statistics collected by two snapshots (snapshot), and the resulting report contains multiple parts, much like the report generated by Statspack. However, when generating reports, AWR can choose

#!/bin/bash## du of each subdirectory in a directory for asm#d=$1  if [[ -z  $D  ]]then echo  "please provide a directory !"  exit 1fi  (for dir in  ' asmcmd ls ${d} '  do      echo ${DIR}  ' asmcmd du ${d}/${dir} | tail -1 '  done)  |  Awk -v d=

From: http://woainichenxueming.iteye.com/blog/726541I. Optimizing SQL statements in Oracle to improve operational efficiency1. Select the most efficient table name order (valid only in the rule-based optimizer)The Oracle parser processes the table

A recent project involving SQL Server 2008, because of business requirements, wanted to establish a unique index, but found that in SQL Server, a unique index field cannot have multiple null values, and the following is an error message:CREATE

First, we need to differentiate what the HP processorMachinfo ViewPa-risc's product number starts with RP, and Itanium's product number starts with RxDifferent products need to go to the official website to download different media, so it needs to

Support for Oracle Products (database, middleware, etc.) in VMware virtualized environmentsReference from:Support Position-Oracle products Running on VMWare virtualized environments (document ID 249212.1)Suitable for:Oracle WebLogic server-version 10

See a lot of Oracle new scholars on the Internet annoying time format for Oracle, often after designing a table with a time field, inserting data into the table fails. Recall that I was just beginning to learn Oracle, but also to this time format

Oracle database link (DBLINK) Creation and deletion methods, oracledblink Create and delete a database link in OracleCreate dblink: create database link [name] connect to [username] IDENTIFIED BY [password] using '(DESCRIPTION = (ADDRESS_LIST =

ORACLE11G restores the rman backup of dataguard to the detailed process of standalone oracle in the test environment    1. copy the full backup file 1.1 from the production database to view the parameter file information. RMAN> list backup of spfile;

Oracle New Feature 4-maintenance, upgrade, recovery and Data Pump 1. Contents 1) enhanced table partition maintenance. 2) Database Upgrade and improvement. 3) Restore/restore data files across networks. 4) Data Pump enhancement. 5) Real-time ADDM. 6)