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

  The next step is to switch to the oracle user and run the installation. Based on past experience, you only need to run the installer on shell su-oracle. This time I encountered a problem in suse. This is the second problem encountered during this

-- Add_months (d, n): returns the date and time corresponding to n months after or before the specified date and time. N is a positive integer, and n is a negative integer.Select add_months (sysdate,-5) from dual; output: 2010-08-26 13:24:28 --

When developing android lbs positioning, you can get a point (longitude and latitude) that requires businesses to be located one kilometer nearby. All these businesses are in the local database and are marked with longitude and latitude, that is to

[Oracle] parameter modification summary Oracle parameter modification is complicated. Some parameters can be modified at the session level, and some must be modified at the system level, some parameters take effect immediately after modification (no

The Oracle instance and service knowledge point shutdown is to start the service for the instance, it does not mean that the instance is started. There are three steps to start a database: 1. nomount (that is, only instance is started, but database

Tip ORA-03113: The end of the communication channel file to Solve the Problem reason: oracle installed to win7, thought it is a direct sqlplus/as sysdba, use the database, but the recent connection frequently reported error, prompt ORA-03113:

ORA-00401: the value for parameter compatible is not supported by this release Solution [SQL] [oracle @ rhel5 ~] $ Sqlplus/as sysdba SQL * Plus: Release 10.2.0.1.0-Production on Sun Aug 11 08:59:13 2013 Copyright (c) 1982,200 5, Oracle. all rights

The Oracle Recycle Bin function is familiar with the Recycle Bin function in windows. You can restore the deleted files to the Recycle Bin. the Oracle recycle bin works exactly the same, but there are some differences in implementation details. in

When iptables is enabled in 11gR2 RAC, node downtime is usually handled. When installing a database, the vast majority of users require selinux and iptables to be disabled before installation. However, in the carrier's system, many security factors

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

Traverse the joined array index by varchar2 -- The string sequence should be declare type t is table of number (3) index by varchar2 (3); hash_t t; l_row varchar2 (3); begin hash_t ('A '): = 10; hash_t ('B'): = 20; l_row: = hash_t.first; while

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

Solve the problem of system slowdown after oracle is installedOracle Database is a resource-consuming software. The memory occupied by a single instance service must be at least MB Based on the memory allocated during installation. In addition,

Excel-based oracle import methods Excel-based oracle import methods1. Same as the db2 import Method2. Use sqlldr to load data:1) Save the excel file as a. csv file and separate the text files with commas (,), such as table.csv.2) Compile an insert.

Query traversal: data must be stored in the base table in a hierarchical manner. For example, an organizational unit is such a typical example: Implementation statement: 　 Select column From table_name Start with column = value Connect by prior

Oracle uses regular expressions without the following four functions: 1. Regexp_like2. Regexp_substr3. Regexp_limit 4. Regexp_replace you can probably guess what the function name is.Regexp_likeIt can only be used for conditional expressions,

This article briefly introduces how to solve the ORA-27101, ORA-27102 errors in the use of oracle, students who need to learn can refer to the lower. The error message is as follows: ORA-27101Shared memory realm does not exist Cause: Unable to

This article will introduce iBATIS batch data insertion to the database. I hope this article will help you. Using callback interfaces in the iBATIS framework also enables batch data operations to reduce the number of accesses to the database and

This article introduces a summary of common Oracle Database problems and summarizes some problems and solutions when using oracle databases. For more information, see. 1. When PLSQL connects to the database, it prompts that the listener cannot