Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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³£ÓÃÃüÁî

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 RACͬ²½ÆµÂÊÉèÖÃ

max_commit_propagation_delayĬÈÏֵΪ700£¬¼´7Ã루µ¥Î»0.01s£¬http://www.orafaq.com/parms/parm1217.htm£©¡£
Õâ¸ö²ÎÊýÓ¦¸ÃÅäÖõÄÊÇRAC£¨Real Application Cluster£©Ö®¼äͬ²½Êý¾ÝµÄƵÂÊ¡£ÐÞ¸ÄÕâ¸ö²ÎÊýµÄºÃ´¦¾Í²»ÓÃ˵ÁË£¨
±¾ÈËÉîÊÜÆä¿à°¡
£©£¬µ«ÊÇÈç¹û×ßÁíÒ»¸ö¼«¶Ë£¬¿ÉÄÜ»á¸øÊý¾Ý¿âÔì³É¸ü´óµÄѹÁ¦
²ÎÊýÖ¸¶¨Ò»¸öinstance ......

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

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

SybaseÊý¾Ý¿âºÍoracleÊý¾Ý¿âÓ÷¨


1 ½«Êý¾Ý¿âTESTÍêÈ«µ¼³ö,Óû§Ãûsystem ÃÜÂëmanager µ¼³öµ½D:daochu.dmpÖÐ
    exp system/manager@TEST file=d:daochu.dmp full=y
2 ½«Êý¾Ý¿âÖÐsystemÓû§ÓësysÓû§µÄ±íµ¼³ö
    exp system/manager@TEST file=d:daochu.dmp owner=(system,sys)
3 ½«Êý¾Ý¿âÖеıíinner_notify¡¢notify_ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ