Oracle

The AWR(Automatic Workload Repository) Report is an important tool for our daily database performance assessment and problem SQL discovery. Mastering the AWR report is an important skill in developing and operating DBA work.The AWR reporting

SummaryStudents who often write SQL may use both the Union and UNION all keywords, and perhaps you know that using them can combine the result set of two queries.So what's the difference between them? Here's a simple analysis.ComparisonUnion: Set

The synonyms and sequences for the basic introduction to PL/SQL PL/sql: Process language (Procedure Language) and structured language (structured Query Language)The combination of the programming language, is theSQLextensions that support multiple

In Oracle database operations, why is it that sometimes a field in a table is indexed, and when the execution plan of some language is observed, it does not go through the index? How to solve it? In this article we mainly introduce this part of the

SELECT * FROM table where id =?Similar to the above SQL, if you do not have to bind the variable, each time Oracle will be considered a different SQL, will be generated at each execution of the execution plan, and the execution plan generation is

Error example (the following error is returned when an http request is sent using UTL_HTTP ): Cause: 1. Oracle allows several PL/SQL APIs (UTL_TCP, UTL_SMTP, UTL_MAIL, UTL_HTTP, and UTL_INADDR) to access external network services, all of which use

Oracle view basics and Examples Abstract: This document describes the concepts, advantages and disadvantages, application, and precautions of views.I. Concept A view is a logical table based on one or more tables or another view. Unlike tables, a

Today is February 6,. before the Spring Festival, I will review what I learned in October. I have detailed operations on the oracle memory segment in my previous blog. Record the usage of the ipcs command

The oracle execution plan storage outline corresponds to the SQL statement one by one. Therefore, if we change the predicate condition in the SQL statement, the storage outline will be ineffective or we need to create a new storage outline to

Problem description: Import using impdp Data Pump at ORACLE11g: ORA-01691: Lob segment ISCS. SYS_LOB0000100750C00045 $ unable to scale through 128 (in tablespace RT_DATA) There may also be insufficient TEMP and UNDO tablespaces: ORA-30036: unable to

An oracle 11GR2 javasuard switchover failover article, hoping to help you. 1. switch: the user actively switches;2. failover: the master database fails and the switchover is forced; Switchover, all physical and logical standby operations in the

After Oracle is installed, there is a default database. In addition to this default database, we can also create our own database. For beginners, you can use the 'database Configuration asmap' Wizard to create a Database to avoid troubles. After

I. Question proposal At the early stage of application system development, due to the relatively small amount of data in the development database, the performance of SQL statement writing is not good for querying SQL statements and writing complex

Oracle 8i introduced recovery management RMAN), the first implementation of real Incremental backup. Before RMAN, the database output can also be incremental, but once any part of a table changes, the entire table needs to be overwritten. RMAN

Related commands This article mainly uses three commands. Here we will introduce them separately: Export: backs up data in the database into a binary system file. It has three modes: user mode, table mode, and whole database mode. There are also

Here we will introduce how to unlock users in Oracle. We generally use the default password to unlock users in Oracle. I hope this article will help you. 1. automatic Installation selected during installation. Because the user name and password have

I would like to introduce Oracle to you. Many people may not know about the Oracle Sybase database. It does not matter. After reading this article, you will certainly have a lot of GAINS. I hope this article will teach you more. With the development

In practical applications, we can feel that Oracle is quite powerful and flexible. If you want to use Oracle as a database of your project, but you do not know how to import the database, you can refer to the following articles to understand the

Today, we will introduce you to the actual steps for installing Oracle10g xe on ubuntu 9.04. Most people will feel dizzy when installing Oracle10g xe on ubuntu 9.04 ", in fact, if you have some knowledge about the actual operation steps, you will

Initialize the parameter file -The entries in the file are dedicated to the instance to be started. -There are two types of parameters: Show: There is an entry in the file Implicit: there are no entries in the file, but it is assumed that the