forked from BobyAlamsyah/oracle_db_monitoring
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathrun_all.sql
executable file
·122 lines (60 loc) · 3.08 KB
/
run_all.sql
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
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
!echo ==========================================================================Cek FRA====================================================================================
@02.cek_fra.sql
!echo ==========================================================================BACKUP=====================================================================================
!echo
@03.cek_backup.sql
!echo =========================================================================diskgroup===================================================================================
!echo
@04.cek_diskgroup.sql
!echo =============================================================================GAP=====================================================================================
!echo
@08.cek_GAP.sql
!echo ===========================================================================DES=======================================================================================
!echo
@09.cek_dest.sql
!echo ============================================================================ASM======================================================================================
!echo
@10.cek_free_ASM.sql
!echo =======================================================================TableSpace HUBNRTPDB==========================================================================
!echo
show pdbs
alter session set container = HUBNRTPDB;
show con_name
!echo
@01.cek_tablespaces.sql
!echo
!echo ========================================================================TableSpace HUBCCPDB==========================================================================
!echo
show pdbs
alter session set container = HUBCCPDB;
show con_name
!echo
@01.cek_tablespaces.sql
!echo
!echo ========================================================================cek auto_extend HUBNRTPDB ===================================================================
!echo
alter session set container = HUBNRTPDB;
show con_name
@10.cek_autoextend.sql
!echo
!echo ========================================================================cek auto_extend HUBCCPDB ===================================================================
!echo
alter session set container = HUBCCPDB;
show con_name
@10.cek_autoextend.sql
!echo
!echo ========================================================================active session ==========================================================================
!echo
@11.cek_active_session.sql
!echo
!echo ========================================================================locking session ==========================================================================
!echo
@12.cek_locking_session.sql
!echo
!echo ========================================================================blocking session ==========================================================================
!echo
@13.cek_blocking_session.sql
!echo
!echo ========================================================================active session ==========================================================================
!echo
@15.cek_count_active_session.sql