ORACLE OLAP º¯Êý
¡¡ ×î½üÕâ¸ö¶«¶«ÓõÃÌØ±ð¶à£¬×ܽáÁËһϠ¡£
¡¡¡¡
Óï·¨: FUNCTION_NAME(,,...)
¡¡¡¡ OVER()
¡¡¡¡OLAPº¯ÊýÓï·¨Ëĸö²¿·Ö:
¡¡¡¡1¡¢function±¾Éí ÓÃÓÚ¶Ô´°¿ÚÖеÄÊý¾Ý½øÐвÙ×÷£»
¡¡¡¡2¡¢partitioning clause ÓÃÓÚ½«½á¹û¼¯·ÖÇø£»
¡¡¡¡3¡¢order by clause ÓÃÓÚ¶Ô·ÖÇøÖеÄÊý¾Ý½øÐÐÅÅÐò£»
¡¡¡¡4¡¢windowing clause ÓÃÓÚ¶¨ÒåfunctionÔÚÆäÉϲÙ×÷µÄÐеļ¯ºÏ£¬¼´functionËùÓ°ÏìµÄ·¶Î§¡£
¡¡¡¡
Ò»¡¢order by¶Ô´°¿ÚµÄÓ°Ïì
¡¡¡¡²»º¬order byµÄ£º
¡¡¡¡SQL> select deptno,sal,sum(sal) over() from emp;
¡¡¡¡²»º¬order byʱ£¬Ä¬ÈϵĴ°¿ÚÊÇ´Ó½á¹û¼¯µÄµÚÒ»ÐÐÖ±µ½Ä©Î²¡£
¡¡¡¡
º¬order byµÄ£º
¡¡¡¡SQL> select deptno,sal, sum(sal) over(order by deptno) as sumsal from emp;
¡¡¡¡µ±º¬ÓÐorder byʱ£¬Ä¬ÈϵĴ°¿ÚÊÇ´ÓµÚÒ»ÐÐÖ±µ½µ±Ç°·Ö×éµÄ×îºóÒ»ÐС£
¡¡¡¡
¶þ¡¢ÓÃÓÚÅÅÁеĺ¯Êý
¡¡¡¡SQL> select empno, deptno, sal,
rank() over (partition by deptno order by sal desc nulls last) as rank,
¡¡¡¡ dense_rank() over (partition by deptno order by sal desc nulls last) as dense_rank,
¡¡¡¡ row_number() over(partition by deptno order by sal desc nulls last) as row_number
¡¡¡¡ from emp;
¡¡¡¡
Èý¡¢ÓÃÓںϼƵĺ¯Êý
¡¡¡¡SQL> select deptno,sal,
¡¡¡¡ sum(sal) over (partition by deptno) as sumsal,
¡¡¡¡ avg(sal) over (partition by deptno) as avgsal,
¡¡¡¡ count(*) over (partition by deptno) as count,
¡¡¡¡ max(sal) over (partition by deptno) as maxsal
¡¡¡¡ from emp;
¡¡¡¡
ËÄ¡¢¿ª´°Óï¾ä
¡¡
¡¡1¡¢rows´°¿Ú: "rows 5 preceding" ÊÊÓÃÓÚÈκÎÀàÐͶøÇÒ¿ÉÒÔorder by¶àÁС£
¡¡¡¡ SQL> select deptno,ename,sal,
¡¡¡¡ sum(sal) over (order by deptno rows 2 preceding) sumsal
¡¡¡¡ from emp;
¡¡¡¡rows 2 preceding:½«µ±Ç°ÐкÍËüÇ°ÃæµÄÁ½Ðл®ÎªÒ»¸ö´°¿Ú£¬Òò´Ësumº¯Êý¾
Ïà¹ØÎĵµ£º
oracleÆô¶¯ÎÊÌâ
Ò»£ºÊý¾Ý¿âûÓÐÆô¶¯
#sqlplus /nolog
sql>connect /as sysdba
sql>startup
¶þ£º¼àÌý³öÎÊÌâ
µÇ¼DB·þÎñÆ÷
ʹÓÃlsnrctl start/stop¿ªÆô/¹Ø±Õ¼àÌý
ʹÓÃlsnrctl status²é¿´×´Ì¬
ÀíӦΪ£º
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ERPAP)(PORT=1521)))
STATUS of the ......
OracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚoracleÊý¾Ý»¹ÔÓ뱸·Ý¡£expÃüÁî¿ÉÒÔ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öµ½±¾µØµÄdmpÎļþ£¬impÃüÁî¿ÉÒÔ°ÑdmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶´¦µÄÊý¾Ý¿â·þÎñÆ÷ÖС£ÀûÓÃÕâ¸ö¹¦ÄÜ¿ÉÒÔ¹¹½¨Á½¸öÏàͬµÄÊý¾Ý¿â£¬Ò»¸öÓÃÀ´²âÊÔ£¬Ò»¸öÓÃÀ´ÕýʽʹÓá£
Ö´Ðл·¾³£º¿ÉÒÔÔÚSQLPLUS.EXE»òÕßDOS£¨ÃüÁîÐУ ......
Á¬½ÓOracleÊý¾Ý¿âµÄHibernateÅäÖÃÎļþ
Á¬½ÓOracleµÄHibernateÅäÖÃÎļþÓÐÁ½ÖÖ¸ñʽ£¬Ò»ÖÖÊÇxml¸ñʽµÄ£¬ÁíÒ»ÖÖÊÇJavaÊôÐÔÎļþ¸ñʽµÄ¡£ÏÂÃæ·Ö±ð¸ø³öÕâÁ½ÖÖ¸ñʽÅäÖÃÎļþµÄ´úÂë¡£
1£®xml¸ñʽµÄÅäÖÃÎļþ
ÏÂÃæ½«¸ø³öÁ¬½Ó±¾µØOracle·þÎñÆ÷ÉϵÄdb_database02Êý¾Ý¿âʱHibernateÅäÖÃÎļþhibernate.cfg.xmlµÄ´úÂë¡£
Àý³Ì2-5£º¹âÅÌ\mr ......
author£ºskate
time£º2010-05-13
1)If memory increases and you're 64-bit, e.g 8G to 16G, Oracle SGA and related parameters need adjust; So are some the Unix kernel parameters.
2)As for CPU related configuration, some parameters, based on CPU_co ......
ÓÉÓÚ֮ǰѧϰoracleµÄʱºò±È½ÏËæÒ⣬¿´ÊéÒ²ÊDZȽÏÉÙÈ¥ÉîÈë˼¿¼ÔÀí£¬¶ø´Óǰ¼¸Ìì¾ö¶¨ÒªÖØÐÂȼÆðoracleµÄѧϰ¼¤Çéºó£¬ÎÒÓÖÖØÐµĴӻù´¡Ñ§Æð£¬´ËʱÎÒѧoracleµÄÐÄ̬Ҳ±ÈÒÔǰºÃºÜ¶àÁË£¬ÏÖÔÚÊÇŬÁ¦µÄÒ»µãÒ»µãÈ¥¿ÐÁË£¬¼´Ê¹ºÜ»¨Ê±¼ä£¬µ«ÎÒÏëÕýÊÇͨ¹ý½ñÌìÎÒÕâÑùµÄÂñÍ·¿à¶Á²Å»á»»À´Óг¯Ò»ÈÕÔÚoracle·½ÃæµÄÖʵķÉÔ¾µÄ¡£
  ......