SET SERVEROUTPUT ON DECLARE v_used_bytes NUMBER(10); v_Allocated_Bytes NUMBER(10); BEGIN DBMS_SPACE.CREATE_INDEX_COST ( ‘ create index PROD.INDEX1 on PROD.EMP(EMPNO)’, v_used_Bytes, v_Allocated_Bytes ); DBMS_OUTPUT.PUT_LINE(‘Used Bytes MB: ‘ || round(v_used_Bytes/1024/1024)); DBMS_OUTPUT.PUT_LINE(‘Allocated Bytes MB: ‘…
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 MoreDescription: TO Solve Image loading issue in Apex (Images Not working properly). Steps: Query and steps to find the Apex user details. ROOT@AWSCLD_DEV> select username from dba_users where username like…
Read MoreThe data in a GTT is written to the temporary tablespace, which is not directly protected by redo, so using a GTT improves performance by reducing redo generation. Unfortunately, prior…
Read MoreWhat is it? In previous releases the database stored compilation and execution statistics in a shared sql area which is non persistent. Starting in 12c the database can use a…
Read MoreDuring tuning a query, I found one table has stale statistics. While running gather stats for that table, got below error. Let me demonstrate with a demo table: SQL> execute…
Read More