Oracle (36) 썸네일형 리스트형 dump JAVA_POOL EJD@/oracle/app/admin/EJD/udump> exit SQL> oradebug setmypid Statement processed. SQL> oradebug unlimit Statement processed. SQL> alter session set tracefile_identifier='JAVA_POOL'; Session altered. SQL> oradebug dump heapdump 128 Statement processed. SQL> oradebug close_trace Statement processed. SQL> host EJD@/oracle/app/admin/EJD/udump> ls /oracle/app/admin/EJD/udump/ejd_ora_2683086_JAVA_POOL.. Dump PGA_UGA /oracle/app/admin/EJD/udump/ejd_ora_2093200_PGA_UGA.trc *** TRACE DUMP CONTINUED FROM FILE /oracle/app/admin/EJD/udump/ejd_ora_2093200.trc *** *** 2011-07-30 08:11:09.135 ****************************************************** HEAP DUMP heap name="session heap" desc=110456928 extent sz=0xff80 alt=32767 het=32767 rec=0 flg=2 opc=2 parent=110176e08 owner=70000008d981ef0 nex=0 xsz=0xff80 EXTENT 0 ad.. Dump Large Pool in SGA /oracle/app/admin/EJD/udump/ejd_ora_2093200_LARGE_POOL.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 Redo thread mounted by this instance: 1 Oracle proces.. Session trace with SQL Execution *** 2011-07-30 18:55:37.226 WAIT #1: nam='SQL*Net message from client' ela= 0 driver id=1650815232 #bytes=1 p3=0 obj#=253 tim=62695328646755 ===================== PARSING IN CURSOR #3 len=82 dep=0 uid=0 oct=3 lid=0 tim=62695328647823 hv=3635516245 ad='7397b058' select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where rownum < 10 END OF STMT PARSE #3:c=0,e=926,p=0,cr=0,cu=0,mis=1,r=.. Expert Oracle Database Architecture (written by Tom ) http://www.amazon.com/Expert-Oracle-Database-Architecture-Programming/dp/1430229462/ref=sr_1_6?ie=UTF8&qid=1311777235&sr=8-6 Expert Oracle Database Architecture: Oracle Database 9i, 10g, and 11g Programming Techniques and Solutions [Paperback] List price : $59.99 http://www.yes24.com/24/Goods/3685944?Acode=101 ( 93,610 KRW ) Look like more expensive, maybe due to the shipping cost. Book : Expert.. SYS.DBMS_JOB.SUBMIT( , , , , ) 시스템에서 매일 ETL 해야 할 작업을 선 프로시져로 생성하고 Oracle 에서 Job 을 걸었다. ( 매일아침 돌고 있음. BEGIN SYS.DBMS_JOB.REMOVAL(141); -- 잡 삭제 COMMIT; END;/ -- 여기서부터 실제 잡 생성 시작 Declare X Number; Begin SYS.DBMS_JOB.SUBMIT (job => X ,what => 'EJMIS.LEDGER_MIGRATION_DAILY;' -- 실행시키고자 하는 프로시져 명 ,next_date => to_date('29-07-2011 06:00:00', 'dd/mm/yyyy hh24:mi:ss') -- 언제부터 ,interval => 'TRUNC(SYSDATE+1) + 6/24' -- 어떤 주기로 돌 것인지 ,no_p.. latch: shared pool select * from v$session_event where wait_class# in (2,4) order by Total_Waits desc --event like '%latch%' select wait_class, count(*), sum(total_waits), sum(time_waited) from v$session_event group by wait_class order by sum(total_waits) desc select wait_class, Event, count(*), sum(total_waits), sum(time_waited) from v$session_event group by wait_class, Event order by sum(total_waits) desc select.. PL/SQL Block 에서 DDL 사용하기 PL/SQL Block 에서 DDL 사용하기 --************************************************************* BEGIN EXECUTE IMMEDIATE 'Drop Table PJSegmentOnly'; EXECUTE IMMEDIATE 'Create Table PJSegmentOnly AS Select "SegmentID" SEGMENTID from PassengerJourneyLeg@NaviODS'; END; --************************************************************* -->> Delete Insert 보다 속도면에서 유리함. --Delete PJSegmentOnly -- ; -- Commit --; .. 이전 1 2 3 4 5 다음