Oracle

I. ORACLE Physical Architecture Principle Structure diagram Each part explains:PGA: Private memory area for use by the current initiating user only.Three effects The session information after the user logs in will be saved in

Source: http://www.2cto.com/database/201208/145611.html Today, just take the month and the number of days, if 0 in front of the month to get rid of 0. For example, 2010-01-08, the required result is 1-8. Leads to a series of SQL statements first:

Group by multiple table multi-field Association queryOneself encounter a problem, is the beginning of the time need a field name and number, but the same table.The database code is as follows:Select L.batchnum,count (l.batchnum) Batcount from

Oracle establishes tablespaces and usersSteps to establish a tablespace and User: Create user username identified by "password"; authorization: Grant create session to username; Grant CREATE table to username; Grant create

Installation environment except for steps 1 and 7, the remaining steps are done under root user Database version: Oracle 11g R2 operating system: CentOS6.5 Preparing the operating system1) Download Oracle 11g R2 installation files:

Pmon:process Monitor uses automatic registration for dynamic monitoring to handle abnormal processes.Smon:system Monitor is used for instance recovery.LCKN: Use only the RAC database for blocking between instance.RECO: For the recovery of

Oracle regularly backs up the database and deletes the data backed up 7 days ago.1. Create and store the backup directory:Mkdir/home/oracle/data_backupMkdir/home/oracle/log_backup2, edit the script oracle_backup.sh, the content is as

During the operation, the Oracle Runtime CPU utilization reached more than 90%, and the following parameter values were adjusted to return to normal.Fs.file-max =

1. Modify the Oracle System configuration file::/etc/oratabVi/etc/oratabOrcl:/opt/oracle/product/10.2.0/db_1:Y2. Create the file Oracle startup script under/etc/init.d/, with the following content: #!/bin/sh# chkconfig:35 80 10#

Tag: SQL Server Oracle SQL MySQLSQL dialect configuration for oracle,mysql,sqlserver database in hibernate4 (SQL dialects) Database type Hibernate SQL dialect DB2 Org.hibernate.dialect.DB2Dialect

/* divided into four steps *//* 1th step: Create temporary tablespace */create temporary tablespace yuhang_temp tempfile ' D:\oracledata\yuhang_temp.dbf ' size 50m Autoextend on next 50m maxsize 20480m extent management local; /* 2nd step: Create

Small example, convenient for later inspection.Baotou needs to declare: type c_cursor is ref CURSOR;procedureVisitcount (in_date Number, Out_code out Number, Out_desc outvarchar2 ) ist_date Number(8);

--- ProblemSelect owner, index_name, DEGREE from DBA_INDEXES where DEGREE> 1*ERROR at line 1:ORA-01722: invalid number.-- 1 get execution trace informationSQL> set autotrace traceonlySQL> select owner, index_name, DEGREE from DBA_INDEXES where

ORA-00913 error.Description: PL/SQL: ORA-00913: too export values objective: to write a script that can insert data cyclically operation process: SQL> desc tcustmerName Null? Type-----------------------------------------------------CUST_CODE not

1. Types of SQL parse SQL parse is usually divided into hard parsing and soft parsing. When SQL is executed for the first time, hard parsing will occur, and subsequent execution will be soft parsing if it can be found in the shared pool. Therefore,

We have created two users for the system: com and comtest. The former stores the formal database data and the latter stores the test database data. They all have a table named taw_rm_user, which stores the basic user information of the system. I

GG configure Oracle synchronization to SQLServerPrepare a test table for the source and target end. Oracle Source: drop table ggmgr. t1; create table ggmgr. t1 (id int primary key, name varchar2 (50), time date );Sqlserver target end: begin

1. connection sequence in WHERE clause: ORACLE uses the bottom-up sequence to parse the WHERE clause. According to this principle, the connection between tables must be written before other WHERE conditions, the conditions that can filter out the

Oracle11g RAC construction in linux (5)4. Establish trust relationships between hosts (node1 and node2) Establish trust between oracle and grid users between nodes (create a public key and private key through ssh) Create in node1 and node2

-- Add variableVariable job1 number; -- Create a JOBBeginDbms_job.submit (: job1, 'testjob; ', sysdate, 'trunc (sysdate + 1) + 1000 ');COMMIT;End;/ -- Query the corresponding JOB numberSelect job, last_date, last_sec, broken, failures, interval,