Skip to main content

Posts

Showing posts from September, 2017

Scheduling AWR from OEM | a PL sql Script

Schedule the below report in OEM. it will generate a report for 12 hour and send to your email box. DECLARE    dbid           NUMBER;    inst_id        NUMBER;    bid            NUMBER;    eid            NUMBER;    db_unique_name VARCHAR2(30);      host_name       VARCHAR2(64);    starttime      CHAR (5);    endtime        CHAR (5);    v_from         VARCHAR2 (80);    v_recipient    VARCHAR2 (80) := '----------------------Email _D----------------';    v_mail_host    VARCHAR2 (30...

Extend FS on Lunux boxes with lvextend

df -h . **************************************************************************************************** /dev/mapper/vg0-appgrid_vol                   30G   29G   26M 100% /app/grid **************************************************************************************************** Node1:root:/root # vgs   VG   #PV #LV #SN Attr   VSize   VFree   vg0    1  23   0 wz--n- 279.16g 75.50g **************************************************************************************************** Node1:root:/root # lvextend -L +10G /dev/mapper/vg0-appgrid_vol -r   Extending logical volume appgrid_vol to 40.00 GiB   Logical volume appgrid_vol successfully resized resize2fs 1.41.12 (17-May-2010) Filesystem at /dev/mapper/vg0-appgrid_vol is mounted on /app/grid; on-line resizing required old desc_blocks = 2, ne...

Check space like df -h on Sun HP-UNIX | Script

df -Pk | awk '{  if ( NR == 1 ) { next }  if ( NF == 6 ) { print }  if ( NF == 5 ) { next }  if ( NF == 1 ) {  getline record;  $0 = $0 record  print $0  }  }' | awk ' BEGIN {print "Filesystem                                    Mount Point                 Total GB   Avail GB    Used GB  Used"        print "--------------------------------------------- ------------------------- ---------- ---------- ---------- -----"} END {print ""} /dev/ || /^[0-9a-zA-Z.]*:\// { printf ("%-45.45s %-25s %10.2f %10.2f %10.2f %4.0f%\n",$1,$6,$2/1024/1024,$4/1024/1024,$3/1024/1024,$5) }'

OEM 12 C OEM -- DISKGROUP STATUS

--Jayesh Pande SELECT a.target_name, t.host_name, a.diskgroup, a.redundancy, a.percent_used, a.total_gb, a.free_gb FROM (     SELECT         target_name,         diskgroup,         MAX (DECODE (seq, 7, VALUE)) REDUNDANCY,         round(MAX (DECODE (seq, 4, VALUE))) PERCENT_USED,         MAX (DECODE (seq, 6, ceil(VALUE/1024))) TOTAL_GB,         MAX (DECODE (seq, 3, ceil(VALUE/1024))) FREE_GB         FROM (                 SELECT                     m.target_name,                       m.key_value diskgroup,          ...