script for oracle ASM header backup

script for oracle ASM header backup script name: disk_asmheader_backup.sh #!/bin/sh PATH=$PATH:/usr/local/bin;export PATHTIMESTAMP=`date +%Y%m%d` host=`hostname` export ORACLE_SID=`ps -ef | grep pmon | grep +ASM | grep -v “grep pmon” | cut

Undo management in Oracle database

Undo management in Oracle database   Suggestions on Undo management 1. Check for the ACTIVE,UNEXPIRED and EXPIRED blocks(segments). Don’t add space to the UNDO when u receive the alert immediately.

Oracle DB refresh using transportable tablespaces

Using Oracle Transportable Tablespaces to refresh Schemas/Tablespaces in Oracle Databases. Overview of  this activity: System tablespace size increased more than 60GB. Not able to shrink the size of the system

How to get the row count for all tables in a schema?

  How to get the row count in each table of a schema?   Query SQL> select table_name, to_number( extractvalue( xmltype( dbms_xmlgen.getxml(‘select count(*) c from ‘||table_name)) ,’/ROWSET/ROW/C’)) count from all_tables where