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 articles mainly introduce Oracle SQL Performance Optimization adjustments summarized by Oracle statement optimization rules, including how to select an appropriate Oracle optimizer and descriptions of shared SQL statements, the

SYS and SYSTEM are two accounts installed by default for each Oracle database. SYS mode is the owner of all internal database tables, structures, supply packages, processes, etc. It also has all V $ and data dictionary views, create all encapsulated

Port Oracle to mysql. In actual operation, we often encounter the following problems. Today, we have come up with these problems and hope to provide relevant references for computer users who encounter the same problems. If we pay attention to

This article mainly introduces the relationship between the Conversion Function in the actual application of Oracle time and the actual operation of date, we all know that the greatest correlation between the Conversion Function and the actual date

The following articles mainly focus on the relevant empirical principles frequently used in Oracle database systems. This article introduces these principles in six parts, including the usage of having clauses, external join "+" and how to delete

We all know that the Oracle listener is actually a server-based Oracle service and belongs to the network service. Its main function is to listen for connection requests from the client to the database server. Since it is a server-based service, it

The adjustment of Oracle RAC performance is mainly to adjust the actual application size through CPU and wait time, as well as the specific adjustment of RAC, and descriptions of the relevant actual operation solutions, the following is the

If you want to transfer massive Oracle data (more than 80 Mb) to another user or related tablespace in actual operations. We recommend that you use the following methods to quickly transfer data. That is, the method for creating a new table and the

Are you familiar with Oracle character types? Today, we will summarize it, including CHAR, NCHAR, LONG, VARCHAR2 (VARCHAR), and NVARCHAR2 Oracle character types. The following articles describe these types in detail. CHAR, an Oracle string that

The following articles mainly introduce the efficiency issues related to Oracle query records. As I recently want to optimize the efficiency of Oracle databases, therefore, many highly efficient methods for determining whether a record exists are

The following articles mainly introduce the contents of SCN and TimeStamp in Oracle 10g. We all know that in Oracle 10g, the function is used to convert the SCN and timestamp to improve the flash back operation. This article uses an example to

What are the actual steps to use the Oracle 10g column value MASK technology to hide sensitive data? The database features related to the Virtual Private of Oracle databases are also known as fine-grained access control) provides row-level security

We all know that the data table's huge import leads to a reduction in the query speed. Therefore, we only need to remove the data from the relevant data table. However, if we use Oracle delete, the data has been deleted, but the speed has not

The following articles mainly introduce Oracle performance adjustment and several methods to reclaim tablespace fragments. First, we need to use the compress = Y parameter exp for the relevant tablespace, after truncate the table, import the table

The following articles mainly introduce the content of the Oracle query table name and table column name, as well as the code of its actual application, if you have a desire to understand the relevant content of this article, the following describes

We all know that the remote Oracle tnslsnr server is generally not configured with the relevant password. If an attacker finds this risk, to disable the Oracle tnslsnr server or set a new password, which will affect the normal use of legal

The following article mainly introduces the Oracle function decode. We all know that the decode function compares this value with a series of related sequence dolls in c to determine the final returned results. The so-called sequence even, in short,

The following articles mainly describe the Oracle sqlplus command in detail. We will first talk about Oracle startup and shutdown. If you are a computer enthusiast, I believe the following articles will help you in this regard. Hope you will have

The following articles describe how to correctly connect to Oracle databases. If you are a beginner in Oracle database application, you can use the following articles to have a better understanding of the two basic methods for connecting to the