Oracle

Before we go through the incomplete recovery case walkthrough, we need to learn how to use the Logminer tool. The tool mainly digs the redo log to find out the DDL or DML operations made at a point in time (including: Point-in-time, DataBlock SCN,

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

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

In the previous chapter we practiced a streams synchronization of a single table, it looks very simple is not (if you feel complex, it is not because the streams itself is complex, but to configure the streams earlier preparation is more complex),

In the document, the partition's locking operation is performed before performing some operations on the interval partition. Unlike other types of partitioned tables, the partition of the interval partition table does not necessarily exist, and

The two concepts that are easily confusing for first-contact Oracle databases are Oracle instances and Oracle databases. These two concepts are different from instances and databases under SQL Sever, and of course there are similarities. Just in SQL

1. Simulate generating data source --Create a script Emp.sql "many of these formats will change, and then remember to execute another script to restore the original On.sql" [Oracle@work sqlldr]$ more Emp.sql Set Heading off Set Feedback off Set

Oracle databases are widely used in different geographies, so it is important for professional Oracle personnel to understand how network connectivity affects database performance. TNS provided by Oracle allows for allocation of traffic in each

The biggest difference between a SQL Server database and an Oracle database is the design of the table space. Oracle database pioneered the design concept of table space, which has made an indelible contribution to the high performance of Oracle

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

The DBA maintains a portion of the database that is often a concern when Oracle alert logs are in use. However, the alarm log is stored in the form of a text file, accumulating in chronological order of time, and Long, it is bound to cause the

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

In the large and Medium-sized database management system at home and abroad, there are more users of ORACLE as database management platform. Oracle is not only a database management capability or security is justifiable, but it is in the display of