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 ......
ÔÚÄ³Ð©ÌØÊâµÄÇé¿öÏ£¬ÈçÒòÎªÍøÂç»òÕßXÅäÖõĹØÏµÎÞ·¨Á¬½Óµ½X server»òÕßÖ÷»úÉÏûÓÐX£¬¾Í¿ÉÒÔʹÓþ²Ä¬°²×°µÄ·½Ê½°²×°Êý¾Ý¿â£¬Í¬ÑùÈç¹ûÐèÒª´ó¹æÄ£²¿Êð£¬Ôò¾²Ä¬°²×°½«»á´ó´ó¼õÇáDBAµÄÖØ¸´ÀͶ¯Á¦£¬¶øÇÒ¾²Ä¬°²×°²»ÐèÒªX£¬´Ó°²×°Ð§ÂÊ
ÔÚÄ³Ð©ÌØÊâµÄÇé¿öÏ£¬ÈçÒòÎªÍøÂç»òÕßXÅäÖõĹØÏµÎÞ·¨Á¬½Óµ½X server»òÕßÖ÷»úÉÏûÓÐX£ ......
oracle distinct
¹Ø¼ü×Ö: distinctµÄһЩÔÓ̸
distinctÕâ¸ö¹Ø¼ü×ÖÀ´¹ýÂ˵ô¶àÓàµÄÖØ¸´¼Ç¼ֻ±£ÁôÒ»Ìõ£¬µ«ÍùÍùÖ»Óà ËüÀ´·µ»Ø²»Öظ´¼Ç¼µÄÌõÊý£¬¶ø²»ÊÇÓÃËüÀ´·µ»Ø²»ÖؼǼµÄËùÓÐÖµ¡£ÆäÔÒòÊÇdistinctÖ»ÓÐÓöþÖØÑ»·²éѯÀ´½â¾ö£¬¶øÕâÑù¶ÔÓÚÒ»¸öÊý¾ÝÁ¿·Ç³£´óµÄÕ¾À´Ëµ£¬ÎÞÒÉÊÇ»áÖ±½ÓÓ°Ï쵽ЧÂʵġ£
ÏÂÃæÏÈÀ´¿´¿´Àý×Ó£º
table ......
²éѯ·¢ÉúËÀËøµÄselectÓï¾ä
select sql_text from v$sql where hash_value in
(select sql_hash_value from v$session where sid in
(select session_id from v$locked_object))
---------------------------------------------------------
¹ØÓÚÊý¾Ý¿âËÀËøµÄ¼ì²é·½·¨
Ò»¡¢   ......