Oracle

Oracle upgrades from 10g to 11g detailed steps database old version: 10.2.0.4 Database new version: 11.2.0.2 OS Version: Solaris 10 Reference Documentation: Complete checklist for Manual upgrades to 11GR2 [ID 837570.1] Part I-Installing 11GR2

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)

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

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

To_char ();--Convert to String To_number ();--Convert to numeric type To_date ();--Convert to date type 1. Common Mathematical operation function ABS (Value): Returns the absolute value of Ceil (value): Returns the smallest integer greater than

Oracle Insert SQL table JSP Consulting Rowid and rownum are called pseudo columns, but they exist in a different way, Rowid can be said to be physically present, representing the unique location ID recorded in the tablespace, unique in db. As long

In the SQL statement optimization process, we often use hint, and now summarize the use of Oracle hint in the SQL optimization process: 1./*+all_rows*/ It is shown that the cost-based optimization method is chosen for the statement block, and the

Content based on LMT management of the table space, the dictionary management has not been used. This article mainly validates these questions: 1.LMT managed tablespace, there are two ways to allocate the area: System allocation and uniform fixed

Oracle Data Guard Linux Platform Physical Standby Build example Data Guard Environment: Operating system: Redhat 4.7 Primary database: IP address: 10.85.10.1. Database SID:ORCL Db_unique_name:orcl_pd Standby database: IP Address: 10.85.10.2

Oracle MySQL Enterprise Section Thread_pool_algorithm: Connection concurrency scheduling algorithm, the default value of 0 using a conservative low-level concurrency algorithm, tested performance results are good. A value of 1, the concurrent

The two days to restore Oracle really headaches, my environment is cenos5.3+oracle11g, the official server's database instance path is:/app/oracle/oradata/databar, originally only backed up the files in this

Parallel: Divide a work into several pieces and divide it into different processes and process them simultaneously. Process level Concurrency: Multiple sessions are accessed at the same time, which is usually the number of concurrent numbers.

Most of the time, because ASM does not start properly, data loss is caused. Here are two ways to retrieve data files from ASM I. Using the AMDU tool Amdu is a free tool in Oracle 11g that analyzes the metadata of the ASM Disk group and extracts

1. Installation of Oracle 10g R2 software2. To play Oracle 10g the latest patch, I'm playing a patch to upgrade to 10.2.0.23. Run pre-upgrade information Tool. It is used to analyze some of the things you need to do before you upgrade to 10g, such

2.1 Operational Requirements 1. Process and memory requirements The need for more processes Allocation of large pools 2. Basic Environment variable Demand Oracle_sid, Oracle_home, PATH, Nls_lang, if you use a time based backup and restore

I've often seen people ask this question, I've set up multiple indexes on the same table, why does Oracle choose one at a time and not use multiple indexes at the same time? Generally speaking, the common access to the same table more than two

Absrtact: Oracle database is one of the most widely used large-scale databases, and its optimization is directly related to the operation efficiency of the system. Based on the basic principle of database performance optimization, this paper

We have a problem with & variable assignment today. Declare UID number (10); Begin uid:=&x; End When &x entered as the empty times the following error ORA-06550: Line 5th, column 9th: Pls-00103:encountered the symbol ";" When expecting one

1. What is Audit Auditing (Audit) is used to monitor database operations performed by a user, and an audit record can exist in a data dictionary table called an Audit record: The SYS stored in the system tablespace. aud$ table, available through

The recovery of a missing database file depends to a large extent on the backup strategy used. Based on the flexibility of recovery, this paper discusses the backup and recovery strategy of Oracle8 database, and gives the project development example