1 PACKAGE dbms_summary authid current_user
2 /*
3 || Program: dbms_summary
4 || Author: William D. Norcott, Oracle Corportation
5 || File: dbmssum.sql
6 || Created: September 11, 1997 15:11:36
7 */
8 IS
9 -- Package global variables
10 dimensionnotfound EXCEPTION;
11
12 -- Package constant variables
13
14 -- Interface for private trace facility used by the advisor
15 PROCEDURE set_logfile_name(filename IN VARCHAR2 );
16
17 -- PROCEDURE DBMS_SUMMARY.VALIDATE_DIMENSION
18 -- PURPOSE: To verify that the relationships specified in a DIMENSION
19 -- are correct. Offending rowids are stored in advisor repository
20 -- PARAMETERS:
21 -- dimension_name: VARCHAR2
22 -- Name of the dimension to analyze
23 --
24 -- dimension_owner: VARCHAR2
25 -- Owner of the dimension
26 --
27 -- incremental: BOOLEAN (default: TRUE)
28 -- If TRUE, then tests are performed only for the rows specified
29 -- in the sumdelta$ table for tables of this dimension; if FALSE,
30 -- check all rows.
31 --
32 -- check_nulls: BOOLEAN (default: FALSE)
33 -- If TRUE, then all level columns are verified to be non-null;
34 -- If FALSE, this check is omitted. Specify FALSE when non-nullness
35 -- is guaranteed by other means, such as NOT NULL constraints.
36 --
37 -- EXCEPTIONS:
38 -- dimensionnotfound The specified dimension was not found
39 PROCEDURE validate_dimension
40 (
41 dimension_name IN VARCHAR2,
42 dimension_owner IN VARCHAR2,
43 incremental IN BOOLEAN,
44 check_nulls IN BOOLEAN);
45
46
47 -- PROCEDURE DBMS_SUMMARY.ESTIMATE_MVIEW_SIZE
48 -- PURPOSE: Estimate materialized size in terms of rows and bytes
49 -- PARAMETERS:
50 -- stmt_id: NUMBER
51 -- User-specified id
52 -- select_clause: VARCHAR@
53 -- SQL text for the defining query
54 -- num_row: NUMBER
55 -- Estimated number of rows
56 -- num_col: NUMBER
57 -- Estimated number of bytes
58 -- COMMENTS:
59 -- This procedure requires that 'utlxplan.sql' be executed
60 PROCEDURE estimate_mview_size (
61 stmt_id IN VARCHAR2,
62 select_clause IN VARCHAR2,
63 num_rows OUT NUMBER,
64 num_bytes OUT NUMBER);
65 PROCEDURE enable_dependent (
66 detail_tables IN VARCHAR2);
67
68 PROCEDURE disable_dependent (
69 detail_tables IN VARCHAR2);
70
71 END dbms_summary;