Oracle

1. Main Library Broker Configuration 1) Query Switchover status Sql> select Database_role,switchover_status from V$database; Database_role Switchover_status ---------------- -------------------- PRIMARY to STANDBY 2) Query Dg_broker_start

The portable tablespace is defined to move data from one db to another. The basic concept of migration is to remove the definition of table and table space from the data dictionary, copy the data files under the table space to the directory of the

Oracle User Management First, the concept of the user Users, or user, is a popular way to access Oracle database "people." In Oracle, the user's various security parameters can be controlled to maintain the security of the database, these concepts

The buffer cache settings are evolving as the Oracle version is upgraded. The Oracle 8i is set using Db_block_buffers, which represents the number of memory blocks that can be contained in the buffer cache, and the Oracle 9i is set using

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

The online log file status is active or current indicates that the data modifications that the log contains have not been fully synchronized to the data file, and that the redo record in which the instance will need to be read repeats itself, so if

In the previous section, "Data Guard series (2)-Log Transfer", we introduced the DG Log Transport service, the log Application service is introduced in this section after the log is transferred from the main library to the standby repository, and

I got a colleague asking for help today, saying that there is a select query that runs for more than a minute on Oracle, and he hopes to produce results within 5s, as follows: Select/*+ Parallel (SRC, 8) */distinct src.systemname as SystemName,

AWR's data consists of two main components: 1 The system load and performance statistics stored in memory, mainly through the v$ view query; 2 The Mmon process periodically saves in-memory awr data to the Sysaux tablespace in a snapshot (snapshot)

We all know that every SQL statement in Oracle needs to be parsed before it is executed, which is divided into soft parsing and hard parsing. There are two types of SQL statements in Oracle, one for DDL statements (data definition language), they

Oracle, platform, Linux, database, Archive,sql Operating system: Linux Redhat 4.7 oracle:10.2.0.1 Main Library: ORCL_PD Prepare library: LGDG A. Logical standby creation Process 1. Create Physical standby Specific reference: Oracle Data

Recursive calls the number of recursive calls generated by the user or system; DB block gets: The number of times the current chunk of data is requested; Consitent gets gets the number of redo blocks of data from the buffer cache; Physical reads

Although indexes are not always faster than full table scans, many times we want Oracle to use indexes to execute certain SQL, at which point we can force SQL to use index through the index hints. The format of the Index hints is as follows: /*+

(1) Hardware environment HP DL380 Server CPU 3.0*2 Memory: 4G hard drive: 100G (2) Software Environment Windows profession (the same way as a system using WINODWS XP 2003) Vmware GSX 3.0 (3) Installation VMware GSX 3.0 and a Windows profession

Our IDC core data area to the DMZ in the Thursday has experienced a very strange failure. Although I have judged the issue of non-Oracle from the outset, since the application of multiple Oracle databases connecting to the core data area has the

Oracle execution plans are not unfamiliar to us, and often we only look at the performance bottlenecks in our work and have no idea how the execution plan is generated. The following examples are used to simulate the evolution of data access and

Oracle partitioning and indexing can be said to be its own bright spot, and you might say there are other databases, yes, but Oracle's kind of performance convenience can be said to be more humane, the following we through the experiment to

Over the past decade, Oracle has become one of the most professional databases in the world. For IT professionals, it is important to ensure that Oracle's powerful features are used to improve the productivity of their companies. One of the most

If you use DBCA to establish a RAC database, the Remote_listener parameters are configured on each node by default, so the previous Test load_balance was tested in the presence of Remote_listener. Here is a test to remove the effect of

Configuration of the RMAN catalog database 1, the function of catalog database 1 centralizes the Rman database (the backed-up metadata) and can be synchronized with the target database Controlfile 2 The backup script that holds the Rman 2, the