Oracle

Briefly describe the process of adding a node in the Oracle 10203 for Solaris SPARC Dual-node environment. Shared storage is already configured on a third node, which focuses on the configuration on the operating system and on Oracle. This article

The two concepts that are easily confusing for first-contact Oracle databases are Oracle instances and Oracle databases. These two concepts are different from instances and databases under SQL Sever, and of course there are similarities. Just in SQL

First, the concept Tablespace: is a logical collection of one or more data files Table Space Logical Storage objects: Permanent segment--> such as tables and indexes Temporary segment--> such as temporary table data and sorted segments Rollback

In Oracle databases, Undo has three main roles: providing consistent read (consistent read), ROLLBACK TRANSACTION (Rollback Transaction), and instance recovery (Instance Recovery). Consistency reading is relative to dirty read (Dirty read).

Reduce disk IO IO for distributed disks 1, the table space using local management, the file spread to different devices 1 separate the data file from the log file 2 Reduce server-independent disk IO 3 Evaluate the use of bare equipment 4)

In Oracle 10.2.0.4 database, there is a slow SQL execution, more than a few minutes without results, waiting for the event is idle Sql*net message events, and finally forced to break. This SQL is an ordinary UPDATE statement that has multiple

Oracle's flash-back functionality restores a specified table in the event of an incomplete recovery of the database. The flashback database is a new method for point-in-time recovery, which enables you to quickly restore Oracle to a previous time to

Basic syntax for Oracle stored procedures 1. Basic structureCREATE OR REPLACE PROCEDURE Stored procedure name(Parameter 1 in number,Parameter 2 in number) isVariable 1 INTEGER: = 0;Variable 2 DATE;BEGIN End Stored Procedure name 2.SELECT into

Prior to using EXP, IMP Lead Library command successfully implemented the Oracle database export, import, on this, yesterday again to the server's newly installed Oracle database with EXP, IMP Guide library, has been reported as "EXP-0006: Internal

Oracle has been releasing Oracle for 12C for some time and Oracle has only 64-bit releases and no 32-bit version. Our system installation environment is CentOS 6.5 x86_64. 1. Install Oracle Dependency PackModify the Yum configuration and install

The first thing that comes to mind is contains,contains usage as follows: SELECT * from students where contains (address, ' Beijing ') However, using the CONTAINS predicate has the condition that the column is indexed, that is, if the

1. Check the status of OLR: [Root@vmrac1 ~]# ocrcheck-local Status of Oracle Local Registry is as follows: Version:3 Total Space (Kbytes): 262120 Used Space (Kbytes): 2748 Available Space (Kbytes): 259372 id:935756415 Device/file

First, DBV description DBV is a commonly used tool, Oraclemos has an article on Dbv:[id 35512.1]. The main purpose of the Dbverify tool is to check the physical structure of the data file, including whether the data file is corrupted, whether

Oracle 8i introduced recovery management (RMAN), and for the first time true incremental backups were implemented. The database output can also be incremented before Rman, but the entire table needs to be overridden once any piece of a table has

Objective The vast majority of Oracle database performance problems are caused by unreasonable database design, only a small number of problems rooted in db Buffer, Share Pool, Redo Log buffer and other memory module configuration unreasonable, I/O

Case 7: --Recovery with incremental backups 1) Establish an incremental backup -------0-level backup using image backup as an incremental backup rman> copy datafile 2 to '/disk1/rman/prod/users_%s.bak '; 2) Establish a level 2 differential

In the previous article I've talked about using synonyms to connect to Oracle under SQL Server 2005, and we can use synonyms to connect Oracle under SQL Server 2005 to real-time access to Oracle databases. However, if the table data stream in Oracle

The refresh of materialized views is actually not fundamentally different from normal SQL execution, so you can customize the refresh operation by creating triggers on materialized views. Just two days ago, someone asked me on the blog, if you add

1. Backup:Ps:2014-1-15If the exported DMP data file is not large, it is exported directly every day, do not save only seven days of data. Then, the file is packaged by WinRAR, and I find that the DMP files are still very compressed.Then you need to