Oracle

This article transferred from: http://blog.csdn.net/gyb2013/article/details/6929697One, what is the lock:The lock mechanism of Oracle is a lightweight locking mechanism that does not lock the data by building a lock list, but instead directly stores

---is executing theSelect A.username, A.sid,b.sql_text, B.sql_fulltextFrom V$session A, V$sqlarea bwhere a.sql_address = b.address---executed.Select B.sql_text,b.first_load_time,b.sql_fulltextFrom V$sqlarea bwhere b.first_load_time between ' 2009-10-

#!/bin/shExport oracle_base=/app/oracle/Export Oracle_home=/app/oracle/productExport path= $ORACLE _home/bin: $HOME/bin: $PATHExport Oracle_owner=oracleExport ORACLE_SID=ORCL#数据库备份存放目录#BACKUP_DIR

The following is an example of importing and exporting.Data export:1 full export of database test, user Name System Password Manager exported to D:\daochu.dmpExp system/[email protected] file=d:\daochu.dmp full=y2 Exporting the system user in the

1. Create userGroupadd OinstallGroupadd dbaUseradd-m-G oinstall-g dba Oraclepasswd Oracle2. Create a DirectoryMkdir-p/u01/app/oracleMkdir-p/u01/app/orainventoryChown-r Oracle.oinstall/u01/appchmod 777/u01/app3, modify the

To delete a failed materialized view today; the manager said it was a lock watch; then Baidu took a look.Here is the query lock table and how to unlock it--Query the lock nowSELECT l.session_id Sid, S.serial#,

[SQL]View Plaincopy To establish the tablespace and the user's steps: User Create:Create user username identified by "password"; Authorization:Grant create session to user name; Grant create table to user name; Grant create

Max Maximum number auto plus 1Create or Replace function Fun_getmaxlot ( vend in varchar2, domain in VARCHAR2, tag in varchar2) RETURN Varch AR2 as maxval VARCHAR2 (40); NEWIQC VARCHAR2 (40); TT VARCHAR2 (12);

In Oracle, the having must be used in conjunction with group by, but in MySQL the situation is different. can be used alone.C:\Documents and Settings\guogang>sqlplus Test/testsql*plus:release 10.2.0.1.0-production on Tuesday August 12 09:09:58

Six of the Oracle Learning Primer seriesModeWe learned the database structure, memory structure and process in Oracle database, and the length of toad felt much more. This time to take a rest, each note should not be too much, or what is the

Oracle Basic ConceptsInstance An Oracle instance (Oracle Instance) consists of a series of background processes (Backguound Processes) and a memory structure (memories structures). There can be n instances of a database. User

1. java.sql.sqlexception:ora-01000: Maximum number of open cursors exceededStep 1:View the current number of cursors in the database configuration slqplus:show parameter open_cursors;Step 2:To view cursor usage:Select O.sid, Osuser, Machine, COUNT (*

Oracle exception. oracle Exception Handling Use oracle System cursor to process data   Instance code: -- Set serveroutput on;Create or replace procedure split_page_procedure (page_index in number,Page_size in number,Key_word in varchar2)

SQL Performance Tuning daily accumulation and SQL tuning Accumulation 1. Differences between Select Count (*) and Select Count (1: Generally, the returned results are the same for Select Count (*) and Select Count (1 ).   If the table does not

Node eviction caused by heartbeat Network (not instance eviction) Node eviction of Oracle RAC caused by heartbeat Network (not instance eviction) Q:Suppose the following scenario: for the four node rac, the heartbeat line uses a m network

Oracle obtains the year, month, and date list for a certain period of time. Get date list: SELECT TO_CHAR (TO_DATE ('2017-10-01 ', 'yyyy-MM-dd') + ROWNUM-1, 'yyyymmdd ') as daylist from dualconnect by rownum Obtain the month list: SELECT

Oracle11gR2 use RMANDuplicate to copy the databaseOracle 11gR2 uses RMAN Duplicate to copy a database   Preface: After a project was just completed last week, the user requested that the RAC database be automatically backed up to another single node,

Oracle regular backup and oracle backup 1. Copy the following code to the text, and modify the text suffix name to a XXX. bat batch file; **************************************** **************************************** ******************************

Oracle Learning (12): stored procedures, functions, and triggersStored Procedures and functionsL The subroutines stored in the database for all user programs to call are stored procedures and stored functions.Note: When stored procedures and stored

Oracle BASICS (7): database transactionsI. Basic Concepts1. Transaction: The basic unit of concurrency control. A transaction is a sequence of operations. These operations are either executed or not executed. It is an inseparable unit of work. For