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

Oracle´æ´¢¹ý³ÌʵÀý

×Ô¶¨Ò庯Êý 
--×Ô¶¨Ò庯Êý
CREATE OR REPLACE FUNCTION fn_WFTemplateIDGet
(
    TemplateCategoryID NUMBER,
    OrganID NUMBER,
    TemplateMode NUMBER

RETURN NUMBER
IS
    TemplateID NUMBER;
    ItemCount NUMBER;
BEGIN
    --ȡģ°åÖÐÖ¸¶¨»ú¹¹,Ö¸¶¨·ÖÀàµÄ¹¤×÷Á÷Ä£°å¼Ç¼
    SELECT COUNT(*) INTO ItemCount
    from t_WFTemplate
    WHERE f_OrganID = OrganID AND f_TemplateCategoryID = TemplateCategoryID;
    IF ItemCount = 1 THEN
        SELECT f_TemplateID INTO TemplateID
        from t_WFTemplate
        WHERE f_OrganID = OrganID AND f_TemplateCategoryID = TemplateCategoryID;
    ELSE
        TemplateID := 0;
    END IF;
    RETURN(TemplateID);
END fn_WFTemplateIDGet;
°üÍ·
--°üÍ·
CREATE OR REPLACE PACKAGE pkg_TEMP is
    TYPE curRecordset IS REF CURSOR;
    
    --¹¦ÄÜ£ºÓÉÈËÔ±»ñÈ¡Êý¾Ý
    PROCEDURE up_ModuleShowByEmployeeID
    (
        EmployeeID NUMBER,
        objRs OUT curRecordset
    );
END pkg_TEMP;
°üÌå
--°üÌå
CREATE OR REPLACE PACKAGE BODY pkg_TEMP is
    --¹¦ÄÜ£ºÓÉÈËÔ±»ñÈ¡Êý¾Ý
 &nbs


Ïà¹ØÎĵµ£º

oracle Óαê

1.       Óαê: ÈÝÆ÷£¬´æ´¢SQLÓï¾äÓ°ÏìÐÐÊý¡£
2.       ÓαêÀàÐÍ: ÒþʽÓα꣬ÏÔʾÓα꣬REFÓαꡣÆäÖУ¬ÒþʽÓαêºÍÏÔʾÓαêÊôÓÚ¾²Ì¬Óα꣨ÔËÐÐǰ½«ÓαêÓëSQLÓï¾ä¹ØÁª£©,REFÓαêÊôÓÚ¶¯Ì¬Óαê(ÔËÐÐʱ½«ÓαêÓëSQLÓï¾ä¹ØÁª)¡£
3.      ......

OracleÏÞÖÆIP·ÃÎÊÉèÖÃ

Ò»¡¢$vi $ORACLE_HOME/network/admin/sqlnet.ora
Èç¹û¸Ãsqlnet.oraÎļþ²»´æÔÚ£¬¿ÉÒÔ²ÉÓÃÈçÏ·½Ê½Éú³É
1£©¿ÉÒÔ¿½±´$ORACLE_HOME/network/admin/samples/sqlnet.oraµ½$ORACLE_HOME/network/admin/Ŀ¼ÏÂʹÓÃ
2£©Ê¹ÓÃnetca¹¤¾ß½øÐÐÅäÖã¬NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
 
¶þ¡¢ÉèÖûòÐ޸IJÎÊý£¨Èç¹û²ÎÊ ......

¹ØÓÚOracleÊÂÎñµÄ×ܽá

¹ØÓÚOracleÊÂÎñµÄ×ܽá
1.ʲôÊÇÊÂÎñ£¬ÊÂÎñµÄÌØÐÔÊÇʲô£¿
ÊÂÎñµÄÈÎÎñ±ãÊÇʹÊý¾Ý¿â´ÓÒ»ÖÖ״̬±ä»»³ÉΪÁíÒ»ÖÖ״̬£¬ÕⲻͬÓÚÎļþϵͳ£¬ËüÊÇÊý¾Ý¿âËùÌØÓõġ£ËüµÄÌØÐÔÓÐËĸö£ºTOM×ܽáΪACID¼´
Ô­×ÓÐÔatomicity:Óï¾ä¼¶Ô­×ÓÐÔ£¬¹ý³Ì¼¶Ô­×ÓÐÔ£¬ÊÂÎñ¼¶Ô­×ÓÐÔ
Ò»ÖÂÐÔconsistency:״̬һÖ£¬Í¬Ò»ÊÂÎñÖв»»áÓÐÁ½ÖÖ״̬
¸ôÀëÐÔiso ......

oracle sql tuning

alert index mem_ct monitoring usage;
desc v$object_usage;
set linesize 190
select * from v$object_usage;
SQL>SET AUTOTRACE ON;
¡¡¡¡*autotrace¹¦ÄÜÖ»ÄÜÔÚSQL*PLUSÀïʹÓÃ
¡¡¡¡ÆäËûһЩʹÓ÷½·¨£º
¡¡¡¡2.2.1¡¢ÔÚSQLPLUSÖеõ½Óï¾ä×ܵÄÖ´ÐÐʱ¼ä
¡¡¡¡SQL> set timing on;
2.2.2¡¢Ö»ÏÔʾִÐмƻ®--(»áÍ¬Ê ......

ORACLE DSI ½éÉÜ

DSIÊÇData Server
InternalsµÄËõд,ÊÇOracle¹«Ë¾ÄÚ²¿ÓÃÀ´ÅàѵOracleÊۺ󹤳ÌʦʹÓõĽ̲Ä.ÓÉÓÚijÖÖÔ­ÒòÁ÷Âä½­ºþ,
Êܵ½ÖÚ¶àOracle°®ºÃÕßµÄ×·Åõ, ²»¹ýÒªÊǹ¦Á¦²»µ½, ÔĶÁ·´¶øÎÞÒæ. DSI3ÊÇOracle 8ϵÁеÄ, DSI4ÊÇOracle 9ϵÁеÄ.
ÕâÑùµÄÎĵµÉÏͨ³£¶¼Ó¡×Å:Oracle Confidential:For internal Use Only.
DSI301 Advanced S ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ