[Home] [Help]
PACKAGE: APPS.EDW_SIZE_WRAPPER
Source
1 PACKAGE EDW_SIZE_WRAPPER AUTHID CURRENT_USER AS
2 /* $Header: EDWAUTSS.pls 115.7 2002/12/05 23:22:36 sbuenits noship $*/
3
4
5 PROCEDURE function_call(errbuf OUT NOCOPY VARCHAR2,
6 retcode OUT NOCOPY VARCHAR2,
7 p_log_name IN VARCHAR2,
8 p_from_date IN VARCHAR2,
9 p_to_date IN VARCHAR2,
10 p_input_num_rows IN NUMBER DEFAULT 0,
11 p_custom IN NUMBER DEFAULT 0,
12 p_commit_size IN NUMBER DEFAULT 10000);
13
14 PROCEDURE calculate_detail(p_avg_row_len NUMBER, p_num_rows NUMBER);
15
16 PROCEDURE print_f (v_TABLE_OWNER VARCHAR2,
17 v_FROM_DATE VARCHAR2,
18 v_TO_DATE VARCHAR2,
19 v_TEMP_SIZE_SOURCE NUMBER,
20 v_AVG_ROW_LEN_STAGE NUMBER,
21 v_AVG_ROW_LEN NUMBER,
22 v_AVG_ROW_LEN_IND_S NUMBER,
23 v_AVG_ROW_LEN_IND NUMBER,
24 v_NUM_ROWS NUMBER,
25 v_TABLE_SIZE_STAGE NUMBER,
26 v_INDEX_SIZE_STAGE NUMBER,
27 v_TABLE_SIZE NUMBER,
28 v_INDEX_SIZE NUMBER,
29 v_TEMP_SIZE NUMBER,
30 v_RB_SIZE NUMBER,
31 v_TEMP_TABLE_SIZE NUMBER,
32 v_TOTAL_PEM_SPACE NUMBER,
33 v_TOTAL_TMP_SPACE NUMBER);
34
35
36 PROCEDURE print_m (v_TABLE_OWNER VARCHAR2,
37 v_FROM_DATE VARCHAR2,
38 v_TO_DATE VARCHAR2,
39 v_AVG_ROW_LEN_STAGE NUMBER,
40 v_AVG_ROW_LEN_LEVEL NUMBER,
41 v_AVG_ROW_LEN NUMBER,
42 v_AVG_ROW_LEN_IND_S NUMBER,
43 v_AVG_ROW_LEN_IND_L NUMBER,
44 v_AVG_ROW_LEN_IND NUMBER,
45 v_NUM_ROWS NUMBER,
46 v_TABLE_SIZE_STAGE NUMBER,
47 v_INDEX_SIZE_STAGE NUMBER,
48 v_TABLE_SIZE_LEVEL NUMBER,
49 v_INDEX_SIZE_LEVEL NUMBER,
50 v_TABLE_SIZE NUMBER,
51 v_INDEX_SIZE NUMBER,
52 v_TEMP_SIZE NUMBER,
53 v_RB_SIZE NUMBER,
54 v_TEMP_TABLE_SIZE NUMBER,
55 v_TOTAL_PEM_SPACE NUMBER,
56 v_TOTAL_TMP_SPACE NUMBER);
57
58 PROCEDURE show_results (errbuf OUT NOCOPY VARCHAR2,
59 retcode OUT NOCOPY VARCHAR2,
60 p_log_name IN VARCHAR2);
61
62 g_table_name VARCHAR2(70) := 'null';
63 g_table_type VARCHAR2(30) := 'null';
64 g_log_name VARCHAR2(200) := 'null';
65 g_schema VARCHAR2(30) := 'null';
66 g_message VARCHAR2(2000) := 'null';
67 g_from_date DATE;
68 g_to_date DATE;
69 g_custom NUMBER;
70 g_commit_size NUMBER;
71 g_all_index_space NUMBER := 0;
72 g_all_table_space NUMBER := 0;
73
74
75 END;