top of page
Search

System Dump and Hang Analyze

Updated: Mar 16, 2021

System Dump (should be done 3 times with intervals of at least 1 min):


sqlplus "/ as sysdba"

oradebug setmypid

oradebug unlimit

oradebug dump systemstate 10

oradebug tracefile_name

exit;



Hanganalyze:


sqlplus "/ as sysdba"

oradebug setmypid

oradebug unlimit

oradebug hanganalyze 3

exit;

 
 
 

Recent Posts

See All
Get DDL for Oracle object

set feed off set long 1000000 set longchunksize 1000000 set pages 0 set lines 32767 set trimspool on set feed off set wrap on set...

 
 
 
Foreign key constraint violation

/* This PL/SQL script checks violations of foreign key constraints Example of the tables: CREATE TABLE temp_supplier ( supplier_id...

 
 
 

Comments


bottom of page