Oracle

The solution for physically deleting the DBF File causes the database to fail to work properly. Because the space on the E disk where the local oracle installation is located is insufficient, the unused data file E is: \ ORACLE \ PRODUCT \ 10.2.0 \

Example of the stored PROCEDURE written in the Oracle stored PROCEDURE summary project: www.2cto.com Oracle stored PROCEDURE basic syntax Stored PROCEDURE 1 create or replace procedure stored PROCEDURE name 2 IS/AS 3 BEGIN 4 NULL; 5 EXCEIPTION; 6

The nature of Oracle row-level locks (I) three major components of the single-instance Oracle locking mechanism www.2cto.com locking mechanism: ① resource structure Oracle for each resource requiring "concurrent access, both use a Data structure in

Oralce data import troubleshooting (SYSTEM. PROC_AUDIT and Audit) When you export the data of USERNAME user of Data A and then import the data to USERNAME in database B, the following problems occur during table data query by USERNAME User: www.2cto.

Dynamic listening: When an ORACLE instance is started, or the command alter system register is used, or every minute, the PMON process dynamically registers with the listener. the instance_name and service_names parameters in ora dynamically

Understanding cursors (1): An Overview of cursors eygle says that database activities are mainly about the importance of the cursors active cursors. As a result, I have made a series of articles, step-by-Step learning of cursors the first article is

Insufficient use of Oracle tablespace and solutions 1. how to query table space: www.2cto.com select B. file_id, B. tablespace_name, B. file_name, B. bytes, (B. bytes-sum (nvl (. bytes, 0), sum (nvl (. bytes, 0), sum (nvl (. bytes, 0)/(B. bytes) * 10

The storage outline and SQL plan baseline storage outline are designed to provide stable execution plans to eliminate the impact of changes in the execution environment or object statistics. Therefore, this feature is also called Plan stability.

Problem description: Some of my friends often encounter this problem. I clearly entered the correct Chinese character. Why did I find garbled characters on another computer? In fact, this problem occurs when the database performs Character Set

Oracle uses merge to update or insert data (Summary) under Java code summary. Using merge is much faster than traditional first judgment and then selecting insert or update. 1) The main function is to UPDATE and insert data to the database table

Oracle uses scripts to create data table space and users -- Create Table space (enterprise database) ----- declare v_rowcount number (5); begin select count (*) into v_rowcount from dual where exists (select 1 from dba_tablespaces where

Savepoint in Oracle transactions 1. Basic Concepts savepoint is a point in transactions and can be returned to a certain storage point through rollback. A transaction can have multiple storage points. Once the transaction is committed, the storage

Custom sqlplus sqlprompt after logon creates a login under any directory. SQL example: www.2cto.com E: \ oracle-study input content: define _ editor = sublime_textset serveroutput on size 1000000 set trimspool onset long 5000 set linesize 100 set

TABLESPACE is read only, and DML and DDL operations can be performed (some examples) create a test table space create tablespace tablespacereadonly datafile '/u02/oradata/orcl/tablespacereadonly01.dbf' size 1 m autoextend on next 1 m maxsize

In Oracle, SQL queries table information because the data structure design of some modules of the project is not strictly in accordance with a certain specification design, it can only beTo query the data structure, you need to query the following

When Oracle is installed on Windows 7, the internal program is terminated abnormally. solution: the program is terminated abnormally. An internal error occurs. Please provide the following documents to the Oracle Technical Support Department:

Preparations before Case demonstration: -- alter system flush shared_pool;-- Set timing on;-- Starting from an empty sharing pool, if you operate these test statements multiple times, you need to clear the sharing pool each time,Otherwise, the

Create a stored procedure for quick display of Oracle execution plans first: use the default [SQL] www.2cto.com SQL> create or replace procedure SQL _explain (v_ SQL varchar2) without setting output format parameters) 2 is 3 type explain_cursor_type

Pl/SQL deadlock: record is locked by another user due to a problem, I found a solution in a blog. After a try, I found the solution feasible! Www.2cto.com is afraid of poor memory! Also as your own search direction 1. PL/SQL query locks: select

Understanding of Oracle Database System Global Area (SGA) 1 Overview of Monitoring and Management of www.2cto.com Oracle SGA is an important part of routine database maintenance. This article describes the basic concepts of SGA, the SGA running