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

oracleÖØÔØ²Ù×÷·ûµÄÀý×Ó

ת×Ô£ºhttp://download.oracle.com/docs/cd/B13789_01/server.101/b10759/statements_6004.htm
Creating User-Defined Operators: Example
This example creates a very simple functional implementation of equality and then creates an operator that uses the function:
CREATE FUNCTION eq_f(a VARCHAR2, b VARCHAR2) RETURN NUMBER AS
BEGIN
IF a = b THEN RETURN 1;
ELSE RETURN 0;
END IF;
END;
/
CREATE OPERATOR eq_op
BINDING (VARCHAR2, VARCHAR2)
RETURN NUMBER
USING eq_f;


Ïà¹ØÎĵµ£º

Oracle Flashback Technology


Oracle Flashback Technology
Oracle Flashback Technology reduces recovery time from hours to minutes.
from: http://www.oracle.com/technology/deploy/availability/htdocs/Flashback_Overview.htm
According to many studies, 40% of application outages are caused by operator or user errors. Part of be ......

ÓëoracleÊý¾Ý¿âÁ¬½ÓÎÊÌâ

       Èç¹û²»ÊÇÒòΪÕâ´Î»»hisµÄ·þÎñÆ÷£¬¹À¼ÆÎÒÒ»Ö±Ò²²»»áÓöµ½Õâ¸öÎÊÌ⣬һֱ¾õµÃoracleºÜ¸ßÉ¶ÔËüҲûÓÐÑо¿£¬¿ÉÕâ´Î»»·þÎñÆ÷£¬Æ«Æ«ÈÃÎÒÓöµ½ÁËÒ»¸öÎÊÌ⣬ÕÛÄ¥ÁËÕûÕûÁ½Ì죬ÖÕÓÚÔÚ×òÌì½â¾öµôÁË£¬¼Ç¼ÏÂÀ´£¬ÒÔ±¸ÒÔºóËùÓá£
    ÖÜÎåÍíÉÏ»»ÁË·þÎñÆ÷£¬ÖÜÒ»ÔçÉÏ·¢ÏÖ³¬ÉùµÄ¹¤×÷Õ ......

OracleÊý¾ÝÎļþÇ¨ÒÆÖª¶àÉÙ£¿

±¾ÈËÒÔǰÕûÀíµÄÊý¾Ý¿âÎļþÇ¨ÒÆ¹ý³Ì£¬Ï£ÍûÄܹ»¶Ô´ó¼ÒÓÐËù°ïÖú
1¡¢sqlplus "sys/sys@·þÎñÃû as sysdba"
 
2¡¢Ð޸ĿØÖÆÎļþ:
 
    alter system set control_files='E:\oracle\oradata\myOracle_1\control01.ctl',
 'E:\oracle\oradata\myOracle_1\control02.ctl','E:\oracle\oradata\my ......

linuxÏÂoracleÆô¶¯¹ý³Ì

ÔÚlinuxÏÂÆô¶¯oracle ºÍÔÚwindowsÊÇÓвî±ðµÄ£¬¶ÔÓÚÒ»°ãÔÚwindowsϲÙ×÷ϰ¹ßÈËÓкܶ಻ÊÊÓ¦£¬ËùÒÔÎÒÌØ±ðдÕâÑùÎÄÕ£¬ÒÔ·½±ãÐÂÊÖ½øÐвÙ×÷£¬ÏÂÃæ¾ÍÒ»²½Ò»²½½²½âÆô¶¯¹ý³Ì¡£
1.ͨ¹ýÖÕ¶ËÁ¬½Óµ½linux·þÎñÆ÷,µ±È»ÕâÑùµÄÈí¼þºÜ¶àÀýÈçputty,SecureCRT,²¢ÒÔoracleÓû§½øÐеǼ£¬·ñÔòÆô¶¯oracleʱ»á´íµÄ£¬Ã»ÓÐȨÏÞÆô¶¯.(Ò²¿ÉÓû§root µ ......

oracle ÓÅ»¯Ö® ÕÒ³öµÍЧÂÊsql Óï¾ä

SELECT EXECUTIONS , DISK_READS, BUFFER_GETS,
¡¡¡¡ROUND((BUFFER_GETS-DISK_READS)/BUFFER_GETS,2) Hit_radio,
¡¡¡¡ROUND(DISK_READS/EXECUTIONS,2) Reads_per_run,
¡¡¡¡SQL_TEXT
¡¡¡¡from V$SQLAREA
¡¡¡¡WHERE EXECUTIONS>0
¡¡¡¡AND BUFFER_GETS > 0
¡¡¡¡AND (BUFFER_GETS-DISK_READS)/BUFFER_GETS ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ