Oracle

Oracle 10g "dataguard" log Transmission Mode1. Redo transmission: All online redo logs written to the master database are transmitted to the standby database by synchronously or asynchronously. If the standby redo log exists in the standby

In Oracle, data is generally stored in data files, but one of the biggest differences between the database and Oracle is that the database can be restored when data errors occur. This is our common redo file function in Oracle. The redo log is

During application development, it is common to sort data according to certain rules and then retrieve the first few data records. In Oracle, order by is commonly used to obtain data smaller than rownum. However, if you are not familiar with Oracle,

In Oracle, we may prefer to use the group by clause, but many people may not know that in the group by clause, we can perform super aggregate group search. At this time, we use two keywords, A rollup and a cube. Rollup is grouped from right to

E:/> exp help = y By entering the exp command and user name/password, you canCommand after user/password: Example: EXP Scott/Tiger Alternatively, you can control the running mode of "Export" by entering the exp command with various parameters.

Oracle provides a very useful clause check, which can automatically check data. It is used to create a table structure. For example: Create Table worker(Empno number (4) primary key,Name varchar2 (10 ),Age number (2) Check (age between 18 and 65 ),/*

1. Set the initialization parameter job_queue_processes.SQL> alter system set job_queue_processes = N; (n> 0)Job_queue_processes: the maximum value is 1000.　　View the Job Queue background processSQL> select name, description from V $ bgprocess;　　2.

How to start oracle in Linux: 1. Start the database instance: log on to the system, username, and password. Eg: Oracle/Oracle; sqlplus/nolog SQL> connect sys/password as sysdba to connect to the instance SQL> startup SQL> shutdown

We usually have no choice at the raid array level when deploying servers. RAID technology has grown into dozens of categories today, but there are only a few commonly used in production systems, for example, 0, 1, 5, 0 + 1. Readers may be familiar

Today, the developer asked me how to quickly and conveniently find the recently changed records of a table. This requirement is very simple. Because it is to check recently changed data, you can check the rollback segments, below is my small

Oracle series: Lob large object processing It is mainly used to store database fields with a large amount of data. It can store up to 4 GB of unstructured data.This section describes the storage of character type and binary file type lob data, and

Previous Article: Oracle series: Oracle Data TypesLink: http://blog.csdn.net/qfs_v/archive/2008/05/12/2435213.aspxOracle series: pseudo-column rowid 1. What is a pseudo-column rowid?1. First, it is a data type that uniquely identifies an ID of a

Oracle series: Record) 1. What is record )?A composite structure composed of scalar values of multiple columns in a single row. It can be seen as a user-defined data type. It is similar to a multi-dimensional array.Encapsulate one or more scalar

  13:52:44 | category:Hack everything! | Tag: Java RC Oracle bufsize int| Large font size, medium/small subscription  Recently, the Network speed is ungeliveble ...... "Internet access for all, never download BT !" This is the purpose of LAN!

The following installation procedures are verified. I. platform environment and software Ubuntu 10.04 sever Jdk6.0 Oracle11g (linux_11gr1_database_1013.zip) Xmanager 3 boardcast Mode Swap space needs 4 GB 2. Installing the dependent package is

    Oracle statspack and AWR are two important tools for analyzing databases. The statspack used by Oracle 9i has released AWR for 10 Gb. The data they analyzed is almost the same. Statspack installation and Report

    Oracle Data guard synchronizes data through archive files. The archive files of the master database can be deleted during RMAN backup, but the archive files of the slave database cannot be deleted automatically. You need to write scripts to

  *************** 1. Find the oraparam. ini file under the install directory and find the [Certified Version] node,Add 4.0 after # windows = 5.0, 5.1, 5.2, and 6.1, and then add the following content to the 5.2 node.After

In Oracle, if your data storage adopts the file format, you can log on to the Oracle host and find the database storage directory to view the database file information. However, if you do not know where the file is stored or the logon permission of

In the storage of Oracle data, you can think of the storage space as a reservoir, and the data as water in the reservoir. There is a line of water in the reservoir called a waterline. in Oracle, this line is called a High-warter mark (HWM ). When a