oracle internals

Oracle redo complexity-oracle Core Technology Reading Note 3, redo-oracle I. Overview We know that in oracle, Every modification to a piece of data generates a redo (that is, redo, which records the modified content ). The purpose is to back up the modified data for future redo. Now there is a problem. Redo logs are ge

Because of the installation of Oracle 10G when there was a problem, and then asked roommates to send a copy of the Oralce 10g client installation package came up. It was possible to use Pl/sql, and then, in the case of a job need, to import an Oracle database backup from a colleague at a time, making IMP statement to import a 6550 error, the internet to check the reason is because the server and the clien

Tags: DBA RAM read-write management art SSE buffer temp tablespace UNIXReprinted from: http://blog.csdn.net/robinson_0612/article/details/5529239 An Oracle server consists of an Oracle instance and an Oracle database. That is: Oracle Server = Oracle Instance +

Some time ago I started to learn some basic knowledge about oracle. To facilitate exercises and operations, I installed an Oracle 10 Gb. After the installation is complete, the current database is directly deprecated. The card is terrible. The card can only be used for surfing the Internet. At that time, I was too busy to do anything else, so I never care about it. Together with the last Internet cafe. Thes

Method 1: As we all know, to connect to Oracle using PL/SQL, you need to install the Oracle client software. Have you ever wondered whether to directly connect to Oracle without installing the Oracle client? In fact, I always wanted to do this, because this client is so annoying !!! Not only will JDK be installed,

Label:Data Guard is a remote replication technology for Oracle, it has physical and logical points, but in general, it needs a separate system in a remote location, two sets of hardware configurations can be different systems, but the software structure of the two systems are consistent, including the software version, directory storage structure, and data synchronization (in fact, is not real-time synchronization), the two sets of systems as long as

Tags: file path off SQ server has a lock creat evo combo1.Oracle Default UserAccess to Oracle database only with a legitimate user accountOracle has several default database usersAll data dictionary tables and views in the database are stored in the SYS pattern. SYS users are primarily used to maintain system information and manage instances.Systems is the default system administrator who owns the internal

1.1DescribedGenerate a lot of "oracle_w000_9708.trc" and "ORACLE_W000_9708.TRM" under the "$ORACLE _base/diag/rdbms/$ORACLE _sid/$ORACLE _sid/trace" folder File.These files are generated too quickly. The Oracle root folder is running out of free space.1.2Possible causesThe possible reason for the "$

Oracle Oracle Product Services and Technology level introduction Many friends ask the genuine Oracle database products and pirated products are mainly different, in fact, from the product technology itself, the difference is not small, can download a database from the OTN website products, and then install the use of genuine and pirated the biggest difference i

1.1 symptom description authorized by common usersSysdbaFailed to log on to database with the permission. The system displays the following error message:% SqlplusAs sysdba SQL*Plus: Release 11.1.0.7.0 - Production on Thu Nov 26 14:28:11 2009 Copyright (c) 1982, 2008, Oracle. All rights reserved. ERROR: ORA-01017: invalid username/password; logon deniedHowever SysdbaIf you log on directly, the system prompts the following information: % Sqlplus/as s

About Oracle ASM instances About Oracle ASM disk groups About grouping and failure groups About Oracle ASM Disks About Oracle ASM files About Oracle ASM instances The Oracle ASM instance is built based on the same technology a

Label:Do indexes in an Oracle database need to be rebuilt on a regular basis? If you do not need to rebuild regularly, what is the reason? If you need to rebuild regularly, what are the reasons? Also, if you need to rebuild regularly, the indexes that meet those criteria need to be rebuilt. On this issue, there are a lot of controversy on the internet, but also always let me a little confused, because always a bit not the feeling of the truth, until l

Oracle learning notes first knowledge Oracle, oracle learning notes first KnowledgeDatabase Introduction A Database is a warehouse that organizes, stores, and manages data according to the data structure. SQL is the acronym of Structured Query Language (Structured Query Language.Definition 　　DatabaseTo put it simply, it can be regarded as an electronic file cabin

Oracle 10g To download Oracle, you also need to register a user name for your convenience. User: wangdetian168@gmail.com Pass: qwe123qweThe password is normal. You don't need to retrieve it.Every change is troublesome.If necessary, you can view the required information on the right. Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition fo

How to connect toad to Oracle without installing the Oracle client In the past, it was quite troublesome to install the Oracle client when connecting to Oracle. On the one hand, it was difficult to install such a large volume of data. Oracle seems to have provided in

Oracle particularly suited to effective tuning-the fact this database kernel is heavily instrument Ed (the famous "Wait Interface"), and because of that, you can obtain precise details about exactly what are slowing down Y Our application. Other databases, such as DB2 and Microsoft SQL Server, don ' t have this instrumentation (or at least it's not publicly acce Ssible) and therefore it's much more "hit and miss" with those platforms. A point that M

Oracle client + PLSQL Developer remote login to Oracle database, oracle client plsql Oracle databases have powerful functions and excellent performance. These advantages also result in a large amount of memory occupied by Oracle. To address this problem, how can we extract t

When Oracle is not installed on the computer, C # Calls oracle database and Oracle customer tools, The installation packages of Oracle are usually relatively large and time-consuming. If errors occur during the installation process, the installation may be quite annoying. At work,