Pro Oralce SQL[NOTE]

chapter - 01

1. help index

2.%oracle_home%\sqlplus\admin\glogin.sql

user : login.sql

3. show linesize;

set linesize 200;

4.edit to open the cache sql, and @file.sql, start file.sql to exectue it.

.sql is an option.

set the default editor:  set define_editor='/full path/myeditor.exe' in login.sql, refer 2.

5.merge

* chapter - 02 

1. SGA, PGA

DB=>file

instance=>memory=>SGA

user:client process<==>server process: program global aear & process globle area

IMAGE URL:

2. v$sql table, 

SQL> select rownum,sql_fulltext from v$sql where rownum<10;

sql 字符串编译成散列值，决定软解析or硬解析。

3. use variable, can decrease 锁存器，硬解析。

4. SGA - Cache area cache

alter system set events 'immediate trace name flush_cache';  -- cache area
alert system flush shared_pool;  -- share pool, hard resolve
set autotrace traceonly statistics;
select * from employees where deparment_id=60;
set autotrace off;

5. check SQL execute explain plan

set autotrace on explain;
select * from posusr.employees where deparment_id=60 and EMPLOYEE_ID=103;

Run Script(F5)

2. full table access FYI.