Oracle

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

Oracle physical structure failure refers to the failure of various databases caused by damage to each physical file in the database. These related faults are mainly caused by hardware faults, and may also be caused by human error. Therefore, we must

The following article describes how to determine the location and status of the damaged redo log of an Oracle database, I hope that you will read the following articles to help you learn about the location and status of damaged redo logs of Oracle

The following articles mainly use the relevant Code to introduce the actual application of Oracle time. I saw the actual application of Oracle time on the relevant website two days ago, if you are interested in the actual operations, you can click

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

The following articles mainly describe how to create a stored procedure in Oracle, including related connections. In practice, the problems are worth noting, the following is a description of the specific solution. I hope it will help you in your

Oracle fine-grained access control (VPD) is a virtual dedicated cantalua database. Its main function is to provide very powerful row-level security. Oracle fine-grained access control is launched in Oracle8i and has been widely used in various

The following articles mainly describe how to export the relevant database in the Oracle database for automatic backup under UNIX. I believe many related system administrators are doing repetitive work every day, is to back up data. Once the system

I'm reading a Metalink Note (438452.1) mentioned in Tanel Poder about the Performance Tools Quick Reference Guide. This document is indeed quite new. It includes several Oracle tools and is worth noting. LTOM: The Lite Onboard Monitor Java program,

The following articles mainly introduce how to crack the Oracle password and forget it. In fact, it is very easy to forget the Oracle password, this article mainly introduces two related solutions: alter user username) identified by "password ". One

Three basic Oracle Number types of Oracle numbers: NUMBER, BINARY_INTENER, and PLS_INTEGER. The main function of NUMBER is to describe related integers or real numbers, but PLS_INTEGER and BINARY_INTENER can only describe integers. NUMBER is stored

Oracle Database permission systems can be divided into system permissions and object permissions. Database System Privilege allows Oracle users to execute specific command sets. For example, the create table permission allows Oracle users to CREATE

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.

The following articles mainly introduce Oracle recursive condition query. The first thing we need to do is to make a related plan for the relevant tables, is the PID parent ID that must have its own ID and ID corresponding to the relevant record ).

The following articles mainly introduce the execution process of Oracle delete. We all know the specific analysis of the procedures related to the actual operations of Oracle delete and Commit, the following is an introduction to the actual

The following articles mainly introduce how to correctly use Oracle External tables to view related alarm information. First, we need to understand the actual application of Oracle External tables, and the differences from other tables, so we need

The following articles mainly describe the actual steps and procedures for parallel execution of Oracle databases. If you want to have a better understanding of the actual operations, I believe the following articles will give you a better

Oracle databases are worth learning a lot. In this article, we mainly talk about the Oracle SMON process, including introduction to archive process ARCH and other aspects. We all know that there are usually two very small processes in the Oracle

The following articles mainly describe the usage of Oracle to_char. Oracle to_char can be widely used in a short period of time, indicating that its practical application is dominant, the following is an introduction to the specific content of the