Oracle

Multiple Oracle databases that are physically stored on the network can logically be viewed as a single, large database. Users can access the data in the remote database at the same time through the network. Collaborative processing between servers

We know that in previous versions of ORACLE10GR2, temporary files for temporary tablespace are not automatically restored if you use Rman to recover the database. This has caused a series of problems, many DBAs forget to add temporary files after

The highly available systems of 24*7 (some of which are also called 24*7*365) are becoming more and more widely valued and applied because, in the real world, uninterrupted systems represent uninterrupted, voluntary revenue. But How to build and

In the database, the functions of Redo are mainly implemented through 3 components: Redo log Buffer, LGWR background process, and Redo log file (in archive mode, Redo log files will eventually be written as archive logs). In Oracle's SGA, there is

Before running the example of this article, record the INSERT, delete, update, and so on of the current datasheet, and make a backup of the date of operation, the operator, the original data, and now the data so that you can recover from the current

Oracle 11g has added a lot of functionality to backup and recovery, with varying degrees of performance, functionality, security, and operability. This article describes the validation when Rman deletes an archive log. In the previous version of 11

Project situation: is a large company's internal office system, the system has two and the general enterprise application is not the same characteristics: first, the user is very much, the number of personnel reached about 2W, the other is the form

When building an Oracle database, you should see an option on the Database Setup Assistant Wizard, which is how the connection mode of the database is used. In oracle9i or 10g, you can see 2 connection modes, one called a dedicated server connection

This paper explores the internal mechanism of Oracle data buffers--oracle Use this memory to prevent unnecessary data blocks from being reread from disk. Understanding how Oracle Data buffers operate is key to successfully using them to tune

DML performance is low, one of the most serious reasons is the existence of useless indexes. All SQL inserts, updates, and deletions become slower when they need to modify a large number of indexes when each row of data is changed. Many Oracle

Recently done projects encountered ORA-01000 errors, reference to some solutions, to solve their own problems to write down some of the experience.Java accesses an Oracle database, and in the For loop code, if you omit the connection that was

From the composition of the SGA of Oracle, it is highly recommended to use parameter bindings. Using parameter bindings makes it possible to use the share Pool efficiently, which can significantly improve performance by not having to harden the

As a result of recent incidents of stolen backup data, more and more people are paying more attention to the importance of protecting data backup. The loss of an exported data disk containing millions of user data from banks, economic sectors,

Oracle9 startup times wrong ORA-00600: Internal error code, parameters: [Kcratr1_lostwrt], [], [], [], [], [], [], [] This may be due to illegal shutdown or power off, following are the problems and solutions: C:\Documents and

Oracle provides the Wrap tool to encrypt stored procedures, and in 10g this operation can already be done in the database. Oracle's DBMS_DDL adds a wrap function that allows you to return the encrypted process: Sql> Select Dbms_ddl.wrap (' CREATE

ASM supports not only the RAC environment, but also the single node environment. It has always been thought that a single node ASM also needs Clusterware support, and that in this case, starting ASM needs to be configured as a RAC one node approach.

The main function of the Ocrconfig tool is to back up and restore OCR. Although Ocrconfig can be run directly with Oracle users, most commands require the root user to have permission to execute: bash-2.03$ Ocrconfig Name: Ocrconfig-oracle the

With alert, the order in which the instance was recovered was found: 1. Roll forward 2, open db 3, Rollback (Note: smon:parallel Transaction recovery tried After Completed:alter DATABASE OPEN Smon:enabling Cache Recovery Mon June 13 16:50:50 20

Case 1: Delete user and all objects by mistake, restore 1 Create a user and assign permissions 06:14:01 sql> Create user Scott identified by tiger default tablespace users; User created. 06:15:55 sql> Grant Connect, resource to Scott; Grant

There are also some limitations to the recovery statistics operation, such as the inability to restore user-defined statistics. In addition, because the statistics are the property of the table, if the table is deleted, the corresponding statistic