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