Case study (1)
Let's say I modified a piece of data: Update people set name= ' Fusnow ' where name= ' old Fusnow ';
The things I need to do include:
Generate redo information in redo log buffer (including Redo,undo redo of the table, index or
Oracle's online segment contraction (on-line Segment Shrink) refers to the online defragmentation of fragments in the space, which has the following characteristics:
Online, that is, DML is almost unaffected during segment compression (only a short
In the Oracle database of some win systems, it is known that Oracle needs to start the service before it is started, but occasionally there are two requirements:
1. Start the Oracle instance service, but do not want to start the database instance
Specific error
Java.sql.SQLRecoverableException:Io exception: The network Adapter could not establish the connectionAt Oracle.jdbc.driver.SQLStateMapping.newSQLException (sqlstatemapping.java:101)At Oracle.jdbc.driver.DatabaseError.newSQLException (
The basic task of a database is to store and manage data, and the only database feature that an end-user can see is its performance: how quickly the database processes the results of a given query, and returns the results to the tools and
The basic Concept Character set (Character set): is a collection of all abstract characters supported by a system. Characters are the general name of various words and symbols, including the national characters, punctuation marks, graphic
oracle| Process | system
(i) Memory structure and process structure the overall structure of the Oracle database is shown in the following illustration:
1:oracle instance (Instance)In a server, each running Oracle database is associated with a
oracle| strategy
What is Oracle's strategy for Linux?
Oracle fully supports the Linux operating system. In fact, Oracle is the first commercial database available for Linux. By using Oracle's industry-leading offerings to support Linux, we can
Oracle 1. What is called a bare device?
A bare device, also called a bare partition (raw partition), is a special character device that is not formatted and is not read by UNIX through a file system. It is the responsibility of the application to
Oracle| Error | resolution
Analysis and resolution of Oracle Common Error codes (III.)
The article originates from the century easy net
Ora-00600:internal error code,arguments:[num],[?],[?],[?],[?]
Reason: This error is usually an internal
A session can start multiple transactions, which are sessions, meaning one connection at a time.
A transaction is a unit of action that either succeeds or fails and has no intermediate state.
Multiple transactions can be completed in a session.
The general To_char is such a to_char (Sysdate, ' yyyy-mm-dd hh:mi:ss am '), and there are several points of use for the book
To_char (sysdate, ' DD ') see what date it is today
To_char (sysdate, ' ww ') view this is the first few weeks of the
1. Stop the mouse in the SQL row, and then Ctrl+enter directly execute the current SQL.
2. Solve Toad to Chinese display garbled problem:
System environment variable plus nls_lang=american_america. We8iso8859p1
3. Toad Automatic prompt function,
Some time ago in a migration of data pump and exp, found that the difference in efficiency is quite large. Here is an example of a simple comparison.
This article discusses the most important factors that affect the performance of data pump imports.
There are also many ways to search for text in an Oracle database without using the Oracle text feature. You can use the standard InStr function and the LIKE operator.
SELECT *FROM mytext WHERE INSTR (thetext, 'Oracle') > 0;
From: http://www.3lian.com/edu/2013/08-03/86558.htmlAfter successfully installing the Oracle 11g database, you will find that your computer is running slower, that your computer is running faster with a lower-profile PC or even a very card-enabled
1.where cannot be placed behind group by 2. Having is used together with group by, placed behind group by, at this time the function is equivalent to the where3.where behind the condition can not have aggregation function, such as SUM (), AVG (),
1 Recover database using Backup Controlfile2 Recover database until cancel3 Recover database using Backup controlfile until cancel;4 Recover database until cancel using Backup controlfile;This article mainly introduces the following four kinds
The time for all nodes must be synchronized, which is usually achieved by configuring the NTP server. If the user already has a time server in the network, then all nodes can point to it, otherwise you can pick a node from the cluster as the time
qt-win-commercial-src-4.3.1, qt-x11-commercial-src-4.3.1Microsoft Visual C + + 6.0, KDevelop 3.5.0Windows Xp, Solaris 10, Fedora 8SQL Server, Oracle 10g Client, driver compilationThere are two database drivers to be mentioned here, namely ODBC 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