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

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

The Oracle 10g clusterware processes on unix-based systems are: Oracle Clusterware Oracle-provided Clusterware that manages clusterdatabase processing including node membership, group services, global Reso Urcemanagement, and high availability

First, recover via file descriptor (descriptor) (RM delete data file not backed up) Scene: misoperation Delete data file tp10.dbf Rm-rf/u01/app/oracle/oradata/bxdb/tp10.dbf Select Ts#,file#,name,bytes,status from V$datafile; Ps-ef |grep dBW

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

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

The Oracle 11g default installation database starts the audit feature, resulting in increased Oracle cumulative sys.aud$ table and associated index data volumes; If the table space is full, the ora-1654:unable to extend index SYS will be reported

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

Oracle Logminer is an actual, useful analysis tool that Oracle has provided from the product 8i, which makes it easy to get the details of Oracle Redo log files (archived log files), especially The tool can analyze all the DML (INSERT, UPDATE,

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

Have done some testing, in the startup or shutdown of the database to delete the control file, because this database is only my own test database, then did not care to recover. Today, when I wanted to start this database, I ran into problems:

9i Online redefinition There is a problem, after the completion of online redefinition, the table's name, although the same, but the index, constraints, triggers and other associated objects will change the name, sometimes this will bring some