Oracle Performance Myths--mts,rac, partitioning, parallel queries
To improve performance, we've done a lot of testing on the methods or scenarios that the Oracle database itself providesMainly include:Shared server mode (MTS)Cluster technology
This connection is often used in early query statements, which is a small problem. Therefore, I checked the information and summarized it as follows:
External connections are easier to understand,A. It is generally used in some classification
Compare SQL Server, Oracle, and DB2
I. Openness:
SQL ServerIt can only run on windows without any openness. The stability of the operating system is very important to the database.The Windows9x series products focus on desktop applications,
Because the database SQL statement in the major products with "dialect", that is, SQL Server Sybase are using T-SQL, MySQL is using standard SQL, Oracle has its own PL/SQL. Due to the differences in dialects, many SQL statements are difficult to
If the Oracle database hang crashes, system dump or hang analyze is performed on Oracle, which is an effective way to study and solve the problem. If you can connect to the database and perform operations, using oradebug is a simple and quick
I have prepared several documents about Oracle patch installation, as follows:
Introduction to Oracle patch system and opatch tools
Http://blog.csdn.net/tianlesoftware/article/details/5809526
New Features of Oracle 11g -- online patching (hot
Oracle logical database structure Overview
Database space allocation units:Data Block, extent, and segment).
Specific concepts can be seen: http://hi.baidu.com/feixianxxx/blog/item/8d5429028d05dc091d95838a.html
I want to write a fewNotes:
1.
Differences between the four statements of Oracle backup recovery and recover Database
11:27:48 | category:Oracle backup recovery | label:| Large font size, medium/small subscription
1 recover database using backup controlfile2 recover
How to Use rowid in Oracle to find and delete duplicate records in a table
From: csdnDuring normal work, you may encounter a system prompt ORA-01452 when you try to create a unique index for one or more columns in
SQL * loader is a tool used to import external data from Oracle databases. it is similar to the load tool of DB2, but has more options. It supports variable loading modes, optional loading and multi-Table loading.
How to use SQL * LoaderWe can use
Install Oracle 9.2.0 in Linux as 2.1
As early as in the Forum, many colleagues praised how Redhat as 2.1 was easy to use and never had a chance to try this trendy environment. Since the Oracle OCM test environment is also RH as 2.1, I want to
1
Oracle L3 permission system [review]
1. Oracle's permission system is divided into three levels: Role role, system, and object. The following is a simple description: Ü Object Privilege is the minimum granularity object of the
In large-scale project development, common databases are Oracle databases. However, an Oracle client requires a large disk. After installation, two functions are basically used: TNS Configuration Service name and sqlplus. During development, toad
In the past decade, Oracle has become one of the world's most professional databases. For IT experts, it is to ensure that their company's productivity is improved by leveraging the powerful features of oracle. One of the most effective methods is
1. Forget the logon password of a user except sys and system.Log on to the conn sys/pass_word as sysdba as a sys (or system) user;Use the following statement to modify the password: Alter user user_name identified by newpass;Note: The password
The new generation of Oracle will add many exciting new features. The following describes some new features of oracle11g.1. Database Management · Database Replay) This feature can capture the load of the entire data and pass it to a test database
1. What is registration?
Registration is to register the database as a service to the listener. The client does not need to know the Database Name and Instance name. It only needs to know the service name provided by the database to external users
Why is it so difficult to find a good Oracle DBA?
This is not only the pain of many CIOs, but also the problem that many IT directors cannot solve. But where do so many people who have obtained OCP certification from ORACLE training courses
Part 2 value type§ 2.1 numberThe Number type is oralce numeric, and the precision of the stored numeric value can reach 38 BITs. Number is a variable-length type with a length of 0 to 22 bytes. Value Range: 10e-130-10e 126 (not included)Number (p, s)
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service