Query To Check Concurrent Program Run History in EBS
The following query will help you to find the history of concurrent programs run in your EBS environment. You should connect to ‘apps’ user for executing this query and query…
Read MoreHow to create or rebuild Context file in database DB Tier on R12.2
1. Find out the Template file. [oracle@ebs bin]$ cd $ORACLE_HOME [oracle@ebs 12.1.0]$ cd appsutil/template/ [oracle@ebs template]$ pwd /u01/StageR122/PROD/12.1.0/appsutil/template [oracle@ebs template]$ ls -l adxdbctx.tmp -rwxrwxrwx 1 oracle oinstall 23871 Dec 29…
Read MoreUseful CRSCTL Commands
STOP & START CRS: ( run from root user) $GRID_HOME/bin/crsctl stop crs $GRID_HOME/bin/crsctl start crs Enable/Disable auto restart of CRS. $GRID_HOME/bin/crsctl disable crs $GRID_HOME/bin/crsctl enable crs Find the cluster name…
Read MoreJob DDL
Creates the DDL for the specified job:- SET LONG 20000 LONGCHUNKSIZE 20000 PAGESIZE 0 LINESIZE 1000 FEEDBACK OFF VERIFY OFF TRIMSPOOL ON BEGIN DBMS_METADATA.set_transform_param (DBMS_METADATA.session_transform, 'SQLTERMINATOR', true); DBMS_METADATA.set_transform_param (DBMS_METADATA.session_transform, 'PRETTY',…
Read MoreDDL of Foreign key
Script to create foreign key DDL on all tables. SET LONG 20000 LONGCHUNKSIZE 20000 PAGESIZE 0 LINESIZE 1000 FEEDBACK OFF VERIFY OFF TRIMSPOOL ON BEGIN DBMS_METADATA.set_transform_param (DBMS_METADATA.session_transform, 'SQLTERMINATOR', true); DBMS_METADATA.set_transform_param…
Read MoreThe SQLAccess Advisor
DBMS_ADVISOR :- 1. Gather a number of SQL statements that will form the tuning workload. 2. Check that the user running DBMS_ADVISOR has the ADVISOR privilege, and has SELECT access…
Read MoreUseful TFACTL Commands
1. Check tfactl status with version: tfactl status 2. Check tfactl tool status: tfactl toolstatus 3. Get config details: tfactl print config 4. List of user having access to tfactl:…
Read MorePDB Lockdown Profiles In Oracle 12.2
ALTER LOCKDOWN PROFILE statement to alter a PDB lockdown profile. You can use PDB lockdown profiles in a multitenant environment to restrict user operations in pluggable databases (PDBs). Create a…
Read MoreSGA TARGET ADVISORY IN ORACLE
The V$SGA_TARGET_ADVICE view provides information that helps us in deciding optimal value for SGA_TARGET. MMON background process gather statistics about sga_target usage and update the V$SGA_TARGET_ADVICE view. Check sga target advisory is…
Read MoreSQL Profiles & Baselines
To check SQL Profile : select NAME,SIGNATURE ,STATUS,FORCE_MATCHING from dba_sql_profiles; ENABLE/DISABLE/DROP EXEC DBMS_SQLTUNE.ALTER_SQL_PROFILE(‘coe_5273fz2cqkk80_3455548535′,’STATUS’,’DISABLED’); exec dbms_sqltune.drop_sql_profile(‘coe_5273fz2cqkk80_3455548535’); SQL Profiles for a sql_id set lines 1000 pages 9999 col name for a30 col…
Read More