Oracle

Specify a partition in addition to using the partition name, many times you can use a for statement. Starting with the 11g, you can use the partition name as well as the for statement when you are working on the partition. In 10g, the statement

Description: 11g database is now a lot of new deployments, for the 10g database, now clean up the 10g to 11g upgrade process. 10.2.0.2 above version can be upgraded to version 11.2.0.3. Upgrade Note: 10.2.0.5 (->) upgraded to 11.2.0.3 (64) First,

OMF, the full name is oracle_managed files, that is, Oracle file management, the use of OMF can simplify the management of the administrator, do not specify the name of the file, size, path, its name, size, the path is automatically allocated by

1, LRU linked list structure overview In the front, we already know how Oracle searches the hash chain for the corresponding buffer header of the data block, and we know that if the desired buffer header is not found on the hash chain, Oracle will

In Oracle, table space is the basic method of data management, all users ' objects should be stored in the table space, that is, the user has the right to use the space, in order to create user Object Otherwise it is not allowed to create objects,

In the process of running the database, it is unavoidable to encounter all kinds of situations which can cause the database to be corrupted. For example, sudden power outages, Oracle or operating system bugs caused the internal logical structure of

For DML statements, as long as the data block is modified, the Oracle database retains the modified data in the undo segment, while the undo segment is saved in the Undo table space. From Oracle 9i, there are two ways to manage undo: Automatic Undo

Starting with Oracle 10g, Oracle provides a new feature for automatic SGA management (ASMM, or automatic Shared Memory Management). The so-called asmm, means that we no longer need to manually set the shared pool, buffer pool and other memory pool

Many organizations have an online transaction processing system. This type of system is characterized by: There are high data update activities that are typically performed by a large number of users. A large number of users concurrently access

In the previous article, we introduced the most important document in Sql*loader--control file, this article is about the most important part of the control file-the field list, the role of the field list is to the data file records and the database

The control file is the most important file in Sql*loader, which is a text file that defines the location of the data file, the format of the data, and the behavior of configuring the data loading process, and specifies the control file in Sqlldr

Import Mode As with the export mode, the following 5 modes are mutually exclusive. Full mode Set Full=yes, if there is no datapump_imp_full_database role, can only be imported into the data under their own schema Schema schema Sets the schema

The specific configuration of Oracle load Balancing is described in detail in this paper. Through the client and server side of the configuration, the text of the code is more comprehensive, worthy of reference. For professional data-processing

Pga The PGA (Program Global region area) is a memory area that contains data and control information for a service process. It is created by Oracle at the start of a service process and is unshared. An Oracle process has a PGA memory area. A PGA

The archive log file is a truncated backup of the redo log file, and two modes of Oracle running: Archive mode and no archive mode. 1. Enable/disable archiving mode Sql>archive log list; Query Archive mode Sql>shutdown Immediate Sql>startup

The PL/SQL statement provides the ability to process a result set line by row through a cursor. A cursor can be treated as a special pointer that is associated with a query result and can point to any location in the result set to handle the data at

The procedure for swapping partitions is as follows: 1. Create the partition table T1, assuming there are 2 partitions, P1,P2. 2. Create the base table T11 the data that holds the P1 rule. 3. Create the base table T12 the data that holds the P2

Description (1). The db_name needs to be the same when Rman is backed up to a different machine recovery. If you want to change to another instance name, you can change it with the NID command after the restore succeeds. The information of the

Java Interface with Oracle: Running Java in a database can be said to be the most exciting new feature of Oracle8i. In the application you created to use the Oracle8i database, you can use new Java-related features to easily publish programs to the

Sql_trace is an Oracle-provided tool for SQL tracing and is a powerful aid diagnostic tool. Sql_trace is a very common method in the daily diagnosis and resolution of database problems. In this paper, the use of Sql_trace is discussed briefly, and