Oracle

Oracle Data Import Export IMP/EXP Features: Oracle data Import Export IMP/EXP is equivalent to Oracle data restore and backup. In most cases, you can use an Oracle data import export to complete the backup and restore of your data (without causing

Reduce disk IO IO for distributed disks 1, the table space using local management, the file spread to different devices 1 separate the data file from the log file 2 Reduce server-independent disk IO 3 Evaluate the use of bare equipment 4)

1, the establishment password file, uses in the SYS user remote login authentication (remote_login_passwordfile=exclusive), the position $ORACLE _home/dbs/orapwsid. Create command: ORAPWD [Oracle@work dbs]$ orapwd File=orapwprod password=oracle

1, Application development (application Development) Sql*plus E:\Oracle\Ora81\BIN\SQLPLUSW. Exe 2. Database management (DB administration) DB Configuration Assistant Database Configuration Assistant: Creating, configuring, and deleting Databases

Pga The PGA (Program Global region area) is a memory area that contains data and control information for a service process. It is created by Oracle at the start of a service process and is unshared. An Oracle process has a PGA memory area. A PGA

We used the Oracle materialized view incremental refresh mechanism to synchronize the data of a table on database A to another database B on a regular basis. The simplest implementation step we often use is this. First, confirm on database A that

In Oracle 10.2.0.4 database, there is a slow SQL execution, more than a few minutes without results, waiting for the event is idle Sql*net message events, and finally forced to break. This SQL is an ordinary UPDATE statement that has multiple

Oracle's flash-back functionality restores a specified table in the event of an incomplete recovery of the database. The flashback database is a new method for point-in-time recovery, which enables you to quickly restore Oracle to a previous time to

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,

Oracle's security is divided into four parts, namely user management, access control, data protection and monitoring, specific reference to the [Oracle] Database Security Overview http://blog.csdn.net/u010415792/article/details/9008089 One of the

If Oracle unfortunately encounters undo corruption in operation, the best approach is full recovery, but if there is no backup, you can take an unconventional approach (taking advantage of the hidden parameters of Oracle) and if undo contains

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 MySQL Enterprise Section Thread_pool_algorithm: Connection concurrency scheduling algorithm, the default value of 0 using a conservative low-level concurrency algorithm, tested performance results are good. A value of 1, the concurrent

The two days to restore Oracle really headaches, my environment is cenos5.3+oracle11g, the official server's database instance path is:/app/oracle/oradata/databar, originally only backed up the files in this

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: /*+

Experiment Description: (1) Create 2 table spaces first. Create Tablespace User01 DataFile '/opt/oracle/oradata/ocp/user01.dbf ' size 1M; Create Tablespace User02 DataFile '/opt/oracle/oradata/ocp/user02.dbf ' size 1M; (2) Create a table on

Several project groups have already started using Oracle's Full-text indexing. Oracle's lexical analyzer is not smart enough for the lexical analysis of the ZHS16GBK character set, and can only be mechanically matched to the word unit. There is a

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

It's hard to know what the reason is when a system slows down in performance. Is it a memory leak, a disk subsystem bottleneck, or a specific application that has limited scalability? There are ways to discover and understand the root cause of