Oracle : Important Queries for Data Pump

—– Create user for using EXPDP/IMPDP : create user admin identified by PW;grant connect,resource to admin;grant unlimited tablespace to admin;grant create any view to admin;create or replace directory DBA_EXPORT as ‘/u01/app/oracle/admin/cloud12c/dpdump’ grant write on directory DBA_EXPORT to admin;grant EXP_FULL_DATABASE to admin;grant IMP_FULL_DATABASE to admin; —–… Read More

Oracle : Important Queries for Checking Temp Usage.

Checking Default_Temp_Tablespace :  col property_name for a35 col property_value for a20 col description for a45 set linesize 300 SELECT * FROM DATABASE_PROPERTIES where PROPERTY_NAME=’DEFAULT_TEMP_TABLESPACE’;   Temp tablespace usage : set linesize 300 SELECT A.tablespace_name tablespace, D.mb_total, SUM (A.used_blocks * D.block_size) / 1024 / 1024 mb_used,… Read More

Oracle : Important Queries for RMAN

RMAN Backup Size :  set linesize 300 SET TERMOUT OFF; COLUMN current_instance NEW_VALUE current_instance NOPRINT; SELECT rpad(instance_name, 17) current_instance FROM v$instance; SET TERMOUT ON; PROMPT PROMPT +————————————————————————+ PROMPT | Report : RMAN Status | PROMPT | Instance : &current_instance | PROMPT +————————————————————————+ SET ECHO OFF… Read More