Oracle

Today, a bug was found in the data pump import operation. The previous article recorded the phenomenon of the problem, and this one continues to be studied in depth. The previous article has described the problem, and it is difficult to reproduce

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

Oracle 11g Dataguard Duplicate physical standby configuration (i) Create configuration for physical repositories # ver:1.5 Fifth time modified # modify:2013.8.16 # Author:koumm Description The installation of this article is configured with

OMF, the full name is oracle_managed files, that is, Oracle file management, the use of OMF can simplify the management of the administrator, do not specify the name of the file, size, path, its name, size, the path is automatically allocated by

Oracle 10g + REDHAT5, install use all normal, install user Oracle. Starting Sqlplus with an Oracle user is normal today [Abc@rhel4 admin]$ Sqlplus/as SYSDBA Sql*plus:release 10.2.0.1.0-production on Thu Apr 23 12:11:25 2009 Copyright (c) 1982, +,

Autoextend extension The physical files of an Oracle database can be set to an automatically growing type, so that when the database needs more space, the physical files are set Automatically grows to the specified maximum value. This has some

In the previous article, we introduced the most important document in Sql*loader--control file, this article is about the most important part of the control file-the field list, the role of the field list is to the data file records and the database

Import Mode As with the export mode, the following 5 modes are mutually exclusive. Full mode Set Full=yes, if there is no datapump_imp_full_database role, can only be imported into the data under their own schema Schema schema Sets the schema

The specific configuration of Oracle load Balancing is described in detail in this paper. Through the client and server side of the configuration, the text of the code is more comprehensive, worthy of reference. For professional data-processing

The collection of Pl/sql languages is similar to arrays and is a necessary structure for managing multiple rows of data. A set is a list that may be ordered or unordered. The Pl/sql collection types are: union arrays, nested tables, and variable

Java Interface with Oracle: Running Java in a database can be said to be the most exciting new feature of Oracle8i. In the application you created to use the Oracle8i database, you can use new Java-related features to easily publish programs to the

Although Oracle's deterministic statement is intended to ensure the certainty of functions, it can be used to raise performance when used rationally. This article describes the effect of parameter order on performance. In the previous article, it

Scenario: Temporary table space Full, unable to release The solution is summarized as follows: --1 Create transit temporary table space Create temporary tablespace temp02 Tempfile '/oradata/crpt_temp_tra.dbf ' Size 20G reuse autoextend on next 1

First, dynamic monitoring 1. Listening for files [Oracle@node1 admin]$ More/u01/oracle/network/admin/listener.ora Sid_list_listener = (Sid_list = (Sid_desc = (Sid_name = Plsextproc) (Oracle_home =/u01/oracle) (program = Extproc) ) )

Case 1: Database most datafile lost (recover db, must be under mount) 1) test environment 07:21:12 sql> Conn Scott/tiger Connected. 07:21:16 sql> 07:21:16 sql> SELECT * from tab; Tname Tabtype Clusterid ------------------------------ ------- -

Oracle database and SQL Server database are two commonly used databases, in the industry, Oracle database security is generally considered to be higher than SQL Server database, but the actual Oracle database and SQL The server database has how the

1, the meaning of the backup 1 protection of data, to avoid loss of data due to various failures 2. Introduction to Basic terms Mean Time Between Failure--MTBF Mean Time to Repair--mttr Mean Time to Failure--mttf (1) The mtbf--full name is

For the default installation of the HR architecture, the console output shows the fields (separated by semicolons) for each record in the two records of the employee 101: 101;9/21/1989 12:00:00 am;10/27/1993 12:00:00 AM; ac_account;110; 101;10/28/1

Among the many Oracle-related issues, one of the most important is the buffer busy wait (buffer busy waiting) event. Buffer busy waiting is the most common phenomenon in i/o-bound Oracle systems, especially in the first five busy read

In 11GR2, Oracle analysis functions are further enhanced. This article describes the analysis function lag and the enhancement of the lead. The 11GR2 lag and lead functions are enhanced to add ignore Nulls functionality. Sql> select * from