Oracle data recovery from the recovery type, cast aside the specific files, the total can be divided into two major types of recovery, one is full recovery, one is not full recovery. In fact, once you are familiar with the Oracle architecture, there
One, the spy of the binding variable (PEEK)
1, Oracle in the processing of SQL with binding variables, only in hard parsing will "pry" the value of the binding variable in SQL, and then based on the value of the detected to determine the entire SQL
The ha of RAC is one of its big selling points, and Oracle often does it to advertise, but in fact, RAC is not really ha, because it is a share-disk architecture, only instance-level ha. The technical basis of the RAC instance-level HA is failover,
In Oracle, not as convenient as MySQL, can be directly on the User IP restrictions, Oracle to implement user-level IP restrictions, you can use triggers to bypass the implementation, the following is an example of a trigger:
Create or replace
Oracle is still more commonly used, so I studied Oracle COMMIT, here to share with you, I hope to be useful. The user can issue a commit,oracle commit trigger LGRW only if the last block of all rows affected by the SQL statement is read into DB
Due to licensing issues, Oracle Java is no longer included in newer Linux distributions and replaced by OPENJDK. So is Ubuntu.
OpenJDK can meet most of the application's operating conditions, but Pycharm cannot run under openjdk conditions, so you
Sql> Show All--View all 68 system variable values
Sql> Show user--Displays current connected users
Sql> Show Error--Display errors
Sql> set heading off--Suppresses the output column header, the default value is on
Sql> set Feedback
oracle| Process | data | database
Oracle 9i Database Migration process
Author: unknown
Database movement, often occurs during the implementation of a project, and for experienced DBAs, database movement is very easy. But for some people who only
Oracle
How to present Oracle's relative functions in DB2 (III.)
Author:ccbzzp
In reality, you may often encounter some of the functions of Oracle in DB2,
Here I simply conclude that there may be many ways in which a function can be found, not all of
Oracle
Experience Summary:
The online logs are divided into current and non current online logs, and the corruption of the non-current online log is relatively simple, and the problem can be resolved by the clear command.
Corrupt non-current
Oracle Virtual field 133. Currval and Nextval Create a sequence created SEQUENCE empseq for the table ...; SELECT Empseq.currval from DUAL; Inserts the numeric values of the sequence into the EMP values (empseq.nextval, ' LEWIS ', ' clerk ', 79
oracle| Performance | optimization
31. Force Index Invalidation
If two or more indexes have the same level, you can force the Oracle optimizer to use one of them (through which the number of records retrieved is low).
Example:
SELECT
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
Introduction
In. NET applications, there are many ways to achieve access to Oracle databases. However, from functional and performance analysis, Oracle Data Provider for. NET (odp.net) is undoubtedly our best option, a set of interfaces designed by
Oracle connections are common for processes with Local=no parameters or with Local=yes.
Local=no: Not a local connection, that is, a network connection. It is connected to the server through listener. The client's application listens to the server
And then, in the previous example, set up two indexes on the table:
Sql> CREATE INDEX Ind_t_owner on T (OWNER);
The index has been created.
Sql> CREATE INDEX ind_t_id on T (object_id);
The index has been created.
For full table scans, use the
Oracle's 11GR2 version does not make much of a change to the data pump, mainly by adding support for the original version parameters and removing some small restrictions.
This article introduces the data pump to import the new data_options
Query initialization parameters A lot of ways, such as show PARAMETER, or query V$parameter, here a brief summary.
This article describes the necessity of gv$spparameter parameters.
The previous article describes the V$spparameter parameter and
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