Oracle

One, the connection of the databaseSqlplus [/][@]|/[as sysdba| as Sysoper]|/nolog1.c:\users\administrator>sqlplus/as Sysdba; ---This is a typical operating system certification and does not require a listener

There are two ways that Oracle can interact: Sqlplus (command line) SQLPLUSW (graphical interface)Enter Sqlplus mode: cmd input sqlplusEnter SQLPLUSW mode: cmd input SQLPLUSWMore convenient way: Winkey + R Open the Run window--Enter Sqlplus or

First, the database administrator1, SYS and system differences (illustrated with examples)The following two words were spoken at the first:(1) SYS user is superuser, has the highest privileges, has DBA role and SYSDBA, Sysoper database management

1. Change the password(1). Open the Doc Command box type: Sqlplus/nolog(2). Input: Connect/as SYSDBA(3). Change Password: Alter user userName identified by PassWord;(4). Unlock: Alter user userName account unlock;(5). Exit: Exit;2. Open Service(1).

I. Installation of Oracle database softwareOltp:online Transaction ProcessingRefers to the database system with short transactions, high concurrency, and frequent read and write. --db_block_size is usually set to a smaller size.Olap:online Analysis

The growth strategy for setting the ID is sequence, specifying sequence's name, preferably one for each table sequenceFor example, create a sequence:CREATE SEQUENCE department_id_seq MINVALUE 10000 MAXVALUE 999999999999999999999999 INCREMENT by 1

Original: http://www.cnblogs.com/crazyjava/archive/2012/10/31/2748202.htmlInStr (String1,string2[,start_position[,nth_appearence])String1: To find in this string.String2: The string to find in string1.Start_position: The location to look for from

---11g is Monday to Friday 22:00-2:00 Saturday Sunday 6:00-4:00SELECT W.window_name, W.repeat_interval, W.duration, w.enabledFrom Dba_autotask_window_clients C, Dba_scheduler_windows WWHERE C.window_name = W.window_nameand c.optimizer_stats = '

Oracle Server (server) by Oracle instance (instance) and Oracle database (database) composition. 1 Oracle database is made up of data files, control files, redo log file (redo logfile), parameter Files (initialization spfile and pfile), password

--Query the size and table space of the LOB select A.table_name, A.column_name, B.segment_name, B.segment_type, B.tablespace_n AME, round ((b.bytes/1024/1024/1024), 2) from User_lobs A, user_segments bwhere a.segment_name = b.segment_name ORDER by b.

Oracle RAC Study--delete vote DISKEnvironment:Operating System: AIX 5300-09Cluster Software: CRS 10.2.0.1Database: Oracle 10.2.0.1There are two ways in which RAC can be used to build an AIX platform based on shared storage:1. Establish shared

The package consists of two separate parts: Baotou (packages) and inclusion (Packagebody). Baotou is the description part of the package, is the external operating interface, is visible to the application, the package is the code and implementation

Fs.file-max = 6815744--Represents the maximum number of file handles, indicating the number of files that can be opened on a Linux system.Fs.aio-max-nr = 1048576--This parameter restricts the concurrent outstanding requests and avoids the I/O

Pfile (Initialization Parameter File) is used for oracle8i, can also be used in oracle9i, as text, you can use a text editor to modify the parameters.SPFile (server-side initialization Parameter File) is used for oracle9i, exists as a binary literal,

NVL () function in OracleOracle's use of the NVL functionThe total value of a field is obtained by a query, and if the value bit is NULL, a default value is given.Select NVL (SUM (T.DWXHL), 1) from Tb_jhde t where zydm=-1Here the usage of the NVL is

In Oracle, single quotes have two effects:1: String is quoted by single quotation mark2: Escape.The use of single quotation marks is the nearest pairing. While single quotation marks are relatively poorly understood when they act as escape

This function splits the target string with the specified string and returns the result through the table structure. The code is as follows:CREATE OR REPLACETYPE Str_split is TABLE of VARCHAR2(4000);CREATE OR REPLACE FUNCTIONSplitstr (p_stringinch

Transaction ISOLATION Level: the degree to which a transaction's modification of a database is isolated from another transaction in parallel. The following three issues may exist when two concurrent transactions access the same row as the database

Windows Edition: Official website download, two compressed package, a total of 2G, extracted to the same folder, Setup.exe double-click to execute, waiting for the good, general performance of the machine about half an hour or so. After installation,

Oracle trigger thrown into the trap Routine checks on the AWR Report of the database. An update statement is executed multiple times for over 30 seconds each time. This SQL statement is very simple, that is, modifying data based on primary key