Oracle

With Oracle's standby technology, a single-instance database can be upgraded to a RAC database. This approach can effectively reduce the downtime for single instance migration to the RAC environment. This article describes the errors encountered

Case 1--restores a table in the past at some point in time 1, based on the point of time Sql> Select Username,scn,timestamp,sql_redo from v$logmnr_contents where seg_name= ' TB01 '; USERNAME SCN TIMESTAMP Sql_redo --------------- ---------- -----

Oracle databases, as a product of managing data, must be able to recognize the administrative commands (often called SQL statements) submitted by the user to respond. The process of recognizing is called the process of parsing an SQL statement, and

An Oracle stored procedure consists of three parts: a procedure declaration, a procedure part, and a stored procedure exception. Oracle stored procedures can have parameter-free stored procedures and parameter-stored procedures. Procedure syntax

How the procedure is called Declare Realsal Emp.sal%type; Realname varchar (40); Realjob varchar (40); Begin//Stored procedure call start realsal:=1100; Realname:= '; realjob:= ' clerk '; Runbyparmeters (Realsal,realname,realjob); --Must be

For log buffers, the settings are too small to cause log buffer space to wait for events. But it's not that the bigger it is, the better it is, because the LGWR process will constantly start refreshing the log buffer to free up memory, so it may not

A user wants to delete the table space of the database, first the user to have the permission of the drop tablespace Execute the following statement under the current user to query for confirmation Select A2.username,a1.privilege from

Importing imported Oracle Partitioned table data is one of the tasks that Oracle DBAs often complete. Import of partitioned tables exports the same normal table import Export method, but import export need to test Consider zoning specificity, such

Physical Standby and logical standby Log application services are divided into two types, one is the physical standby redo applications, similar to media recovery, its advantage is fast, but 10g case standby must be in the Mount State, Unable to

CRS provides a number of commands to manage and view the status of the Cluster service, commonly used in Crs_stat, Crs_start, Crs_stop, CRSCTL, etc., which are described in turn. 1, view the status of the cluster The Crs_stat command allows you to

1. Definition Package: (1) A collection of related objects that are grouped together, and the package is loaded into memory when any function or stored procedure in the package is invoked. (2) The subroutine access speed of any function or stored

The basic usage of grouping functions is described earlier, and several more advanced uses of group by are described below. 1, rollup in Oracle database with the GROUP BY command, you can provide summary of information functions (similar to

Today found an Oracle test library of the set of incorrect character sets, the original character set is UTF-8, the correct character set should be ZHS16GBK, because UTF-8 is a ZHS16GBK superset, can not modify, can only rebuild the database,

1, the control document function and characteristic 1 Define the current physical state of the database 2 Maintain data consistency: if the checkpoint in the control file is consistent with the data file, the data is consistent and can be started

Control file Diversity: Copying multiple control files and putting them on different disks. 1, the use of SPFile diversified control documents 1) View Control file information and spfile information 05:55:48 sql> select name from V$controlfile;

When we look up the Chinese dictionary, we can quickly find the word we are looking for because the dictionary is indexed. Similarly, in order to get data efficiently, we need to index a column in a table when the volume of data is large. The role

Software Environment: 1. Operating system: Windows Server 2. Database: Oracle 8i R2 (8.1.7) for NT Enterprise Edition 3, Installation path: C:\ORACLE Implementation method: 1, D:\>set Nls_lang=american_america. USACII7 Or D:\>set

Summary: In this paper, an Oracle Job task exception case diagnosis, analysis of its causes and the resolution process, from the internal disclosure of Oracle job scheduling and internal timing mechanism. Problems and environment It was reported

A bad chunk of what is a database First of all, let's take a look at the format and structure of the database blocks--the data blocks of the database have a fixed format and structure, three-layer cache layer,transaction Layer,data layer. When we

Oracle can be equipped with more than one database, and only need to open a listener on it, for multiple databases as long as the appropriate service name can be configured to connect. I'm using Oracle 8.1.7 Enterprise edition,os is Windows Server,