Oracle

A series of reports from the software ecosystem:Oracle EcosystemAccording to the evaluation, with the continuous acquisition of Oracle, the comprehensive competitiveness of its ecosystem has rapidly increased in recent years. In particular, after

SQL TraceYesOracleProvides a powerful diagnostic tool for holding SQL search. SQL TRACE is a commonly used method in the diagnosis and handling of database problems. SQL TRACE can be divided into the following steps: 1. Define the scope of goals

We have previously introduced: For a detailed introduction of the Oracle database flashback personality, this article willFlashback of Oracle 10 Gb DatabaseThe configuration and usage are summarized for your reference. You can directly apply the

We know that,Oracle 10gThe database provides more powerfulSearch for DataTo improve the efficiency of database query. So how does it find data? How can I find data? In this article, we will introduce this part of content. Next let's take a look at

OracleDatabasePessimistic lockAndOptimistic lockIs what we will introduce in this article. Sometimes, for maximum performance, databases generally have a concurrency mechanism, but the problem is Data Access conflicts. To solve this problem, most

In Oracle Database Operations, we often need to start or close some services to implement the functions we need. But the premise is that we must understandOracle Database ServicesIf you are not familiar with Oracle database services, it doesn't

InOracleIn the database, how do we checkCPU and PSU PatchesWhat about the installation? This article mainly introduces this part, hoping to help you. Normally, there are two methods: One is to log on to the database and check the DBA_REGISTRY_HIST

Last time we introduced:Oracle Database ProcessServer process details. This article mainly introducesBackground ProcessWe know that Oracle instances include two parts: SGA and a group of background processes. The actual maintenance tasks required

Tomcat 6.0+Oracle 10 GB Data source connection testThe process is what we will introduce in this article. Next let's take a look at this part of content, hoping to help you. The connection test procedure is as follows: 1. Copy the driver package \

Oracle SQL developer is a database development tool that comes with oracle 11. to use it, you need to install java jdk. I installed jdk1.6 update2, but it cannot be used. Later I installed update26. I have not made any in-depth research on which jdk

  If the execution efficiency of a system is relatively low, a better method is to track user sessions and use the tkprof tool to format the output using the sorting function to find out problematic SQL statements. For example, first, use the top

  I. Shared pool tunning   The Optimization of the Shared pool should be given priority, because a cache miss occurs in the shared pool, which is more costly than the data buffer, because the dictionary data is generally longer than the data stored

  Overview and simple example of Oracle Virtual Private Database (VPD) 1. Overview of Oracle Virtual Private Database (VPD) VPD provides better row-level access control than roles and views. For example, in internet access, a virtual private

If the character set of the Server Client is improperly set in the Oracle database, the data stored in the database will not be properly saved, or the data in the database cannot be properly displayed in the customer segment, code corruption occurs. 

-- I have tried the following methods 1 and 3. It is best to delete them in sqlplus. The restoration method is:002-- Write the delete table as a script:003--************************004-- ** Method 1005--************************006-- Enter the

In windows, sqlplus is completely normal, but in linux, there is a problem with sqlplus Chinese display, always displaying "?", How can this problem be solved? The solution is as follows: In fact, it is easy to set exit sqlplus and set the

An in-depth analysis of the entire UPDATE process from birth to death is a question that a brother of Oracle once asked me. Some people later asked me this question: use ORACLE Internal principles to describe the following processes: 1. sqlplus

Flash back data archiving experiment-new features provided by oracle total recall ORACLE 11G. With this feature, ORACLE archives UNDO data to provide comprehensive historical data query. Similar to archiving logs, the new background process FBDA

Log file switch and log file sync 10.3.15 log file switchThere are two wait events commonly encountered: log file switch (archiving needed) log file switch (checkpoint incomplete) In both of the events, the LGWR is unable to switch into the next

Oracle SQL clob queries duplicate data. Multi-field COMPARE function data clob fields cannot be group by or distinct during query. Therefore, it is very troublesome to find duplicate data based on clob, most people on the Internet propose to use