-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathcreate_TABLE.sql
110 lines (103 loc) · 2.21 KB
/
create_TABLE.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
CREATE TABLE PERFSTAT.T_TIME_MOD
(
FECHA DATE,
STATNAM VARCHAR2(64 BYTE) NOT NULL,
TDIFS NUMBER,
PCTDB NUMBER,
ORDER_COL NUMBER
)
TABLESPACE TS_STAT_DAT
PCTUSED 0
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 64K
NEXT 1M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
LOGGING
NOCACHE;
CREATE TABLE PERFSTAT.TOP_N_WAIT
(
FECHA DATE,
EVENT VARCHAR2(64 BYTE) NOT NULL,
WAITS NUMBER,
TIME NUMBER,
AVWAIT NUMBER
)
TABLESPACE TS_STAT_DAT
PCTUSED 0
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 64K
NEXT 1M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
LOGGING
NOCACHE;
CREATE TABLE PERFSTAT.T_WAITS
(
SAMPLE_TIME VARCHAR2(16 BYTE),
HORA NUMBER,
SCHEDULER NUMBER,
UIO NUMBER,
SIO NUMBER,
CONCURRENCY NUMBER,
APPLICATION NUMBER,
COMMIT NUMBER,
CONFIGURATION NUMBER,
ADMINISTRATIVE NUMBER,
NETWORK NUMBER,
QUEUEING NUMBER,
CLUST NUMBER,
OTHER NUMBER,
NUM_CPU NUMBER
)
TABLESPACE TS_STAT_DAT
PCTUSED 0
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 64K
NEXT 1M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
LOGGING
NOCACHE;
CREATE TABLE PERFSTAT.T_CPU
(
SAMPLE_TIME VARCHAR2(16 BYTE),
HORA NUMBER,
TOTAL_CPU NUMBER,
F_CPU NUMBER,
B_CPU NUMBER,
CPU_MAQUINA NUMBER
)
TABLESPACE TS_STAT_DAT
PCTUSED 0
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 64K
NEXT 1M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
LOGGING
NOCACHE;