FilesExpand file tree

master

/

awr-show-baselines.sh

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

79 lines (54 loc) · 1.21 KB

master

/

awr-show-baselines.sh

Copy path

Top

File metadata and controls

• Code
• Blame

79 lines (54 loc) · 1.21 KB

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

69

70

71

72

73

74

75

76

77

78

79

#!/usr/bin/env bash

getInstance () {

local pinst=$1

[ -z "$pinst" ] && {

echo "getInstance: pinst arg is empty" 1>&2

echo ''

return

}

# return instance name if pmon exists

# there are 3 nodes, so make it generic

declare testIns

# space if standalone

# digit for RAC - checks up to 4 nodes

for orainst in ' ' 1 2 3 4

do

testInst=$(ps -eo cmd | grep "[o]ra_pmon_${pinst}${orainst}$")

if [[ -n $testInst ]]; then

echo ${pinst}${orainst}

return

fi

done

echo ''

return

}

runSQL () {

local dbName=$1

local instName=$2

local script=$3

. oraenv <<< $psid > /dev/null

export ORACLE_SID=$instName

sqlplus -s -L / as sysdba <<-EOF

set timing on

set tab off

set pause off echo off

set linesize 200 trimspool on

set pagesize 5000

@$script

exit

EOF

}

declare rptDir=awr-reports

for psid in $(grep -Ev '^\s*$|^#|^-MGM|^\+ASM' /etc/oratab| cut -f1 -d:)

do

localInst=$(getInstance $psid)

echo

echo " database: $psid"

echo " instance: $localInst"

echo

export ORACLE_SID=$localInst

# run just this line for testing the script

#runSQL $psid $localInst showdb

runSQL $psid $localInst awr_display_baselines

echo "======================================================"

done