Oracle

In this section, we build a slightly more complex replication environment, and this time we will no longer replicate between two databases, add a new database, and synchronize data between three databases. I. Description of requirements Set the

One, rollback (ROLLBACK) and undo (undo) Rollback and roll forward are important means of ensuring that data in an Oracle database is in a consistent state. Before the 9i version Oracle uses rollback segments in the database to implement

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

Oracle gives user authorization _oracle user authorization _oracle user authorization Grant (Authorization) command The following is the USER01 authorization for the user created, as follows: Grant Connect, resource to User01; (2) REVOKE (REVOKE)

One what is the Pmon process The Process Monitor performs processrecovery when a user process fails. Pmon is responsible to cleaning up thecache and freeing resources, the process was using. Pmon also checks on Thedispatcher processes (described

EXPDP's Network_link As we know, EXPDP the default is to export the local database, the Network_link is to export the remote database to the local server, and its steps are as follows: Terminology Description: SOURCE database: Remote

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) ) )

1. Table structure Sql> desc v$process is the name empty? Type ----------------------------------------- -------- ---------------------------- ADDR RAW (8) PID number SPID VARCHAR2 (12) USERNAME VARCHAR2 (15) serial# number TERMINAL VARCHAR2

Yesterday a friend asked me how to monitor the operation of a pl/sql, here is a brief introduction to several methods. Introduce a professional Dbms_application_info package. The previous article introduced a solution through inserts and

We typically install the Oracle database on Linux or configure the core parameters of the Linux system when replacing or upgrading the hardware, and then adjust the Oracle system parameters. The actual meaning of these parameters is what, why to

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

In the previous article I've talked about using synonyms to connect to Oracle under SQL Server 2005, and we can use synonyms to connect Oracle under SQL Server 2005 to real-time access to Oracle databases. However, if the table data stream in Oracle

Preface The growing demand for distributed applications requires a better distributed software environment, which drives the development of distributed technology. Oracle data replication is a technology for implementing distributed data

Oracle advanced replication, also known as symmetric replication. Unlike Oracle's other features, Oracle's advanced replication is not Plug and play, and users must have a deep understanding of how they work and the advantages and disadvantages of

An Oracle physical structure failure is a variety of database failures that result from corruption of each physical file that constitutes a database. These failures may be caused by a hardware failure or by a human error. So we first need to

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

Oracle's BLOB field type can be used to hold long 2 of data. But the code that reads and writes the BLOB field data is usually verbose, and it's easy to make mistakes when it's not carefully coded. I integrate this feature into my OCI packaging

Oracle Logminer is an actual, useful analysis tool that Oracle has provided from the product 8i, which makes it easy to get the details of Oracle Redo log files (archived log files), especially The tool can analyze all the DML (INSERT, UPDATE,

In Oracle database systems, There are two ways to authenticate users if they want to log on to an Oracle database as a privileged user (Internal/sysdba/sysoper): Authenticate with an operating system-integrated authentication or a password file that

Prior to the Oracle 8i release, the internal user was used to perform the database startup and shutdown, as well as create database operations; Oracle has been phasing out internal users since the 8i version, Users who are granted the SYSDBA or