[oracle 10g]ÃüÁîÐÐÆô¶¯ORACLE·þÎñ¼°Ë³Ðò
°¸Àý˵Ã÷
ΪÁ˽ÚԼϵͳ×ÊÔ´£¬ÎÒÃÇÔÚÁ·Ï°oracleµÄµçÄÔÖо³£»á½«oracleµÄ¸÷ÖÖ·þÎñÉèΪÊÖ¶¯µÄÆô¶¯Ä£Ê½£¬ÓÐʱΪÁË·½±ãÆڼ䲻ԸÒâ´ò¿ª·þÎñ¹ÜÀí´°¿Ú£¬Òò´ËÌØÔڴ˼ǼһÏÂÃüÁîÐÐÆô¶¯·½·¨¡£
ÎÒÓÐÁ½¸öÀý³Ì£ºorcl--×öÄ¿±êÊý¾Ý¿â£»test--×ö»Ö¸´Ä¿Â¼Êý¾Ý¿â¡£
Ò»°ãÀ´ËµË³ÐòÈçÏ£º
C:\>net start oracleserviceorcl
OracleServiceORCL ·þÎñÕýÔÚÆô¶¯ ..............................
OracleServiceORCL ·þÎñÒѾÆô¶¯³É¹¦¡£
C:\>net start oracleservicetest
OracleServiceTEST ·þÎñÕýÔÚÆô¶¯ ........................................
OracleServiceTEST ·þÎñÒѾÆô¶¯³É¹¦¡£
C:\>set oracle_sid=orcl
C:\>emctl start dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
http://aaaa:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 10g Database Control ...OracleDBConsoleorcl ·þÎñÕýÔÚÆô¶¯ ........
............
OracleDBConsoleorcl ·þÎñÒѾÆô¶¯³É¹¦¡£
C:\>lsnrctl start
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 11-9ÔÂ -2009 05:25:20
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Æô¶¯tnslsnr: ÇëÉÔºò...
TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production
ϵͳ²ÎÊýÎļþΪF:\oracle\product\1020\db_1\network\admin\listener.ora
дÈëF:\oracle\product\1020\db_1\network\log\listener.logµÄÈÕÖ¾ÐÅÏ¢
¼àÌý: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=aaaa)(PORT=1521)))
ÕýÔÚÁ¬½Óµ½ (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=aaaa)(PORT=1521)))
LISTENER µÄ STATUS
------------------------
±ðÃû LISTENER
°æ±¾ TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production
Æô¶¯ÈÕÆÚ 11-9Ô -2009 05:25:26
Õý³£ÔËÐÐʱ¼ä 
Ïà¹ØÎĵµ£º
/*sum()over()*/
--ĬÈϼÆËãËùÓÐÐеĺϼÆ
select t.empno,t.ename,t.sal,t.deptno,sum(t.sal)over()
from scott.emp t;
--partition by·Ö×éºÏ¼Æ
select t.empno,t.ename,t.sal,t.deptno,
sum(t.sal)over(partition by t.deptno)
from scott.emp t
order by t.deptno,t.sal;
......
oracle Êý¾Ý¿âÁ¬½Ó¾ÍÏñÄãÔÚ³ÌÐòÖн¨Á¢Ò»¸öµ½Êý¾Ý¿âµÄÁ¬½ÓÒ»Ñù¡£
Èç¹ûÊý¾Ý¿â²»ÔÚ±¾µØÖ÷»ú,±ØÐëÔÚ$ORACLE_HOME/network/admin/tnsnames.oraÖÐÅäÖÃÏàÓ¦µÄtns£¬È»ºó³ÌÐò²ÅÄÜͨ¹ýÅäÖúõÄtns·ÃÎÊÊý¾Ý¿â£¬µ«ÊÇjavaͨ¹ýthin·½Ê½·ÃÎÊoracleÀýÍ⣬¿ÉÒÔ²ÉÓÃÔÚ±¾µØÅäÖúõÄtns±ðÃû£¬Ò²¿ÉÒÔ²ÉÓÃtnsÈ«½âÎöÃû£¬²ÉÓñðÃûµÈºÅºóµÄÈ« ......
¼Ó·¨
select sysdate,add_months(sysdate,12) from dual; --¼Ó1Äê
select sysdate,add_months(sysdate,1) from dual; --¼Ó1ÔÂ
select sysdate,to_char(sysdate+7,'yyyy-mm-dd HH24:MI:SS') from dual; ......
Ë÷ÒýÌøԾʽɨÃè(index skip scan)ÊÇOracle9iµÄÒ»¸öеÄÖ´ÐÐÌØÐÔ£¬ÓÈÆäÊÊÓÃÓÚʹÓÃÁ¬½ÓË÷ÒýºÍ·ÃÎʶàÖµË÷ÒýµÄOracle²éѯ¡£
Ë÷ÒýÌøԾʽɨÃè(index skip scan)ÊÇOracle9iµÄÒ»¸öеÄÖ´ÐÐÌØÐÔ£¬ÓÈÆäÊÊÓÃÓÚʹÓÃÁ¬½ÓË÷ÒýºÍ·ÃÎʶàÖµË÷ÒýµÄOracle²éѯ¡£ÈÃÎÒÃÇ¿´ÒÔϵķ¶Àý¡£Çë×¢Òâ ......
´´½¨ÐµÄÓû§Ê±£¬ÒªÖ¸¶¨default tablespace£¬·ñÔòËü»á°Ñsystem±í¿Õ¼äµ±³É×Ô¼ºµÄȱʡ±í¿Õ¼ä¡£ÕâÑù×öÊDz»ÌᳫµÄ¡£¹À¼ÆÔÀ´´´½¨Ä³¸öÓû§µÄʱºòûÓÐÖ¸¶¨È±Ê¡±í¿Õ¼ä£¬¶øÏÖÔÚËüʹÓÃϵͳ±í¿Õ¼äµÄȨÏÞ±»DBA¸øÊÕ»ØÁË¡£
ÏÈÓõļòµ¥µÄ°ì·¨ÊÔÊÔ£¬Ò»°ãȱʡµÄORACLE°²× ......