We use the below procedure to ping hosts and based on availability send SMS to our team. The SMS is…
Tag Check
The script below can be used to check the Disk Group Space Free and also Check Directory sizes for each…
Query to check sessions writing to flashcache on Exadata select se.sid, sn.name, s.value, se.program from v$sesstat s natural join v$statname…
export MMSG=/tmp/$$.mail export ADDR=”shadab@easyoradba.com” export ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1 export ORACLE_SID=orcl file=/tmp/${$}_`date +%Y%m%d` sqlplus -s “/as sysdba” << .eof > $file set pages…
The below simple shell script will check all filesystems and create output file for only filesystems which are more than…
The Below Shell Script checks the Filesystem mount points and using AWK outputs all filesystem exceeding 90% space to a…
Script to check no. of cores being utilized by a process in linux. Save the script below as a shell…
COLUMN object_name FORMAT A40 COLUMN number_of_blocks FORMAT 999,999,999,999 SELECT o.object_name, COUNT(*) number_of_blocks FROM DBA_OBJECTS o, V$BH bh WHERE o.data_object_id =…
http://gavinsoorma.com/2012/11/ash-and-awr-performance-tuning-scripts/
The Exadata Smart Flash Cache is a great Performance optimizer. The contents of the flash cache can be read fro…
set lines 999 select GROUP_NUMBER,NAME,TOTAL_MB/1024/1024 as “Total Space in TB” ,FREE_MB/1024/1024 as “Free Space in TB” ,DATABASE_COMPATIBILITY from v$asm_diskgroup;