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...

-- Find running concurrent request's database session SELECT fcr.request_id, ftl.user_concurrent_program_name program_name, v.meaning...

-- Activate trace for sessions using after logon database trigger -- -- Tables: -- -- SYS.XX_LOGIN_TRACE_CONDITION - add here the...

-- Export all public database links expdp user/password full=y \ include=db_link:"in (select db_link from dba_db_links where owner =...

-- List redo log files select group#, member from v$logfile order by group#, member; -- Check redo log file status select group#,...

sqlplus / as sysdba select owner, table_name from dba_tables where table_name = upper('wwv_flow_fnd_user'); -- Change schema name to...

-- UNDO tablespace space select tablespace_name tablespace, status, sum(bytes)/1024/1024 MB, count(*) counts from dba_undo_extents group...

select fpro.os_process_id pid, fcr.request_id, to_char(fcr.actual_start_date, 'DD/MM/YYYY HH24:MI:SS') start_date,...

select /*+ ORDERED */ w.session_id waiting_session, h.session_id holding_session, w.lock_type, h.mode_held, w.mode_requested,...

-- Change SYSADMIN to whatever you need SELECT DISTINCT usr.user_name, TO_CHAR(icx.last_connect,'DD/MM/YYYY HH24:MI:SS') connect_time,...

-- Create java function for decrypting password -- key - apps password (upper case) -- value - encrypted user password create or replace...

In Oracle Applications there are several options allowing developers to change application behavior without altering code. This can be...

select s.name "User", p.granted_role "Role", s.ptime "Password change date" from dba_role_privs p, sys.user$ s, dba_users d where s.name...

System Dump (should be done 3 times with intervals of at least 1 min): sqlplus "/ as sysdba" oradebug setmypid oradebug unlimit oradebug...

create type int_set as table of integer; / create or replace function numerator return int_set pipelined is i integer := 0; begin i := 0;...

Event 10046 (Query Execution Plan trace) alter session set timed_statistics = true; alter session set statistics_level = ALL; alter...

Solve the following error in init.ora: ORA-1693: max # extents 505 reached in lobsegment APPLSYS.SYS_LOB0000255319C00040$$ sqlplus system...

-- Change table name and interval to whatever you need select * from fnd_user as of timestamp (systimestamp - interval '10' minute);