ASM file can be copied to remote asm instance(diskgroup) using asmcmd command. SYNTAX asmcmd> cp – -port asm_port file_name remote_asm_user/remote_asm_pwd@remote_host:Instancce_name:TARGET ASM_PATH ASMCMD> cp –port 1521 s_srv_new21.dbf sys/oracle@172.20.17.69.+ASM1:+ARCL/s_srv_new21.dbf
Read Moreselect sql_id,object_owner,object_name from V$SQL_PLAN where operation=’TABLE ACCESS’ and options=’FULL’ and object_owner not in (‘SYS’,’SYSTEM’,’DBSNMP’);
Read MoreSET 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 More