Tablespace Management. Tablespace and datafile related dba tables dba_tablespacedba_data_filesdba_temp_files Tablepace Queries. To Create New Tablespace.create tablespace tablespace_name datafile ‘location/tablespace_name.dbf’ size 2g; Add new datafile to the tablespace.Alter tablespace add datafile…
Read Morecustom forms: select COUNT(*) from apps.fnd_form_vl where form_name like ‘XX%’ custom form personalization: SELECT ffcr.form_name, ffft.user_function_name “User Form Name”, ffcr.SEQUENCE, ffcr.description, ffcr.rule_type, ffcr.enabled, ffcr.trigger_event, ffcr.trigger_object, ffcr.condition, ffcr.fire_in_enter_query, (SELECT user_name FROM…
Read MoreMAKE DIRECTORY: mkdir /u01/ords cd /u01/ords unzip ords.3.0.9.348.07.16.zip sqlplus / as sysdba select value from v$parameter where name like ‘%service_name%’; cp ords.war ords.war_bkp mv ords.war apex.war BACKUP THE PARAMETER FILE:…
Read MoreThese steps are used to avoid the autoconfig phas error in R12.2 Steps:login as applsys user conn applsys/*********** Backup the following Tables. create table fnd_oam_context_files_bkp as select * from fnd_oam_context_files;…
Read MoreStop the application services. 2. Take backup of the context file 3. Run Autoconfig. 4. Start the Application services. 5. Evaluate the Instance is working as desired. CHANGED PARAMETERS…
Read MoreDescription: Query to find Custom objects , custom forms , custom form personalization , custom concurrent programs. custom objects: ——————– select * from dba_objects where (upper(object_name) like ‘XX%’ or upper(OBJECT_NAME)…
Read MoreDescription: QUERY TO FIND THE DETAILS OF CONCURRENT REQUESTS WAIT FOR MORE THAN ONE HOUR. Query: set head on; set feed off; set pages 0; set verify off; set feedback…
Read MoreDescription: Check the Details of which scheduled jobs are finished with error in database level. Query: set head on; set feed off; set pages 0; set verify off; set feedback…
Read MoreDescription: Script for more Session count Alert ( get mail more than 90 sessions were opened ) Steps: select to_char(sysdate,’dd-mm-yy:HH:MM:SS’) from dual; set feedback off set serveroutput on — spool…
Read MoreDescription: Shrink FND_LOG_MESSAGES table size for gain more free space. Steps: select owner, segment_name, bytes/1024/1024/1024 gb from dba_segments where segment_type = ‘TABLE’ and segment_name = ‘FND_LOG_MESSAGES’; SQL> alter table applsys.fnd_log_messages…
Read More