-- 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);

1. How does NLS affect import/export? Import and export are client products, in the same way as SQL*Plus or Oracle Forms, and will...

-- Change SYSADMIN to whatever you need select distinct u.user_name, r.responsibility_name, g.start_date, g.end_date from...

Cancell all requests submitted by a user -- Change user name to whatever you need update FND_CONCURRENT_REQUESTS set phase_code = 'C',...

select s.user_name, per.full_name, p.user_concurrent_program_name || nvl2(r.description,' ('||r.description||')',null) program,...