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;
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...
This SQL query returns all concurrent requests that were scheduled in the past and are not scheduled currently. It can be used for...
/* This PL/SQL script checks violations of foreign key constraints Example of the tables: CREATE TABLE temp_supplier ( supplier_id...
Comments