Oracle

Buffer Cache is an area of the SGA area that is specifically used to store copies of blocks of data that are read from the data file. If the Oracle process finds that a block of data that needs to be accessed is already in the buffer cache, it reads

Flashback Data Archive (Flash back archive)The rollback information for the Undo table space Record, although it can provide a back-flash query, but for a long time, this information will be overwritten, in fact, as long as the transaction is

Oracle has recently launched the five new features of Oracle managed CRM R16, following the introduction of Oracle Managed CRM version 16 (CRM on Demand R16) last month. This article will introduce the five features. BEIJING, February 24,

Online log file inacitve state indicates that the log contains data modifications that have been synchronized to the data file and that the instance is not needed when it is recovered, so its loss does not cause any data loss, but can cause the

The data guard provides the following three kinds of protection modes: 1 Maximum protection mode (Maximum Protection) "Maximum protection" here refers to the maximum protection of the data is not lost, that is, at least one standby and primary

* * The test is for the next test, according to the condition of the increment column as the partitioning condition, according to the time as the partition condition. Create tablespace test01 datafile ' D:\oracle\oradata\myora\test01.dbf ' size

1. Introduction to Basic table space A. system table space Main storage data dictionary and Internal system table base table To view the SQL of the Data data dictionary SELECT * FROM Dict To view the SQL for an internal system table SELECT *

What is redo Redo record transaction logs, divided into online and archived. For the purpose of recovery. For example, if the machine is out of power, then you need to go online redo logs to restore the system to the failure point after the reboot.

Oracle used a whole book to illustrate Valut, interested in children's shoes can refer to http://docs.oracle.com/cd/E11882_01/server.112/e23090/toc.htm, I personally think it does not need It is only right to know that there is such a thing as a

Oracle is still more commonly used, so I studied Oracle COMMIT, here to share with you, I hope to be useful. The user can issue a commit,oracle commit trigger LGRW only if the last block of all rows affected by the SQL statement is read into DB

Oracle announces that it will participate in the Grails Open source program, helping to improve the productivity of Java program developers by closely matching the groovy instruction language.Grails builds on open source technologies such as spring,

oracle| Page | data | database | Display again is to organize the data to be placed in Oracle database $serial =md5 (rand ()) (uniqid); $ref = ""; $id = $PHP _auth_user; $ip = $REMOTE _addr; $msg =base64_encode ($msg); $flag = "1"; $query = "INSERT

oracle| Security | strategy | data | database Oracle is a relational database management system, which has powerful function and excellent performance, and occupies an important position in today's large database management system. In the MIS system

oracle| Design | Optimization Preface 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

oracle| Recovery | control | data --------------------------------------------- Experimental platform: Windows + Oracle 10.1.0.2.0 Author:ningoo 2005-03-26 -------------------------------------------- After the control file is backed

oracle| Security | security Vulnerabilities | data | database Description: Oracle database is a large, commercial, and data-base system. Various Oracle Database servers, Oracle Enterprise Manager, Oracle Application Server, Oracle collaboration

Oracle claims to install the Oracle9i database under Linux at least 512MB of memory and at least 1GB or twice times the memory size of the swap space, for the system memory is greater than 2GB of servers, swap space can be between 2gb-4gb. If you

Hints translated into Chinese is the hint, implied meaning, it is in the database role is to change the execution of SQL statements, you can use hints to force SQL in the way you set up to execute SQL, generally used to do performance diagnostics

In fact, is not a trap, just do not pay attention to, it is easy to configure errors. This article describes the possible errors caused by load_balance and failover coordination. When the service name is configured with both Load_balance and

If the database is in Noarchivelog mode, we will recover the database from a full offline backup and it is not possible to achieve point-in-time recovery. 1, restore the preparation work If you run the database in Noarchivelog mode and assume that