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

OCR corresponds to the registry of Windows. For Windows, all software information, users, configuration, security, and so on are all in the registry. And the cluster, again, all cluster-related resources, configurations, nodes, and RAC databases are

In the serious study of goldengate enterprise-level operation, the focus is on the understanding of the Ogg several processes, combined with the understanding of the principle, in the whole experiment nearly two days, after repeated configuration

Description This article installs the Oracle 11g Dataguard physical repository and tests the 11g Dataguard physical Repository's new feature active Data Guard, which is a function of Oracle Database Enterprise Edition, which requires the amount

As a complex Oracle database system, the SQL statements submitted by different users are processed every moment, obtaining the data and returning the data to the user. As already mentioned, parsing an SQL statement is done in a shared pool in an

Non-Data guard patch installation tutorials refer to the [Oracle] cpu/psu patch installation tutorial, where Data Guard requires primary and standby to be patched at the same time, so the steps are more complex and the main steps are as follows:

Oracle has three kinds of table connectivity technologies, namely, nested joins, merge joins, and Hash joins. 1. Nested loop joins (NESTED Loop join) A nested connection divides the data set to be processed into an outer loop (a driving data

When the data in the table is not needed, you should delete the data and release the space occupied, and the data in the table can be deleted using the DELETE statement or the TRUNCATE statement, described separately below. A, DELETE statement(1)

This article from the following aspects to collate the concept and operation of the partition table:1. Table space and the concept of partitioned tables2. The specific role of table partitioning3. Advantages and disadvantages of table partitioning4.

What is a combined multiline string (connection string), for example: sql> desc test; Name Type Nullable Default Comments ------- ------------ -------- ------- -------- COUNTRY VARCHAR2 (Y) City VARCHAR2 Y Sql> select * from test; COUNTRY City ---

addition Select Sysdate,add_months (sysdate,12) from dual; --plus 1 years Select Sysdate,add_months (sysdate,1) from dual; --Add January Select Sysdate,to_char (sysdate+7, ' Yyyy-mm-dd HH24:MI:SS ') from dual; --plus 1 weeks Select Sysdate,to_char (

1. static sqlsql and dynamic SQLOracle compiled PL/SQL program block is divided into two kinds: first, the previous early binding, that is, the SQL statement was established during the program compilation, most of the compilation is this type, and

I. Classification of audits: Oracle Audit in general can be divided into "standard audit" and "fine-grained audit" the latter also known as "policy-based Audit", after the oracle10g function has been greatly enhanced. Standard audit can be divided

Source Library rhel4.5:192.168.137.199 Global_name=wending. LK oracle_sid=wending Clone Library rhel4.5:192.168.137.200 GLOBAL_NAME=STRM. LK ORACLE_SID=STRM 1. Full Backup Source Library $ Sqlplus '/as sysdba ' Note the SCN before the backup,

Data Buffer Hit ratio# The hit rate of the data block in the data buffer, usually should be above 90%, otherwise consider increase db_block_buffers (9i above but db_cache_size) Buffer nowait ratio# The wait rate in the buffer to get buffer

Called a Oracle local Registry (OLR): Each node in a cluster has a local Registry for node-specific Test one: Simulate OLR abnormal loss: Here first will OLR Renam [Root@vmrac2 cdata]# MV VMRAC2.OLR Vmrac2.olr.bak And then try to start CRS.

Why do you want to migrate? First from the operating cost considerations, with MySQL can save a lot of money. On the other hand, MySQL stability and function constantly improve and enhance, basically can meet customer needs, such as support

Oracle's 11GR2 version does not make much of a change to the data pump, mainly by adding support for the original version parameters and removing some small restrictions. This article introduces the data pump to import the new data_options

Case 3: (Recover tablespace, database open state) --database Recover data files in open state (except system tablespace) (1) Simulation Environment: 06:10:52 sql> INSERT INTO scott.t01 values (4); 1 row created. 06:13:12 sql> INSERT INTO

Recently summarized the database paging SQL normally used in the project. You can post more efficient SQL statements with paging. SQL Server paging     First Paging method   required parameter:    pagesize How many data   per page;   PageNumber