Oracle

  The content of this lecture includes: 1. Description of memory components in SGA 2. Use automatic shared memory management 3. manually configure the SGA Parameters 4. Configure Automatic PGA Memory Management I. SGA memory components Database

  In Oracle databases, the Database Control File maintains the global physical structure of the database to support successful database startup and operation. When creating a database, the corresponding database control file is also provided. During

ORACLE databases are difficult to install, and it is not as easy to uninstall as Microsoft products. For ORACLE9 uninstallation, there is no uninstallation program in the control panel. You can choose "start"> "program"> "Oracle Installation

1. pre-defined exception handling Example 1: update the specified employee's salary. If the employee's salary is smaller than 1500, the employee's salary is increased by 100;DECLAREV_empno employees. employee_id % TYPE: = & empno;V_sal employees.

Concept 1A cursor is a memory Workspace of SQL, which is defined by the system or user as a variable. The cursor is used to temporarily store data blocks extracted from the database. In some cases, you need to transfer the data from the table stored

The dynamic performance view is summarized as follows:1 v $ sysstat 22 v $ sesstat 73 v $ SQL 94 V $ SQL _PLAN 115 V $ SQLTEXT 136 V $ SQLAREA 147 V $ SESSION 158 V $ SESSION_WAIT 179 V $ SESSION_EVENT 2010 V $ PROCESS 2011 V $ LOCK 2312 V $

The bat script is as follows:Set yr = % date :~ 0, 4%Set mo = % date :~ 5, 2%Set dy = % date :~ 8, 2%Set dmpName = % yr % mo % dy %Exp username/password @ dbname file = d: \ % dmpName %. dmp owner = username log = d: \ log _ % dmpName %. logThe

Page ContextEvery time a page request is received, OAF creates an OAPageContext storage information until the new page is complete (in particular, OAPageBean creates an OAPageContext, which is mainly performed on the page background)Request and page

OAF provides three types of exceptions:1. General Exception:Class: oracle. apps. fnd. framework. OAExceptionProvides a means to display multiple types of exceptions at runtime. Combined with EBS Message Dictionary, you can display useful messages.2.

In Oracle/PLSQL, the trunc function returns a date truncated to a specific unit of measure.The syntax for the trunc function is:Trunc (date, [format])Date is the date to truncate.Format is the unit of measure to apply for truncating. if the format

Oracle pseudo-column ROWNUM Learning1. ROWNUM is sorted according to the order in which records are inserted. 2. ROWNUM does not actually exist. It is a sort of filtered result sets. If no result set exists, ROWNUM does not exist. 3. ROWNUM cannot

1 PrefaceDuring work, you may often encounter the creation of multiple SDE services on a single machine to manage operations on multiple spatial databases at the same time. On the ESRI website, copy % SDEHOME % to a new location and manually modify

Small and Medium databases rman catalog Backup Recovery Solution (2) 1. RMAN restores shell scripts [Python] -- The following shell script is used to restore the database automatically. After the restoration is successful, the database is closed. In

Oracle SQL recursion how should I write SQL recursive statements in oracle databases? The following is an example of using SQL recursive statements in oracle for your reference. Example: Pid id a B a c a e B b1 B b2 c c1 e e1 e e3 d d1 specify pid =,

Oracle programming using Java Source Step 1: create java source [java] create or replace and compile java source named Hello as public class Hello {public static void run () {System. out. println ("hello world !! ") ;}} Step 2: edit the stored

Sqlplus hidden key combination SQLPlus at the SQL * Plus command line prompt on UNIX/Linux platforms, If you mistakenly press the key combination: Ctrl + S, the session will be locked, no command is displayed. Unlock the combination key: Ctrl + Q

DB_WRITER_PROCESSES and LOG_ARCHIVE_MAX_PROCESSES Includescriptionparameter type IntegerDefault value 1 or CPU_COUNT/8, whichever is greater default value 1 or 1/8 Modifiable No Range of values 1 to 20 of the number of CPUs the value Range is 1 to 20

Partition index (2)-the local partition index can use the same partition key and range limit as the table to partition the local index. The partition of each local index only contains the key and ROWID of the table partition associated with it.

A Brief Introduction to Oracle Bad Block Processing Methods Oracle bad block processing involves two steps: 1. Check Bad blocks 2, fix the Bad blocks. You can use the DBV tool or the validate parameter in rman to detect the Bad blocks; 1) DBV tool:

In ORACLE, set the transaction attribute (TWO) to set the transaction attribute (set the read/write attribute of the transaction, the read-only attribute of the transaction, and the isolation attribute of the transaction) is only a control mechanism