GXCollOracleSoapHelper.java
25.7 KB
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
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
package com.sitech.ismp.coll.tivoli;
public class GXCollOracleSoapHelper {
private static String HUB_NAME=SoapParam.getString("HUB_NAME");
private static String USER ="sysadmin";
private static String PASSWORD= SoapParam.getString("PASS");
//CM-00-03-01-03 数据库的位数 32/64位 ua 得到数据 BORACLEINF00 BORACLEINFDBBIT00.DB_BIT
public static String getSoap_total_BORACLEINFDBBIT00(String sid,String host_name)
{
StringBuffer result = new StringBuffer();
String OBJECT="BORACLEINFDBBIT00";
result.append(" <CT_Get> ");
result.append(" <hub>"+HUB_NAME+"</hub> ");
result.append(" <object>"+OBJECT+"</object> ");
result.append(" <target>"+sid+":"+host_name+":ORA</target> ");
result.append(" <userid>"+USER+"</userid> ");
result.append(" <password>"+PASSWORD+"</password> ");
result.append(" <history>N</history> ");
//attributes
result.append(" <attribute> DB_BIT </attribute> ");
result.append(" </CT_Get> ");
return result.toString();
}
//CM-00-03-01-06 归档日志目录 如果采用归档方式，则列出归档日志目录 ua 得到数据 BORACLEINF00 BORACLEINFARCHIVEPATH00.ARCHIVEVALUE
public static String getSoap_total_BORACLEINFARCHIVEPATH00(String sid,String host_name)
{
StringBuffer result = new StringBuffer();
String OBJECT="BORACLEINFARCHIVEPATH00";
result.append(" <CT_Get> ");
result.append(" <hub>"+HUB_NAME+"</hub> ");
result.append(" <object>"+OBJECT+"</object> ");
result.append(" <target>"+sid+":"+host_name+":ORA</target> ");
result.append(" <userid>"+USER+"</userid> ");
result.append(" <password>"+PASSWORD+"</password> ");
result.append(" <history>N</history> ");
//attributes
result.append(" <attribute> ARCHIVEVALUE </attribute> ");
result.append(" </CT_Get> ");
return result.toString();
}
/*
PM-00-03-003-01 读操作次数 该表空间的读操作次数 oracle ua 得到数据 tablespacewr BORACLEINFTABSPACEWR00.PHYREAD
PM-00-03-003-02 写操作次数 该表空间的写操作次数 oracle ua 得到数据 tablespacewr BORACLEINFTABSPACEWR00.PHYWRITE
*/
//public static String getSoap_total_BORACLEINFTABSPACEWR00(String sid,String host_name)
/*yangzhi 20060924*/
public static String getSoap_total_BORACLEINFTABSPACEWR00(String sid,String host_name)
{
StringBuffer result = new StringBuffer();
String OBJECT="BORACLEINFTABSPACEWR00";
result.append(" <CT_Get> ");
result.append(" <hub>"+HUB_NAME+"</hub> ");
result.append(" <object>"+OBJECT+"</object> ");
result.append(" <target>"+host_name+":BORACLEINF00</target> ");
result.append(" <userid>"+USER+"</userid> ");
result.append(" <password>"+PASSWORD+"</password> ");
result.append(" <history>N</history> ");
//attributes
result.append(" <attribute> PHYREAD </attribute> ");
result.append(" <attribute> PHYWRITE </attribute> ");
result.append(" </CT_Get> ");
return result.toString();
}
/**
* CM-00-03-004-05 是否有分区 指该表是分区表还是变通表 ua 得到数据 WORACLEINF00 WORACLEINFPARTITIONED00.PARTITIONED
* lianlian 2006-08-18
*/
//public static String getSoap_WORACLEINFPARTITIONED00(String host_name,String table_name)
public static String getSoap_WORACLEINFPARTITIONED00(String host_name)
{
StringBuffer result = new StringBuffer();
String OBJECT="BORACLEINFPARTITIONED00";
result.append(" <CT_Get> ");
result.append(" <hub>"+HUB_NAME+"</hub> ");
result.append(" <object>"+OBJECT+"</object> ");
result.append(" <target>"+host_name+":BORACLEINF00</target> ");
result.append(" <userid>"+USER+"</userid> ");
result.append(" <password>"+PASSWORD+"</password> ");
result.append(" <history>N</history> ");
//attributes
result.append(" <attribute> TABLENAME </attribute> ");
result.append(" <attribute> PARTITIONED </attribute> ");
//result.append(" <afilter>TABLENAME;EQ;" + table_name + "</afilter> ");
result.append(" </CT_Get> ");
return result.toString();
}
/**
* CM-00-03-001-06 归档日志目录 如果采用归档方式，则列出归档日志目录 ua 得到数据 WORACLEINF00 WORACLEINFARCHIVEPATH00.ARCHIVEVALUE
* lianlian 2006-08-17
*/
public static String getSoap_WORACLEINFARCHIVEPATH000(String host_name)
{
StringBuffer result = new StringBuffer();
String OBJECT="BORACLEINFARCHIVEPATH00";
result.append(" <CT_Get> ");
result.append(" <hub>"+HUB_NAME+"</hub> ");
result.append(" <object>"+OBJECT+"</object> ");
result.append(" <target>"+host_name+":BORACLEINF00</target> ");
result.append(" <userid>"+USER+"</userid> ");
result.append(" <password>"+PASSWORD+"</password> ");
result.append(" <history>N</history> ");
//attributes
result.append(" <attribute> ARCHIVEVALUE </attribute> ");
result.append(" </CT_Get> ");
return result.toString();
}
/**
* CM-00-03-001-03 数据库的位数 32/64位 ua 得到数据 WORACLEINF00 WORACLEINFDBBIT00.DB_BIT
* lianlian 2006-08-17
*/
public static String getSoap_WORACLEINFDBBIT00(String host_name)
{
StringBuffer result = new StringBuffer();
String OBJECT="BORACLEINFDBBIT00";
result.append(" <CT_Get> ");
result.append(" <hub>"+HUB_NAME+"</hub> ");
result.append(" <object>"+OBJECT+"</object> ");
result.append(" <target>"+host_name+":BORACLEINF00</target> ");
result.append(" <userid>"+USER+"</userid> ");
result.append(" <password>"+PASSWORD+"</password> ");
result.append(" <history>N</history> ");
//attributes
result.append(" <attribute> DB_BIT </attribute> ");
result.append(" </CT_Get> ");
return result.toString();
}
/**
* PM-00-03-003-01 读操作次数 该表空间的读操作次数 oracle ua 得到数据 tablespacewr WORACLEINFTABSPACEWR00.PHYREAD
* PM-00-03-003-02 写操作次数 该表空间的写操作次数 oracle ua 得到数据 tablespacewr WORACLEINFTABSPACEWR00.PHYWRITE
* lianlian 2006-08-17
*/
public static String getSoap_WORACLEINFTABSPACEWR00(String host_name)
{
StringBuffer result = new StringBuffer();
String OBJECT="BORACLEINFTABSPACEWR00";
result.append(" <CT_Get> ");
result.append(" <hub>"+HUB_NAME+"</hub> ");
result.append(" <object>"+OBJECT+"</object> ");
result.append(" <target>"+host_name+":BORACLEINF00</target> ");
result.append(" <userid>"+USER+"</userid> ");
result.append(" <password>"+PASSWORD+"</password> ");
result.append(" <history>N</history> ");
//attributes
result.append(" <attribute> TABSPACENAME </attribute> ");
result.append(" <attribute> PHYREAD </attribute> ");
result.append(" <attribute> PHYWRITE </attribute> ");
result.append(" </CT_Get> ");
return result.toString();
}
//PM-00-03-008-01 锁数量
//Oracle_Contention_Summary Total_DML_Locks 1 得到数据 contention PM-00-03-08-01 锁数量 数据库内当前锁的总数 13
public static String getSoap_total_Oracle_Contention_Summary(String sid , String host_name)
{
StringBuffer result = new StringBuffer();
String OBJECT="Oracle_Contention_Summary";
result.append(" <CT_Get> ");
result.append(" <hub>"+HUB_NAME+"</hub> ");
result.append(" <object>"+OBJECT+"</object> ");
result.append(" <target>"+sid+":"+host_name+":ORA</target> ");
result.append(" <userid>"+USER+"</userid> ");
result.append(" <password>"+PASSWORD+"</password> ");
result.append(" <history>N</history> ");
//attributes
result.append(" <attribute> Total_DML_Locks </attribute> ");
result.append(" </CT_Get> ");
return result.toString();
}
//CM-00-03-001-05 归档方式
//Oracle_Database Archive_Log_Mode_Enabled 1 得到数据 situations-oracle-Oracle Databases CM-00-03-01-05 归档方式 日志归档方式信息 25
public static String getSoap_total_Oracle_Database(String sid , String host_name)
{
StringBuffer result = new StringBuffer();
String OBJECT="Oracle_Database";
result.append(" <CT_Get> ");
result.append(" <hub>"+HUB_NAME+"</hub> ");
result.append(" <object>"+OBJECT+"</object> ");
result.append(" <target>"+sid+":"+host_name+":ORA</target> ");
result.append(" <userid>"+USER+"</userid> ");
result.append(" <password>"+PASSWORD+"</password> ");
result.append(" <history>N</history> ");
//attributes
result.append(" <attribute> Archive_Log_Mode_Enabled </attribute> ");
result.append(" <attribute> Database_Name </attribute> ");
result.append(" </CT_Get> ");
return result.toString();
}
//PM-00-03-07-02 竞争情况 数据库日志空间或回滚段数据快等待操作占总操作的百分比情况可以其显示竞争情况
//给出的值不明确,暂不采集
//Oracle_Logging_Summary Total_Header_Waits/Total_Header_Gets 1 得到数据 situations-oracle-Logging Summary attributes PM-00-03-07-02 竞争情况 数据库日志空间或回滚段数据快等待操作占总操作的百分比情况可以其显示竞争情况 12
public static String getSoap_total_Oracle_Logging_Summary(String sid , String host_name)
{
StringBuffer result = new StringBuffer();
String OBJECT="Oracle_Logging_Summary";
result.append(" <CT_Get> ");
result.append(" <hub>"+HUB_NAME+"</hub> ");
result.append(" <object>"+OBJECT+"</object> ");
result.append(" <target>"+sid+":"+host_name+":ORA</target> ");
result.append(" <userid>"+USER+"</userid> ");
result.append(" <password>"+PASSWORD+"</password> ");
result.append(" <history>N</history> ");
//attributes
result.append(" <attribute> Total_Header_Waits </attribute> ");
result.append(" <attribute> Total_Header_Gets </attribute> ");
result.append(" </CT_Get> ");
return result.toString();
}
//CM-00-03-05-01 回滚段名
//CM-00-03-05-02 回滚段大小
//Oracle_Rollback_Segments Rollback_Segment_Name n 得到数据 situations-oracle-Rollback Segments CM-00-03-05-01 回滚段名 数据库日志空间或回滚段名 35
// Oracle_Rollback_Segments Rollback_Segment_Size n 得到数据 situations-oracle-Rollback Segments CM-00-03-05-02 回滚段大小 数据库的回滚段的大小（MB） 36
//CM-00-03-05-01 回滚段名
//CM-00-03-05-02 回滚段大小
//Oracle_Rollback_Segments Rollback_Segment_Name n 得到数据 situations-oracle-Rollback Segments CM-00-03-05-01 回滚段名 数据库日志空间或回滚段名 35
// Oracle_Rollback_Segments Rollback_Segment_Size n 得到数据 situations-oracle-Rollback Segments CM-00-03-05-02 回滚段大小 数据库的回滚段的大小（MB） 36
public static String getSoap_total_Oracle_Rollback_Segments(String sid , String host_name)
{
StringBuffer result = new StringBuffer();
String OBJECT="Oracle_Rollback_Segments";
result.append(" <CT_Get> ");
result.append(" <hub>"+HUB_NAME+"</hub> ");
result.append(" <object>"+OBJECT+"</object> ");
result.append(" <target>"+sid+":"+host_name+":ORA</target> ");
result.append(" <userid>"+USER+"</userid> ");
result.append(" <password>"+PASSWORD+"</password> ");
result.append(" <history>N</history> ");
//attributes
result.append(" <attribute> Rollback_Segment_Name </attribute> ");
result.append(" <attribute> Rollback_Segment_Size </attribute> ");
result.append(" </CT_Get> ");
return result.toString();
}
//Oracle_Server Server_CPU_Percent 1 得到数据 processors PM-00-03-009-01 CPU占用率 其对应操作一天内平均占用CPU时间 14
//Oracle_Server Server_Status 1 得到数据 servers FM-00-03-001-01 数据库状态 数据库是否可用 17
//Oracle_Server Server_Version 1 得到数据 servers CM-00-03-001-02 版本信息 数据库版本信息 22
//Oracle_Server Total_SGA_Size 1 得到数据 situations-oracle-Server attributes CM-00-03-002-01 共享内存的大小 共享内存的设定大小（MB） 27
public static String getSoap_total_Oracle_Server(String sid , String host_name)
{
StringBuffer result = new StringBuffer();
String OBJECT="Oracle_Server";
result.append(" <CT_Get> ");
result.append(" <hub>"+HUB_NAME+"</hub> ");
result.append(" <object>"+OBJECT+"</object> ");
result.append(" <target>"+sid+":"+host_name+":ORA</target> ");
result.append(" <userid>"+USER+"</userid> ");
result.append(" <password>"+PASSWORD+"</password> ");
result.append(" <history>N</history> ");
//attributes
result.append(" <attribute> Server_CPU_Percent </attribute> ");
result.append(" <attribute> Server_Status </attribute> ");
result.append(" <attribute> Server_Version </attribute> ");
result.append(" <attribute> Total_SGA_Size </attribute> ");
result.append(" </CT_Get> ");
return result.toString();
}
//begin 2006-7-7 lianlian
/*CM-00-03-004-02 该表建表的空间初始值 Oracle_Tablespaces.Initial_Extent_Size
* CM-00-03-004-03 该表下次空间扩展值 Oracle_Tablespaces.Next_Extent_Size
* CM-00-03-004-04 该表空间扩展的扩展最大次数 Oracle_Tablespaces.Max_Extents_Specifie
* CM-00-03-002-01 该表已经完成的扩展次数 Oracle_Tablespace.Number Extents
*/
public static String getSoap_total_Oracle_Tablespaces(String sid,String host_name)
{
StringBuffer result = new StringBuffer();
String OBJECT="Oracle_Tablespaces";
result.append(" <CT_Get> ");
result.append(" <hub>"+HUB_NAME+"</hub> ");
result.append(" <object>"+OBJECT+"</object> ");
result.append(" <target>"+sid+":"+host_name+":ORA</target> ");
result.append(" <userid>"+USER+"</userid> ");
result.append(" <password>"+PASSWORD+"</password> ");
result.append(" <history>N</history> ");
//attributes
result.append(" <attribute> Tablespace_Name </attribute> ");
result.append(" <attribute> Initial_Extent_Size </attribute> ");
result.append(" <attribute> Next_Extent_Size </attribute> ");
result.append(" <attribute> Max_Extents_Specified </attribute> ");
result.append(" <attribute> Number_Extents </attribute> ");
result.append(" <attribute> Percent_Free_Space </attribute> ");
result.append(" </CT_Get> ");
return result.toString();
}
//end
/**
*CM-00-03-004-01 表名 数据库特定表名称 Table Name 得到数据 situations-oracle-Oracle Tablespaces WORACLEINFPARTITIONED00.TABLENAME
*lianlian 2006-08-18
*/
//public static String getSoap_total_Oracle_Table_Summary(String sid,String host_name,String table_name)
public static String getSoap_WORACLEINFPARTITIONED00_BY_TABLENAME(String sid,String host_name,String table_name)
{
StringBuffer result = new StringBuffer();
String OBJECT="BORACLEINFPARTITIONED00";
result.append(" <CT_Get> ");
result.append(" <hub>"+HUB_NAME+"</hub> ");
result.append(" <object>"+OBJECT+"</object> ");
result.append(" <target>"+host_name+":BORACLEINF00</target> ");
result.append(" <userid>"+USER+"</userid> ");
result.append(" <password>"+PASSWORD+"</password> ");
result.append(" <history>N</history> ");
//attributes
result.append(" <attribute> TABLENAME </attribute> ");
result.append(" <afilter>TABLENAME;EQ;" + table_name + "</afilter> ");
result.append(" </CT_Get> ");
return result.toString();
}
//begin 2006-7-7 lianlian CM-00-03-01-04 指数据库已经安装的选项，如分区、并行等 Par-Q Avail, Par-S Avail
public static String getSoap_total_Oracle_Server_Options(String sid,String host_name)
{
StringBuffer result = new StringBuffer();
String OBJECT="Oracle_Server_Options";
result.append(" <CT_Get> ");
result.append(" <hub>"+HUB_NAME+"</hub> ");
result.append(" <object>"+OBJECT+"</object> ");
result.append(" <target>"+sid+":"+host_name+":ORA</target> ");
result.append(" <userid>"+USER+"</userid> ");
result.append(" <password>"+PASSWORD+"</password> ");
result.append(" <history>N</history> ");
//attributes
result.append(" <attribute> Par-Q_Avail </attribute> ");
result.append(" <attribute> Par-S_Avail </attribute> ");
result.append(" </CT_Get> ");
return result.toString();
}
//end
//Oracle_Session_Summary Total_Sessions 1 得到数据 sessions PM-00-03-09-03 会话数量 数据库的当前会话数 16
public static String getSoap_total_Oracle_Session_Summary(String sid , String host_name)
{
StringBuffer result = new StringBuffer();
String OBJECT="Oracle_Session_Summary";
result.append(" <CT_Get> ");
result.append(" <hub>"+HUB_NAME+"</hub> ");
result.append(" <object>"+OBJECT+"</object> ");
result.append(" <target>"+sid+":"+host_name+":ORA</target> ");
result.append(" <userid>"+USER+"</userid> ");
result.append(" <password>"+PASSWORD+"</password> ");
result.append(" <history>N</history> ");
//attributes
result.append(" <attribute> Total_Sessions </attribute> ");
result.append(" </CT_Get> ");
return result.toString();
}
//Oracle_SGA_Memory 100-SGA_Percent_Free 1 得到数据 servers PM-00-03-01-01 共享内存使用百分比 共享内存已经利用的部分占总体的百分比 1
//Oracle_SGA_Memory 100-SGA_Percent_Free 1 得到数据 servers PM-00-03-09-02 内存的占用率 一天内平均占用内存的资源情况 15
public static String getSoap_total_Oracle_SGA_Memory(String sid , String host_name)
{
StringBuffer result = new StringBuffer();
String OBJECT="Oracle_SGA_Memory";
result.append(" <CT_Get> ");
result.append(" <hub>"+HUB_NAME+"</hub> ");
result.append(" <object>"+OBJECT+"</object> ");
result.append(" <target>"+sid+":"+host_name+":ORA</target> ");
result.append(" <userid>"+USER+"</userid> ");
result.append(" <password>"+PASSWORD+"</password> ");
result.append(" <history>N</history> ");
//attributes
result.append(" <attribute> SGA_Percent_Free </attribute> ");
result.append(" </CT_Get> ");
return result.toString();
}
//Oracle_SGA_Memory 100-SGA_Percent_Free 1 得到数据 servers PM-00-03-01-01 共享内存使用百分比 共享内存已经利用的部分占总体的百分比 1
//Oracle_SGA_Memory 100-SGA_Percent_Free 1 得到数据 servers PM-00-03-09-02 内存的占用率 一天内平均占用内存的资源情况 15
public static String getSoap_total_Oracle_Statistics_Summary(String sid , String host_name)
{
StringBuffer result = new StringBuffer();
String OBJECT="Oracle_Statistics_Summary";
result.append(" <CT_Get> ");
result.append(" <hub>"+HUB_NAME+"</hub> ");
result.append(" <object>"+OBJECT+"</object> ");
result.append(" <target>"+sid+":"+host_name+":ORA</target> ");
result.append(" <userid>"+USER+"</userid> ");
result.append(" <password>"+PASSWORD+"</password> ");
result.append(" <history>N</history> ");
//attributes
result.append(" <attribute> Data_Cache_Hit_Percent </attribute> ");
result.append(" <attribute> Total_Deadlocks </attribute> ");
result.append(" <attribute> Physical_Reads </attribute> ");
result.append(" <attribute> Physical_Writes </attribute> ");
result.append(" </CT_Get> ");
return result.toString();
}
//Oracle_SGA_Memory 100-SGA_Percent_Free 1 得到数据 servers PM-00-03-01-01 共享内存使用百分比 共享内存已经利用的部分占总体的百分比 1
//Oracle_SGA_Memory 100-SGA_Percent_Free 1 得到数据 servers PM-00-03-09-02 内存的占用率 一天内平均占用内存的资源情况 15
public static String getSoap_total_Oracle_Files(String sid , String host_name)
{
StringBuffer result = new StringBuffer();
String OBJECT="Oracle_Files";
result.append(" <CT_Get> ");
result.append(" <hub>"+HUB_NAME+"</hub> ");
result.append(" <object>"+OBJECT+"</object> ");
result.append(" <target>"+sid+":"+host_name+":ORA</target> ");
result.append(" <userid>"+USER+"</userid> ");
result.append(" <password>"+PASSWORD+"</password> ");
result.append(" <history>N</history> ");
//attributes
result.append(" <attribute> File_Name </attribute> ");
result.append(" </CT_Get> ");
return result.toString();
}
// Oracle_Tablespaces Percent_Free_Space PM-00-03-004-01 表空间使用率 该表可用空间的百分比
// Oracle_Tablespaces Free_Space_Fragmentation PM-00-03-006-01 碎片程度 该表空间的碎片程度百分比
// Oracle_Tablespaces Tablespace_Status FM-00-03-001-02 表空间状态 表空间所处状态
// Oracle_Tablespaces Percent_Free_Space FM-00-03-002-04 表空间使用率 该表可用空间的百分比
// Oracle_Tablespaces Tablespace_Name CM-00-03-003-01 表空间名 数据库内各表空间名
// Oracle_Tablespaces Total_Size CM-00-03-003-01 表空间大小 数据库内各表空间大小（MB）
public static String getSoap_tbspaces_Oracle_Tablespaces(String sid , String host_name)
{
StringBuffer result = new StringBuffer();
String OBJECT="Oracle_Tablespaces";
result.append(" <CT_Get> ");
result.append(" <hub>"+HUB_NAME+"</hub> ");
result.append(" <object>"+OBJECT+"</object> ");
result.append(" <target>"+sid+":"+host_name+":ORA</target> ");
result.append(" <userid>"+USER+"</userid> ");
result.append(" <password>"+PASSWORD+"</password> ");
result.append(" <history>N</history> ");
//attributes
result.append(" <attribute> Percent_Free_Space </attribute> ");
result.append(" <attribute> Free_Space_Fragmentation </attribute> ");
result.append(" <attribute> Tablespace_Status </attribute> ");
result.append(" <attribute> Percent_Free_Space </attribute> ");
result.append(" <attribute> Tablespace_Name </attribute> ");
result.append(" <attribute> Total_Size </attribute> ");
result.append(" </CT_Get> ");
return result.toString();
}
public static void main(String[] args){
/*可被管理的Oracle节点
* <Name>isdb2:ISDB2:ORA</Name>
* <Name>isdb1:ISDB1:ORA</Name>
* <Name>settle1:settle1:ORA</Name>
* <Name>settle2:settle2:ORA</Name>
* <Name>dwdb:BOSS:ORA</Name>
* <Name>billing1:billing1:ORA</Name>
* <Name>billing2:billing2:ORA</Name>
* <Name>crmdb1:crmdb1:ORA</Name>
* <Name>crmdb2:crmdb2:ORA</Name>
* <Name>BIDW1:BIDW1:ORA</Name>
* <Name>crmdb3:crmdb3:ORA</Name>
*/
//String sid="rac1"; //大小写敏感
//String host_name="RAC1"; //大小写敏感
//String sid="billing1"; //大小写敏感
//String host_name="billing1"; //大小写敏感
String sid="billing1"; //大小写敏感
String host_name="billing1"; //大小写敏感
//BIDW2
//System.out.print(getSoap_total_Oracle_Contention_Summary(sid,host_name));
//System.out.print(getSoap_total_Oracle_Database(sid,host_name));
//System.out.print(getSoap_total_Oracle_Logging_Summary(sid,host_name));
//System.out.print(getSoap_total_Oracle_Rollback_Segments(sid,host_name));
// System.out.print(getSoap_total_Oracle_Server(sid,host_name));
//System.out.print(getSoap_total_Oracle_Session_Summary(sid,host_name));
//System.out.print(getSoap_total_Oracle_SGA_Memory(sid,host_name));
//System.out.print(getSoap_total_Oracle_Statistics_Summary(sid,host_name));
//System.out.print(getSoap_total_Oracle_Files(sid,host_name));
System.out.println(GXCollOracleSoapHelper.getSoap_WORACLEINFARCHIVEPATH000(host_name));
System.out.println(GXCollOracleSoapHelper.getSoap_WORACLEINFDBBIT00(host_name));
System.out.println(GXCollOracleSoapHelper.getSoap_WORACLEINFTABSPACEWR00(host_name));
System.out.println(GXCollOracleSoapHelper.getSoap_WORACLEINFPARTITIONED00_BY_TABLENAME(sid,host_name,"aa"));
//getSoap_total_BORACLEINFARCHIVEPATH00
//getSoap_total_BORACLEINFDBBIT00
//getSoap_total_Oracle_Table_Summary
//System.out.println(CollOracleSoapHelper.getSoap_tbspaces_Oracle_Tablespaces(sid,host_name,"a"));
//getSoap_total_Oracle_Tablespaces
System.out.println(CollOracleSoapHelper.getSoap_tbspaces_Oracle_Tablespaces(sid,host_name));
}
}