Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

´Óoracle±íÖÐËæ»úÈ¡¼Ç¼£¬²úÉúËæ»úÊýºÍËæ»ú×Ö·û´®


1¡¢´Ó±íÖÐËæ»úÈ¡¼Ç¼
    select * from (select * from staff order by dbms_random.random)
    where rownum < 4
    ±íʾ´ÓSTAFF±íÖÐËæ»úÈ¡3Ìõ¼Ç¼
2¡¢²úÉúËæ»úÊý
        SELECT DBMS_RANDOM.RANDOM from DUAL;
        ²úÉúÒ»¸öÈÎÒâ´óСµÄËæ»úÊý
        SELECT ABS(MOD(DBMS_RANDOM.RANDOM,100)) from DUAL;
        ²úÉúÒ»¸ö100ÒÔÄÚµÄËæ»úÊý
        SELECT TRUNC(100+900*dbms_random.value) from dual;
        ²úÉúÒ»¸ö100¡«1000Ö®¼äµÄËæ»úÊý
        SELECT dbms_random.value from dual;
        ²úÉúÒ»¸ö0¡«1Ö®¼äµÄËæ»úÊý
        SELECT dbms_random.value(10,20) from dual;
        ²úÉúÒ»¸ö10¡«20Ö®¼äµÄËæ»úÊý
        SELECT dbms_random.normal from dual;
        NORMALº¯Êý·µ»Ø·þ´ÓÕý̬·Ö²¼µÄÒ»×éÊý¡£´ËÕý̬·Ö²¼±ê׼ƫ²îΪ1£¬ÆÚÍûֵΪ0¡£Õâ¸öº¯Êý·µ»ØµÄÊýÖµÖÐÓÐ68%ÊǽéÓÚ-1Óë+1Ö®¼ä£¬95%½éÓÚ-2Óë+2Ö®¼ä£¬99%½éÓÚ-3Óë+3Ö®¼ä¡£
3¡¢²úÉúËæ»ú×Ö·û´®
        SELECT dbms_random.string from dual;
        ·µ»ØÒ»¸ö³¤¶È´ï60¸ö×Ö·ûµÄËæ»ú×Ö·û´®¡£    £¨Î´ÊÔÑé³É¹¦£©
        select dbms_random.string('P',20) from dual;
        µÚÒ»¸ö²ÎÊý P ±íʾ printable£¬¼´×Ö·û´®ÓÉÈÎÒâ¿É´òÓ¡×Ö·û¹¹³É 
        µÚ¶þ¸ö²ÎÊý±íʾ·µ»Ø×Ö·û´®³¤¶È


Ïà¹ØÎĵµ£º

oracle hintÖÐordered ºÍleadingÔ­ÀíºÜºÃµÄÌû×Ó

ÎÊÌ⣺Çë½ÌHINTд·¨
ÎÒÓÐÒ»¸öSQLÌí¼ÓÈçÏÂhint,Ä¿µÄÊÇÖ¸¶¨hash_join·½Ê½¡£
select /*+ordered use_hash(a,b,c,d) */ *
from a,b,c,d
Where ...
ÆäÖÐ,
      aÖ»ÓëbÓйØÁª¹ØÏµ£¬bÖ»ÓëcÓйØÁª¹ØÏµ£¬bÖ»ÓëcÓйØÁª¹ØÏµ,cÖ»ÓëdÓйØÁª¹ØÏµ£¬
    ÊýÁ¿¼¶£ºa:1000Ìõ,  b:100 ÍòÌõ£¬ ......

Oracle³£ÓÃÃüÁî

1. ÐÞ¸Äredo log file´óС
SQL> select group#,status from v$log;
SQL> alter database add logfile group 4 'F:\oracle\product\10.2.0\oradata\orcl\REDO04.LOG' size 512m;
SQL> alter system switch logfile;
SQL> select group#,status from v$log;
2. ÐÞ¸Älarge_pool_size´óС
SQL> alter  ......

OracleÖеĹ鵵ÈÕÖ¾£¨Archive Log£©

OracleÖеĹ鵵ÈÕÖ¾£¨Archive Log£©
ÎÄÕ·ÖÀà:Êý¾Ý¿â
ÔÚOracleÖУ¬Êý¾ÝÒ»°ãÊÇ´æ·ÅÔÚÊý¾ÝÎļþÖУ¬²»¹ýÊý¾Ý¿âÓëOracle×î´óµÄÇø±ðÖ®Ò»¾ÍÊÇÊý¾Ý¿â¿ÉÒÔÔÚÊý¾Ý³ö´íµÄʱºò½øÐлָ´¡£ Õâ¸öÒ²¾ÍÊÇÎÒÃdz£¼ûµÄOracleÖеÄÖØ×öÈÕÖ¾£¨REDO FILE£©µÄ¹¦ÄÜÁË¡£ÔÚÖØ×öÈÕÖ¾·Ö³É2²¿·Ö£¬Ò»¸öÊÇÔÚÏßÖØ×öÈÕÖ¾Îļþ£¬ÁíÍâÒ»¸ö¾ÍÊǹ鵵ÈÕÖ¾Îļþ¡£
......

dspace windows oracle install

 ½ñÌìÁ˽âÁËһϿªÔ´dspaceÈí¼þ£¬ÏÖ½«°²×°¹ý³Ì×ܽáÈçÏ£º
1¡¢»·¾³ÉèÖÃ
   1.1 ÏÂÔØjdk1.6.x²¢°²×°,°²×°Ê±Ñ¡ÔñĬÈϰ²×°Â·¾¶¼´¿É
       Ò»°ãΪ C:\Program Files\Java\jdk1.6.0_10
       ÉèÖÃJAVA_HOME,ÉèÖÃCLASSPATHºÍPATH
2¡¢×é¼þ×¼±¸ ......

oracle ÎïÀíÊý¾Ý¿â½á¹¹

ºÃ¾Ã¾ÍÏë¿´oracleÁË£¬ÓÉÓÚ×Ô¼ºÌ«ÀÁ£¬×î½ü²Å¿ªÊ¼¡£Ï£ÍûÒÔºóÄÜÑø³ÉºÃϰ¹ß¡£
Ò»¡¢oracle 10g ·þÎñÆ÷
   1.Ò»¸öoracle 10g·þÎñÆ÷°üº¬Ò»¸öoracleÊý¾Ý¿âºÍÒ»¸öoracle·þÎñÆ÷ʵÀý¡£
   2.ÿµ±Êý¾Ý¿âÆô¶¯Ê±ºò£¬ÏµÍ³È«¾ÖÇø£¨SGA£©±»·ÖÅ䣬²¢Æô¶¯ÁËoracleºǫ́½ø³Ì¡£SGAÊÇÓÃÓÚÊý¾Ý¿âÓû§¹²ÏíÊý¾Ý¿âÐÅÏ¢µÄÄÚ´æÇøÓ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ