Oracle

After installing the Oracle 10g R2 in CentOS 6.3, after rebooting, you will find that Oracle does not boot itself, which is normal, because the installation of Oracle under Linux does not start on its own, you must set the relevant parameters, First

If you are migrating a tablespace or data file only, you can move the table space or data file offline after the location, andAlert database rename and alter tablespace rename write position changes to the control fileExample migrating a data

This article will detail the Oracle 10g OEM general error -------Unknown host specified workaround, you need to know the friend can refer to the following refer to the detailed source: http://www.jb51.net/article/32135.htmReinstall the

The stored procedure of PL/SQL Foundationstored procedure: A procedure is a subroutine used to complete a specific task ( A collection of code )/* Sub-Program Advantages:1. Modular, decomposition of the program into a logical module; 2. reusability,

? Define subqueries? Describe the types of problems that subqueries can solve? List the types of subqueries? Write single-line and multiline subqueries? Subquery: Type, syntax, and guidelines? Single-row subquery: – Group function in a subquery –

4. Disk Space 11g R2 requirements/tmp space cannot be less than 1G. if the requirements are not met, You can do one of the following two things: (1) Delete/tmp space to meet disk requirements. (2) set the TMP and TMPDIR environment variables. Use df-

Online migration OCR error: PROT-16 Symptom:[Root @ HeiLJUC01 ~] #/Oracle/app/11gR1/crs/bin/ocrconfig-replace ocr/dev/raw/raw9PROT-16: Internal Error[Root @ HeiLJUC01 ~] #/Oracle/app/11gR1/crs/bin/ocrconfig-replace ocr/dev/raw/raw9PROT-16: Internal

Oracle compression technology includes basic table compression, OLTP table compression, and index compression) and hybrid column compression (hybrid columnar compression (HCC )). Basic compression was launched from 9i and is the default compression

ASCII (x1) [function]: returns the ASCII value of the leftmost character of a character expression. [Parameter]: x1, character expression [Return]: Numeric [Example] SQL> select ascii ('A') A, ascii ('A') A, ascii ('') space, ascii ('shit') hz from

I have been in the blog Park for more than two years. Every time I want to write something, I will give myself a variety of excuses ~ Let's start with the longest-used Oracle Database Import today! 1. exp/imp of earlier versions can be connected to

I. Incremental backup scriptLevel 0 backup script: The red part is the directory of the custom backup fileCopy codeThe Code is as follows:# Script.: BackupFull. sh# Creater: xyh# Date: 2014-03-08# Desc: backup full database datafile in archive with

Configuring hugepage in Linux can improve oracle performance and reduce the page switching of oracle sga, similar to the lagepage in aix.Why use big pages? The default block size for LINUX memory is 4 kb.If the SGA is 128GSelect 128*1024*1024/4 from

This document describes how to use SQL Plan Management to manage SQL Execution plans. SQL Plan management provides components for capturing, selecting, and evolving SQL Plan information to prevent performance degradation caused by sudden changes in

Oracle-07445 [kgghash]: Oracle BUG causes the process to be killed when updating the LOB FieldSymptom:The user reports that a DB connection is accidentally killed. The following information is found in the alert Log during troubleshooting:Mon Apr 22

Create a data table using a stored procedure:When creating a table, note that you must add authid current_user. If the created table already exists, the stored procedure continues to run. If you do not add this key statement, the stored procedure

Despite the rapid popularity of Python among developers, Oracle database has long been the best enterprise database. Combining the two in an effective way is an interesting topic, but it is actually a real challenge because both of them have to pay

View and index of basic PL/SQL PL/SQL: a programming Language combined with a Structured Language (Structured Query Language). It is an extension of SQL and supports multiple data types, such as large objects and Collection types, you can use

12. Start the command line Since I installed it with a VM, you must first change the default startup mode to the command line method. Log On with root, edit the/etc/inittab file, and change d: 5: initdefault: To d: 3: initdefault: Knowledge Point 6:

PL/SQL subprograms include functions and procedures. The function here refers to the user-defined function, which is different from the system function. A subroutine is a PL/SQL block that completes a specific function. It is universal and can be

SQL> oradebug event 10046 trace name context forever, level 8ORA-00072: process "Unix process pid: 1564906, image: oracle @ db02 (P007)" is not activeSQL> oradebug setospid 2703564 Oracle pid: 452, Unix process pid: 2703564, image: oracle @ db02SQL>