Oracle (36) 썸네일형 리스트형 Oracle 계정접속(SYS 외) Microsoft Windows [Version 6.1.7601]Copyright (c) 2009 Microsoft Corporation. All rights reserved. C:\Users\Jacob>sqlplus "/as sysdba" SQL*Plus: Release 11.2.0.1.0 Production on 수 1월 13 21:28:18 2016 Copyright (c) 1982, 2010, Oracle. All rights reserved. 다음에 접속됨:Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Applicati.. [1] Oracle 11g 설치하기 [1] Oracle 11g 설치하기 C:\app\Jacob\product\11.2.0\dbhome_1\database\SPFILEORCL.ORA orcl.__java_pool_size=16777216orcl.__large_pool_size=16777216orcl.__oracle_base='C:\app\Jacob'#ORACLE_BASE set from environmentorcl.__pga_aggregate_target=1375731712orcl.__sga_target=2030043136orcl.__shared_io_pool_size=0orcl.__shared_pool_size=452984832orcl.__streams_pool_size=0*.audit_file_dest='C:\app\Jacob\admin.. OLTP, ODS, DSS .... [Terminology] OLTP : Online Transaction Processing ODS : Operational Data Store OLAP : Online Analysis Processing 데이터를 분석 및 읽기작업에 적합하도록 가공 저장 DW : Data Warehoues CRM : Cutomer Relationship KDD : Knowledge Discovery in Database Data Mining : DSS : Descision Support System ETL : Extract Transform and Load 10053 trace 분석 및 체크사항 colored in light blue 10053 trace 분석해보다. 특정부분은 light blue color 를 넣어보았다. SQL> exec dbms_stats.GATHER_TABLE_STATS(OWNNAME=>'SCOTT',TABNAME=>'EMP',ESTIMATE_PERCENT=>DBMS_STATS.AUTO_SAMPLE_SIZE,METHOD_OPT=>'FOR TABLE FOR ALL INDEXES FOR ALL INDEXED COLUMNS' , DEGREE=>5,CASCADE=>TRUE); PL/SQL procedure successfully completed. SQL> exec dbms_stats.GATHER_TABLE_STATS(OWNNAME=>'SCOTT',TABNAME=>'DEPT',ESTIMATE_PERCENT=>DBMS_.. oradebug help SQL> oradebug help HELP [command] Describe one or all commands SETMYPID Debug current process SETOSPID Set OS pid of process to debug SETORAPID ['force'] Set Oracle pid of process to debug SHORT_STACK Dump abridged OS stack DUMP [addr] Invoke named dump DUMPSGA [bytes] Dump fixed SGA DUMPLIST Print a list of available dumps EVENT Set trace event in process SESSION_EVENT Set trace event in sessio.. HangAnalyze 10 *** 2011-07-31 02:54:28.902 ============== HANG ANALYSIS: ============== Open chains found: Other chains found: Chain 1 : : Chain 2 : : Chain 3 : : Chain 4 : : Extra information that will be dumped at higher levels: [level 5] : 4 node dumps -- [SINGLE_NODE] [SINGLE_NODE_NW] [IGN_DMP] [level 10] : 37 node dumps -- [IGN] State of nodes ([nodenum]/cnode/sid/sess_srno/session/ospid/state/start/finis.. Dump systemstate 2 SQL> oradebug dump systemstate 2 Statement processed. /oracle/app/admin/EJD/udump/ejd_ora_2683086_SYSTEM_STATE.trc Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, Data Mining and Real Application Testing options ORACLE_HOME = /oracle/app/product/102 System name:AIX Node name:EJUWED1 Release:3 Version:5 Machine:00C605A24C00 Instance name: EJD Re.. dump heapdump 536870914 (2 + 536870912) KGH Latch Directory Information 계속 반복되는 것 말고 별것이 없어 보인다. SQL> oradebug setmypid Statement processed. SQL> oradebug unlimi ORA-00070: command unlimi is not valid SQL> oradebug unlimit Statement processed. SQL> alter session set tracefile_identifier = 'SGA_TOP_5'; Session altered. SQL> oradebug dump heapdump 536870914 Statement processed. SQL> oradebug close_trace /oracle/app/admin/EJD/udump/ejd_ora_2683086_SGA_TOP_5.trc Oracle .. 이전 1 2 3 4 5 다음
