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...
top of page
LazyDeploy.com
It's just one click!
Search
mdvorkin
- Oct 27, 2021
- 1 min
Cancelled scheduled concurrent requests
This SQL query returns all concurrent requests that were scheduled in the past and are not scheduled currently. It can be used for...
4 views0 comments
mdvorkin
- Oct 27, 2021
- 2 min
Foreign key constraint violation
/* This PL/SQL script checks violations of foreign key constraints Example of the tables: CREATE TABLE temp_supplier ( supplier_id...
2 views0 comments
mdvorkin
- Sep 30, 2021
- 1 min
From Concurrent to Trace
-- Find running concurrent request's database session SELECT fcr.request_id, ftl.user_concurrent_program_name program_name, v.meaning...
4 views0 comments
mdvorkin
- Jan 21, 2021
- 2 min
After logon trigger - trace user sessions
-- Activate trace for sessions using after logon database trigger -- -- Tables: -- -- SYS.XX_LOGIN_TRACE_CONDITION - add here the...
115 views0 comments
mdvorkin
- Dec 10, 2020
- 1 min
INCLUDE parameter of expdp
-- Export all public database links expdp user/password full=y \ include=db_link:"in (select db_link from dba_db_links where owner =...
14 views0 comments
mdvorkin
- Dec 10, 2020
- 1 min
Multiplexing Redo Log and Control files
-- List redo log files select group#, member from v$logfile order by group#, member; -- Check redo log file status select group#,...
1 view0 comments
mdvorkin
- Dec 4, 2020
- 1 min
APEX - change user's password
sqlplus / as sysdba select owner, table_name from dba_tables where table_name = upper('wwv_flow_fnd_user'); -- Change schema name to...
17 views0 comments
mdvorkin
- Dec 4, 2020
- 1 min
UNDO management
-- UNDO tablespace space select tablespace_name tablespace, status, sum(bytes)/1024/1024 MB, count(*) counts from dba_undo_extents group...
3 views0 comments
mdvorkin
- Dec 3, 2020
- 1 min
Running EBS concurrent requests
select fpro.os_process_id pid, fcr.request_id, to_char(fcr.actual_start_date, 'DD/MM/YYYY HH24:MI:SS') start_date,...
3 views0 comments
mdvorkin
- Dec 3, 2020
- 1 min
Database locks
select /*+ ORDERED */ w.session_id waiting_session, h.session_id holding_session, w.lock_type, h.mode_held, w.mode_requested,...
2 views0 comments
mdvorkin
- Dec 3, 2020
- 1 min
Viewing EBS user's sessions
-- Change SYSADMIN to whatever you need SELECT DISTINCT usr.user_name, TO_CHAR(icx.last_connect,'DD/MM/YYYY HH24:MI:SS') connect_time,...
2 views0 comments
mdvorkin
- Nov 24, 2020
- 1 min
Decrypt user's password in EBS
-- Create java function for decrypting password -- key - apps password (upper case) -- value - encrypted user password create or replace...
6 views0 comments
mdvorkin
- Nov 19, 2020
- 8 min
Personalization and Diagnostics links in EBS 12.1.3
In Oracle Applications there are several options allowing developers to change application behavior without altering code. This can be...
13 views0 comments
mdvorkin
- Nov 19, 2020
- 1 min
Database Users (with last password change date)
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...
2 views0 comments
mdvorkin
- Nov 19, 2020
- 1 min
System Dump and Hang Analyze
System Dump (should be done 3 times with intervals of at least 1 min): sqlplus "/ as sysdba" oradebug setmypid oradebug unlimit oradebug...
3 views0 comments
mdvorkin
- Nov 19, 2020
- 1 min
Pipelined Function
create type int_set as table of integer; / create or replace function numerator return int_set pipelined is i integer := 0; begin i := 0;...
2 views0 comments
mdvorkin
- Nov 19, 2020
- 1 min
Performance Events
Event 10046 (Query Execution Plan trace) alter session set timed_statistics = true; alter session set statistics_level = ALL; alter...
20 views0 comments
mdvorkin
- Nov 19, 2020
- 1 min
ORA-1693: max # extents 505 reached in lobsegment
Solve the following error in init.ora: ORA-1693: max # extents 505 reached in lobsegment APPLSYS.SYS_LOB0000255319C00040$$ sqlplus system...
11 views0 comments
mdvorkin
- Nov 19, 2020
- 1 min
Flashback Query Example
-- Change table name and interval to whatever you need select * from fnd_user as of timestamp (systimestamp - interval '10' minute);
4 views0 comments
bottom of page