Oracle 10g Æô¶¯Óë¹Ø±Õ
ÔÚÖ´ÐÐÆô¶¯¹Ø±ÕÃüÁî֮ǰÐèÒªÕýÈ·ÉèÖÃÏÂÁл·¾³±äÁ¿£º
ORACLE_BASE
ORACLE_HOME °²×°¹ý³ÌÖÐÏÔʾµÄoracle home Ŀ¼
ORACLE_SID
PATH=$PAHT£º$ORACLE_HOME/bin
ÒÔ oracle Õ˺ŵǽ Linux£¬»òÕß´Ó root ÏÂÊäÈë su - oracle ±ä³É oracle ÕʺÅÖ´ÐÐÆô¶¯¹Ø±ÕÃüÁî
1. Æô¶¯ºÍ¹Ø±Õ¼àÌý
Æô¶¯¼àÌý£ºlsnrctl start
¹Ø±Õ¼àÌý£ºlsnrctl stop
2. Æô¶¯ºÍÍ£Ö¹Êý¾Ý¿â
Æô¶¯Êý¾Ý¿â£ºÔÚÖÕ¶ËÊäÈë sqlplus '/ as sysdba' ½øÈë sqlplus£¬ÔÚ sqlplus ÊäÈë startup
Í£Ö¹Êý¾Ý¿â£ºÔÚ sqlplus ÊäÈë shutdown »òÕß shutdown immediate
3. Æô¶¯ºÍÍ£Ö¹ dbconsole ·þÎñ
Æô¶¯Ç°Ðè×¢ÒâOracleµÄidÊÇ·ñÕýÈ·
windowsÏÂÃüÁîΪset ORACLE_SID=TEST
AIXÏÂÃüÁîΪexport ORACLE_SID=TEST
Æô¶¯ dbconsole ·þÎñ£º emctl start dbconsole
Í£Ö¹ dbconsole ·þÎñ£º emctl stop dbconsole
4. Æô¶¯ºÍÍ£Ö¹ iSQL*Plus isqlplusctl start | stop
5. ÁгöOracle½ø³Ì
ps -fu oracle
Ïà¹ØÎĵµ£º
ÒÔdbaµÇ½
1.²é¿´Äĸö±í±»Ëø:
select b.owner,b.object_name,l.session_id,l.locked_mode
from v$locked_object l, dba_objects b
where b.object_id=l.object_id;
2.²é¿´±»Ëø±íµÄsid ºÍserial# :
select t2.username,t2.sid,t2.serial#,t2.logon_time
from v$locked_object t1 ......
OracleÖеÄHash JoinÏé½â
Ò»¡¢ hash join¸ÅÄî
Hashjoin(HJ)ÊÇÒ»ÖÖÓÃÓÚequi-join£¨¶øanti-join¾ÍÊÇʹÓÃNOT INʱµÄjoin£©µÄ¼¼Êõ¡£
ÔÚOracleÖУ¬ËüÊÇ´Ó7.3¿ªÊ¼ÒýÈëµÄ£¬ÒÔ´úÌæsort-mergeºÍnested-loop join·½Ê½£¬
Ìá¸ßЧÂÊ¡£ÔÚCBO£¨hash joinÖ»ÓÐÔÚCBO²Å¿ÉÄܱ»Ê¹Óõ½£©Ä£Ê½Ï£¬ÓÅ»¯Æ÷¼ÆËã´ú ......
ÖÚËùÖÜÖªµÄ¼¸¸ö½á¹û¼¯¼¯ºÏ²Ù×÷ÃüÁ½ñÌìÏêϸµØ²âÊÔÁËһϣ¬·¢ÏÖһЩÎÊÌ⣬¼Ç¼±¸¿¼¡£
¡¡¡¡¼ÙÉèÎÒÃÇÓÐÒ»¸ö±íStudent£¬°üÀ¨ÒÔÏÂ×Ö¶ÎÓëÊý¾Ý£º
¡¡¡¡drop table student;
¡¡¡¡create table student
¡¡¡¡(
¡¡¡¡id int primary key,
¡¡¡¡name nvarchar2(50) not null,
¡¡¡¡score number not null
¡¡¡¡);
¡¡¡¡insert into ......
Êý¾Ý×Öµädict×ÜÊÇÊôÓÚOracleÓû§sysµÄ¡£
¡¡¡¡1¡¢Óû§£º
¡¡¡¡¡¡select username from dba_users;
¡¡¡¡¸Ä¿ÚÁî
¡¡¡¡¡¡alter user spgroup identified by spgtest;
¡¡¡¡2¡¢±í¿Õ¼ä£º
¡¡¡¡¡¡select * from dba_data_files;
¡¡¡¡¡¡select * from dba_tablespaces;//±í¿Õ¼ä
¡¡¡¡¡¡select tablespace_name,sum(bytes), sum ......
alter session set nls_sort='schinese_pinyin_m';
select * from dept order by
nlssort(name,'NLS_SORT=SCHINESE_PINYIN_M');
Oracle9i֮ǰ£¬ÖÐÎÄÊǰ´ÕÕ¶þ½øÖƱàÂë½øÐÐÅÅÐòµÄ¡£
ÔÚoracle9iÖÐÐÂÔöÁ˰´ÕÕÆ´Òô¡¢²¿Êס¢±Ê»
ÅÅÐò¹¦ÄÜ¡£ÉèÖÃNLS_SORTÖµ
SCHINESE_RADICAL_M °´ÕÕ²¿Ê×£¨µÚһ˳Ðò£©¡¢±Ê»®£¨µÚ¶þ˳Ðò£©Å ......