Language/Java2009.11.01 00:59
Java SE Previous Releases Downloads for Windows

  • J2SE 5.0 Documentation
  • J2SE 1.4.2 Documentation
  • J2SE 1.3.1 Documentation
  • 저작자 표시 비영리 동일 조건 변경 허락
    Posted by the Creater, Shon
    ERP/SAP2009.10.20 23:11
    sapdp##    32##/tcp    # SAP Dispatcher.          3200 + System Number
    sapgw##    33##/tcp    # SAP Gateway.(RFC)        3300 + System Number
    sapsp##    34##/tcp    #                          3400 + System Number
    sapms##    36##/tcp    # SAP Message Server.      3600 + System Number
    sapdp##s   47##/tcp    # SAP Secure Dispatcher.   4700 + System Number
    sapgw##s   48##/tcp    # SAP Secure Gateway.      4800 + System Number


    from: http://ondemand.tistory.com/16
    저작자 표시 비영리 동일 조건 변경 허락
    Posted by the Creater, Shon
    DataBase/Oracle2009.10.08 11:09
    SQL> ALTER SESSION SET optimizer_mode=ALL_ROWS;
    SQL> ALTER SESSION SET sql_trace=FALSE;
    SQL> ALTER SESSION SET EVENTS '10053 trace name context forever, level {1/2}';
    SQL> 분석 대상 SQL문
    SQL> ALTER SESSION SET EVENTS '10053 trace name context off';


    SQL> SHOW PARAMETER USER_DUMP_DEST

    NAME                                 TYPE        VALUE
    ------------------------------------ ----------- ------------------------------
    user_dump_dest                       string      D:\ORACLE\PRODUCT\10.2.0\ADMIN
                                                     \ORCL\UDUMP

    SQL> EXEC DBMS_APPLICATION_INFO.SET_CLIENT_INFO('trace_analyze');
    SQL> SELECT  'ORCL_ORA_'||b.spid||'.trc' "Trace Files"
      2  FROM V$SESSION a, V$PROCESS b
      3  WHERE a.PADDR = b.ADDR and a.CLIENT_INFO = 'trace_analyze';

    위의 user_dump_dest에 해당하는 경로에서 최근의 trace file을 편집기로 열어서, 'GENERAL PLANS'라는 문자열을 검색한다.
    Join order 항목에서 조인 순서를 확인

    SQL> EXEC SYS.DBMS_SYSTEM.SET_EV (<SID>, <SERIAL#>, 10053, {1/2},")
    SQL> EXEC SYS.DBMS_SYSTEM.SET_EV (<SID>, <SERIAL#>, 10053, 0,")
    저작자 표시 비영리 동일 조건 변경 허락
    Posted by the Creater, Shon
    TAG 10g, Trace, Tuning

    http://www.vmware.com/download/player/download.html
     

    VMware Player 2.5.3 for Windows

    Latest Version: 2.5.3 | 2009/08/21 | Build: 185404

    md5sum: fe28f193374c9457752ee16cd6cad4e7

    VMware Player 2.5.3 for Linux (.rpm)

    Latest Version: 2.5.3 | 2009/08/21 | Build: 185404

    md5sum: c99cd65f19fdfc7651bcb7f328b73bc2

    VMware Player 2.5.3 for Linux (.bundle)

    Latest Version: 2.5.3 | 2009/08/21 | Build: 185404

    md5sum: 210f4cb5615bd3b2171bc054b9b2bac5

    VMware Player 2.5.3 - 64-bit (.rpm)

    Latest Version: 2.5.3 | 2009/08/21 | Build: 185404

    md5sum: f91576ef90b322d83225117ae9335968

    VMware Player 2.5.3 - 64-bit (.bundle)

    Latest Version: 2.5.3 | 2009/08/21 | Build: 185404

    md5sum: 595d44d7945c129b1aeb679d2f001b05

    저작자 표시 비영리 동일 조건 변경 허락
    Posted by the Creater, Shon
    TAG vmware
    OS/Linux2009.09.15 20:33
    server 0.asia.pool.ntp.org
    server 1.asia.pool.ntp.org
    server 2.asia.pool.ntp.org
    server 3.asia.pool.ntp.org

    저작자 표시 비영리 동일 조건 변경 허락
    Posted by the Creater, Shon