自動生成ASH報告指令碼

shawnloong發表於2016-08-22
指令碼

點選(此處)摺疊或開啟

  1. ###################################################################
  2. ## Script:genash.sh      ##
  3. ## Date:2016-08-22 ##
  4. ## Description:del gen ash report and sendport ##
  5. ###################################################################
  6. #!/bin/bash
  7. source /home/oracle/.bash_profile
  8. #if [ $# != 6 ]
  9. #then
  10. #!echo Syntax genash.sh dbid '01/30/11 11:00' duration credentials inst sid
  11. #exit 1
  12. #fi

  14. REMOTE_HOST=10.1.1.1
  15. REMOTE_DIR=/scripts/dbstatus/
  16. REMOTE_USER=access_user
  17. REMOTE_COMMAND="/scripts/sendash.py"
  18. l_dbid=1418194933
  19. l_start_time=`date -d '-3 hours' '+%m/%d/%y %H:%M'`
  20. #l_starttime_log=`echo $l_start_time|sed 's////g' | sed 's/ //'|sed 's/://'`
  21. l_duration=180
  22. l_credentials="dba_monitor/passwd"
  23. l_inst=1
  24. l_sid=$6
  25. l_logdir='/u01/script/awr'
  26. l_ash_log_file=${l_logdir}/ashrpt.html
  27.  
  28. sqlplus -s $l_credentials <<EOC > /tmp/ash.log
  29.  
  30. set head off
  31. set pages 0
  32. set lines 132
  33. set echo off
  34. set feedback off
  35. set termout off
  36.  
  37. define inst_num=${l_inst};
  38. define dbid=${l_dbid};
  39. define report_type='html';
  40. define report_name=${l_ash_log_file};
  41. define begin_time="${l_start_time}";
  42. define duration=${l_duration};
  43. --define target_session_id = ${l_sid};
  44. define target_session_id = '';
  45.  
  46. define slot_width = '';
  47. define target_sql_id     = '';
  48. define target_wait_class = '';
  49. define target_service_hash = '';
  50. define target_module_name = '';
  51. define target_action_name = '';
  52. define target_client_id    = '';
  53. define target_plsql_entry = '';
  54.  
  55. @$ORACLE_HOME/rdbms/admin/ashrpti
  56. EOC

  58. #send email to user
  59. scp ${l_logdir}/ashrpt.html "$REMOTE_USER"@"$REMOTE_HOST":$REMOTE_DIR
  60. ssh $REMOTE_USER@$REMOTE_HOST $REMOTE_COMMAND

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/24486203/viewspace-2123809/，如需轉載，請註明出處，否則將追究法律責任。

相關文章