1. Eliminate duplicate rowsIn the results of an Oracle query, there may be several rows in the same situation, so you can use distinct to eliminate duplicate rows.Code Demo: Distinct eliminate duplicate rows2. Null operationIf there is a missing
Today, when we suddenly recall Oracle's paging query, most of the cases are used:SELECT * FROM(SELECT a.*, ROWNUM RNFrom (SELECT * from table_name) AWHERE ROWNUM )WHERE RN >= 21Said to be efficient, but for the SELECT * FROM table_name This original
Oracle creates self-growth write sequences and write triggers, not as convenient as MSSQLSERVER. But it is also a hassle, recorded as follows:In Oracle, you can create a separate sequence for the primary key of each table, and then get an
[Email protected] ~]$ export ORACLE_SID=ORCL[Email protected] ~]$ Sqlplus/as SYSDBASql*plus:release 10.2.0.1.0-production on Mon Nov 10 23:04:36 2014Copyright (c) 1982, 2005, Oracle. All rights reserved.Connected to an idle instance.sql> startup
to put it simply, Oracle takes random numbers, mostly by calling Dbms_random packets, and there are roughly 4 ways to generate random numbers by Dbms_random packets: 1, Dbms_random.normalThis function does not take arguments, and is used to produce
Any action on a column can result in a full table scan, where the so-called operations include database functions, calculation expressions, and so on, to move the operation to the right of the equation whenever possible.Even remove the
The database link of a distributed database is one-wayDefining Database LinksCREATE DATABASE LINK [Db_link_name] CONNECT to[USER_NAME] identified by [password] USING ' [tns_name] ';[Db_link_name]: is the service name of the database to which you
1. View the values of the current two parametersSqlplus/nologSql>conn/as sysdbasql>select Count (*) from v$session; From here we can see the current session numbersql>select Count (*) from v$process; From here we can see the current number of
Proper use of indexes can improve the speed of data retrieval and can create indexes on fields that frequently require queries.Oracle's index is divided into 5 types: Unique index, combined index, reverse key index, bitmap index, function-based
To create a stored procedure:Syntax: Create [or replace] PROCEDURE procedure name (parameter list)AsPlsql Sub-program body;How to call stored procedures in two ways1. Execute (EXEC)------exec function name ()2. BeginFunction name ()End-------begin
Oracle performance optimization operations: Summary
These articles about oracle performance optimization can be used in combination with each other. In addition, various methods are closely related to each other.
This kind of connection is
PLSQL _ performance optimization Series 1 _ concepts and importance of statistics (concepts) and plsql Performance Optimization
2014-12-18 Created By BaoXinjian
I. Summary
Statistic is very important to Oracle.
It collects detailed information
Oracle Data Type
The core of the Oracle database is a table. The common data types used by columns in the table are as follows:CHAR (length)Stores fixed-length strings. The length parameter specifies the length. If the length of the stored string
Oracle index creation
You can use indexes appropriately to increase the data retrieval speed and create indexes for fields that frequently need to be queried.
Oracle indexes are divided into five types: Unique indexes, composite indexes, reverse
Oracle basic database backup and recovery, oracle Database Backup
I. Why data backup?
Main causes of data loss:
1. Media fault.
2. User error operations.
3. server crash.
4. computer viruses.
5. unpredictable factors.
There are four fault types in
Oracle cold backup
Prerequisites for cold backup:The operating system is the same. You can execute scripts from Win32 to Win64 and from Win32 to Win64.Procedure:A. view the control files, data files, and log files of the two instances.B. Disable
Oracle11g + CentOS6 + DG installation recordsBased on a practical operation record, this article describes how to use rman for Hot Standby to create a physical Active standby database of dataguard. In this way, the master database only needs to be
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