Oracle

Recently checked a blog before, unexpectedly found this bug was I forget, after a year to continue to solve this problem. Based on the analysis process described in the previous article, it is generally possible to confirm that the statistics of

Before we go through the incomplete recovery case walkthrough, we need to learn how to use the Logminer tool. The tool mainly digs the redo log to find out the DDL or DML operations made at a point in time (including: Point-in-time, DataBlock SCN,

According to Oracle's documentation, the data pump in different ways to export imports, performance can be significantly different, this time just have the opportunity to test, migration table space, direct path, external table, and database chain

In the previous chapter we practiced a streams synchronization of a single table, it looks very simple is not (if you feel complex, it is not because the streams itself is complex, but to configure the streams earlier preparation is more complex),

Rman is a physical-structured backup based on data block backup, supporting the recovery operation with online redolog and archive Redolog, and is Oracle's recommended backup recovery tool. The data imp/exp is a logical structure based import

1, the function of the data dictionary The data dictionary records the system Information of the data, which is a collection of read-only tables and views. The owner of the data dictionary is the SYS user, and it is saved in the system table space.

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,

Data block corruption due to hardware failure or operating system failure during Oracle database operation that causes Oracle to not recognize or contain content in Oracle format Failure, this bad block can be divided into media damage and logical

Products: AIX, Oracle Platform: pseries, AIX Version: All Conflicts in memory access now when the process requests more memory than the total physical memory of the system, in order to handle this situation, the system swaps the program and the

Oracle installed by using the OTK tool does not configure EM by default, and the configuration and startup process is documented below! First create EM, and execute the following command $ emca-config Dbcontrol Db-repos recreate I ran the following

The row and column conversions include the following six scenarios: 1. Column career Change 2. Row-Turn column 3. Multiple columns converted to strings 4. Convert multiple lines into strings 5. Convert strings to multiple columns 6. Convert

1. Table structure Sql> desc v$process is the name empty? Type ----------------------------------------- -------- ---------------------------- ADDR RAW (8) PID number SPID VARCHAR2 (12) USERNAME VARCHAR2 (15) serial# number TERMINAL VARCHAR2

In 10g, the Rman backup is optimized to no longer back up the data blocks in which the table frees space. The backed up document is 9i, so it has always been considered that the Rman backup only backs up the blocks where the data was written, and

The Recycle Bin, as its name suggests, is the thing that stores the deleted items. The principle is a data dictionary table, put the user delete (drop) of the database object information. The object that the user is deleting is not deleted by the

The test found that even in 11.2, the problem still existed: Sql> SELECT * from V$version; BANNER -------------------------------------------------------------------------------- Oracle database11genterprise Edition release11.2.0.1.0-64bit

Preface The growing demand for distributed applications requires a better distributed software environment, which drives the development of distributed technology. Oracle data replication is a technology for implementing distributed data

ERROR:PLS-00201: Must indicate identifier ' DATETIME ' Line:45 TEXT:AA datetime, ------------------------- No datetime types in Oracle =================================================== Error: PLS-00103: 出现符号 "("在需要下列之一时：　　　　:= . ) , @

In the large and Medium-sized database management system at home and abroad, there are more users of ORACLE as database management platform. Oracle is not only a database management capability or security is justifiable, but it is in the display of

Query initialization parameters A lot of ways, such as show PARAMETER, or query V$parameter, here a brief summary. This article describes how to determine the origin of an initialization parameter. To determine if the database startup is enabled