FilesExpand file tree

 master

/

moats_types.sql

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

107 lines (98 loc) · 3.58 KB

 master

/

moats_types.sql

Copy path

Top

File metadata and controls

• Code
• Blame

107 lines (98 loc) · 3.58 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

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

create type moats_v2_ntt as table of varchar2(4000);

/

create type moats_output_ot as object

( output varchar2(4000)

);

/

create type moats_output_ntt as table of moats_output_ot;

/

create type moats_ash_ot as object

( snaptime timestamp

, saddr raw(8)

, sid number

, serial# number

, audsid number

, paddr raw(8)

, user# number

, username varchar2(64)

, command number

, ownerid number

, taddr varchar2(64)

, lockwait varchar2(64)

, status varchar2(64)

, server varchar2(64)

, schema# number

, schemaname varchar2(64)

, osuser varchar2(64)

, process varchar2(64)

, machine varchar2(64)

, terminal varchar2(64)

, program varchar2(64)

, type varchar2(64)

, sql_address raw(8)

, sql_hash_value number

, sql_id varchar2(64)

, sql_child_number number

, prev_sql_addr raw(8)

, prev_hash_value number

, prev_sql_id varchar2(64)

, prev_child_number number

, module varchar2(64)

, module_hash number

, action varchar2(64)

, action_hash number

, client_info varchar2(64)

, fixed_table_sequence number

, row_wait_obj# number

, row_wait_file# number

, row_wait_block# number

, row_wait_row# number

, logon_time date

, last_call_et number

, pdml_enabled varchar2(64)

, failover_type varchar2(64)

, failover_method varchar2(64)

, failed_over varchar2(64)

, resource_consumer_group varchar2(64)

, pdml_status varchar2(64)

, pddl_status varchar2(64)

, pq_status varchar2(64)

, current_queue_duration number

, client_identifier varchar2(64)

, blocking_session_status varchar2(64)

, blocking_instance number

, blocking_session number

, seq# number

, event# number

, event varchar2(64)

, p1text varchar2(64)

, p1 number

, p1raw raw(8)

, p2text varchar2(64)

, p2 number

, p2raw raw(8)

, p3text varchar2(64)

, p3 number

, p3raw raw(8)

, wait_class_id number

, wait_class# number

, wait_class varchar2(64)

, wait_time number

, seconds_in_wait number

, state varchar2(64)

, service_name varchar2(64)

, sql_trace varchar2(64)

, sql_trace_waits varchar2(64)

, sql_trace_binds varchar2(64)

);

/

create type moats_ash_ntt as table of moats_ash_ot;

/

create type moats_stat_ot as object

( type varchar2(100)

, name varchar2(100)

, value number

);

/

create type moats_stat_ntt as table of moats_stat_ot;

/