Oracle

In the previous chapter, we will describe how to add table partitions in Oracle. Now we will describe how to shrink table partitions (coalesce partitions) in Oracle. Oracle compresses table partitions to apply to hash partitions or hash

The following article mainly introduces the experience of learning Oracle databases. The reason why Oracle databases can be widely used in a short period of time is its unique function. The following describes the specific solution. We hope this

We all know that database-related data is ultimately stored on the relevant physical disks. In fact, the common way to access data is to read and write these physical disks, therefore, the optimization of these physical storage is an important part

There are many Oracle Performance Tools. I accidentally saw Metalink Note (438452.1): Performance Tools Quick Reference Guide mentioned in Tanel Poder on a website. This document is indeed quite new, and there are several tools worth noting.

In the previous article, we introduced the design stage and the running stage of the Oracle database in the performance optimization technology of the actual Oracle database operations, the following article describes how to adjust the database

In the developer environment, the application developer will work with the database administrator to design a logical backup policy. There are usually two copies of the database. One is the finished database, and the other is used by developers to

Variables are used to store values. They have names and data types. When declaring a variable, you can also specify its data type. All variables have data types to determine which data can be stored. Data Type datatype) is a column) or an attribute

By using the Oracle Data dictionary technology, database developers can better understand the full picture of the database, which is of great help to database optimization and management. The Oracle Data Dictionary stores database information in

We all know that many enterprises have a lot of Oracle Database-related platforms at the same time, and each Oracle database-related Platform runs at the same time, one or more sets of practical applications. As the business of an enterprise

The problem we often encounter in actual operations is that in Oracle, the actual status has been set to "killed ", however, the process locks related system resources for a long time, but does not release it. We recommend a better way than

We all know that there will be many similar problems in Oracle database applications. This may be due to performance or other reasons. We need to change the tablespace of the relevant table or all tables of a user. The common practice is to first

By studying databases and instances, we can know that the Oracle architecture can be divided into three categories: the internal structure of the database (such as tables), the internal structure of the storage area includes the shared storage area

We all know that Blob in the Oracle database is a special field, which has better performance than the long field. Its main function is to save binary data such as images. The following describes the main content of the article. Writing Blob fields

The following article describes how to export and import the Oracle database exp imp to related instances by users. The first step is to export all objects of the user Test1 from A windows server, then import it to the Test2 user on linux Server B.

In Oracle databases, how does one pass variables from SQL * plus to shell? In practice, many people encounter such problems: sqlplus cannot pass variables to shell. Here we will introduce an instance script for compromise processing.

The following article mainly tests the way Oracle data is obtained. First, we establish the relevant experimental environment. The following is an example of the relevant experimental environment, if you want to have a better understanding of how to

The following articles mainly introduce the escape characters of Oracle escape and the actual usage and definitions of the Oracle escape keywords, we all know that the Oracle escape keyword is often used to make certain special characters, such as

We will mainly introduce the actual usage of the character truncation function of Oracle Substr. This article mainly introduces the actual operations of the character truncation function of Oracle Substr by using the Code related to its actual

The following articles mainly introduce the display of Date input in Oracle struts2. We all know that the default date output in Oracle struts2 does not match our Chinese-related habits, below are several methods I know to format the date output in

The following articles mainly introduce the relevant issues that need attention in Oracle RAC configuration. We all know that there are articles related to Oracle RAC configuration on many websites. However, these documents seldom successfully