 |
|
DBMS_AW package tips
Oracle Tips by Burleson Consulting |
DBMS_AW
<< Return to the index
Related notes on DBMS_AW:
Oracle 11g provides the following information about the DBMS_AW package:
Description of the DBMS_AW package:
PROCEDURE DBMS_AW.ADD_DIMENSION_SOURCE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
DIMNAME VARCHAR2 IN
COLNAME VARCHAR2 IN
SOURCES DBMS_AW$_DIMENSION_SOURCES_T IN/OUT
SRCVAL VARCHAR2 IN DEFAULT
DIMTYPE NUMBER IN DEFAULT
HIERCOLS DBMS_AW$_COLUMNLIST_T IN DEFAULT
PARTBY NUMBER IN DEFAULT
PROCEDURE DBMS_AW.ADVISE_CUBE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
AGGMAP VARCHAR2 IN
PCT BINARY_INTEGER IN DEFAULT
COMPRESSED BOOLEAN IN DEFAULT
FUNCTION DBMS_AW.ADVISE_DIMENSIONALITY RETURNS VARCHAR2
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CUBENAME VARCHAR2 IN
SPARSEDFN VARCHAR2 OUT
SPARSENAME VARCHAR2 IN DEFAULT
PARTNUM NUMBER IN DEFAULT
ADVTABLE VARCHAR2 IN DEFAULT
PROCEDURE DBMS_AW.ADVISE_DIMENSIONALITY
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
OUTPUT CLOB OUT
CUBENAME VARCHAR2 IN
SPARSENAME VARCHAR2 IN DEFAULT
DTYPE VARCHAR2 IN DEFAULT
ADVTABLE VARCHAR2 IN DEFAULT
FUNCTION DBMS_AW.ADVISE_PARTITIONING_DIMENSION RETURNS VARCHAR2
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CUBENAME VARCHAR2 IN
DIMSOURCES DBMS_AW$_DIMENSION_SOURCES_T IN
ADVTABLE VARCHAR2 IN DEFAULT
FUNCTION DBMS_AW.ADVISE_PARTITIONING_LEVEL RETURNS VARCHAR2
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CUBENAME VARCHAR2 IN
DIMSOURCES DBMS_AW$_DIMENSION_SOURCES_T IN
ADVTABLE VARCHAR2 IN DEFAULT
PROCEDURE DBMS_AW.ADVISE_REL
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
RELNAME VARCHAR2 IN
VALUESET VARCHAR2 IN
PCT BINARY_INTEGER IN DEFAULT
COMPRESSED BOOLEAN IN DEFAULT
PROCEDURE DBMS_AW.ADVISE_SPARSITY
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
FACT VARCHAR2 IN
CUBENAME VARCHAR2 IN
DIMSOURCES DBMS_AW$_DIMENSION_SOURCES_T IN
ADVMODE BINARY_INTEGER IN DEFAULT
PARTBY BINARY_INTEGER IN DEFAULT
ADVTABLE VARCHAR2 IN DEFAULT
PROCEDURE DBMS_AW.AW_ATTACH
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
NAME VARCHAR2 IN
FORWRITE BOOLEAN IN DEFAULT
CREATEAW BOOLEAN IN DEFAULT
ATTARGS VARCHAR2 IN DEFAULT
TBSPACE VARCHAR2 IN DEFAULT
PROCEDURE DBMS_AW.AW_ATTACH
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SCHEMA VARCHAR2 IN
NAME VARCHAR2 IN
FORWRITE BOOLEAN IN DEFAULT
CREATEAW BOOLEAN IN DEFAULT
ATTARGS VARCHAR2 IN DEFAULT
TBSPACE VARCHAR2 IN DEFAULT
PROCEDURE DBMS_AW.AW_COPY
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
OLDNAME VARCHAR2 IN
NEWNAME VARCHAR2 IN
NEWTABLESPACE VARCHAR2 IN DEFAULT
PARTNUM NUMBER IN DEFAULT
PROCEDURE DBMS_AW.AW_COPY
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
OLDSCHEMA VARCHAR2 IN
OLDNAME VARCHAR2 IN
NEWNAME VARCHAR2 IN
NEWTABLESPACE VARCHAR2 IN DEFAULT
PARTNUM NUMBER IN DEFAULT
PROCEDURE DBMS_AW.AW_CREATE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
NAME VARCHAR2 IN
TBSPACE VARCHAR2 IN DEFAULT
PARTNUM NUMBER IN DEFAULT
PROCEDURE DBMS_AW.AW_CREATE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SCHEMA VARCHAR2 IN
NAME VARCHAR2 IN
TBSPACE VARCHAR2 IN DEFAULT
PROCEDURE DBMS_AW.AW_DELETE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
NAME VARCHAR2 IN
PROCEDURE DBMS_AW.AW_DELETE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SCHEMA VARCHAR2 IN
NAME VARCHAR2 IN
PROCEDURE DBMS_AW.AW_DETACH
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
NAME VARCHAR2 IN
PROCEDURE DBMS_AW.AW_DETACH
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SCHEMA VARCHAR2 IN
NAME VARCHAR2 IN
PROCEDURE DBMS_AW.AW_RENAME
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
INNAME VARCHAR2 IN
OUTNAME VARCHAR2 IN
FUNCTION DBMS_AW.AW_TABLESPACE RETURNS VARCHAR2
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SCHEMA VARCHAR2 IN
NAME VARCHAR2 IN
FUNCTION DBMS_AW.AW_TABLESPACE RETURNS VARCHAR2
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
NAME VARCHAR2 IN
PROCEDURE DBMS_AW.AW_UPDATE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
NAME VARCHAR2 IN DEFAULT
PROCEDURE DBMS_AW.AW_UPDATE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SCHEMA VARCHAR2 IN
NAME VARCHAR2 IN
PROCEDURE DBMS_AW.CLEAN_ACCESS_TRACKING
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
OBJNAME VARCHAR2 IN
PROCEDURE DBMS_AW.CONVERT
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
AWNAME VARCHAR2 IN
PROCEDURE DBMS_AW.CONVERT
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
OLDNAME VARCHAR2 IN
NEWNAME VARCHAR2 IN
NEWTABLESPACE VARCHAR2 IN DEFAULT
PROCEDURE DBMS_AW.DISABLE_ACCESS_TRACKING
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
OBJNAME VARCHAR2 IN
PROCEDURE DBMS_AW.EIF_BLOB_IN
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
NAME VARCHAR2 IN
IMPLOB BLOB IN
DATADFNS BINARY_INTEGER IN DEFAULT
OBJLIST EIF_OBJLIST_T IN DEFAULT
PROCEDURE DBMS_AW.EIF_BLOB_IN
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SCHEMA VARCHAR2 IN
NAME VARCHAR2 IN
IMPLOB BLOB IN
DATADFNS BINARY_INTEGER IN DEFAULT
OBJLIST EIF_OBJLIST_T IN DEFAULT
FUNCTION DBMS_AW.EIF_BLOB_OUT RETURNS BLOB
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
NAME VARCHAR2 IN
OBJLIST EIF_OBJLIST_T IN DEFAULT
FUNCTION DBMS_AW.EIF_BLOB_OUT RETURNS BLOB
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SCHEMA VARCHAR2 IN
NAME VARCHAR2 IN
OBJLIST EIF_OBJLIST_T IN DEFAULT
PROCEDURE DBMS_AW.EIF_DELETE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
EIF EIF_T IN/OUT
PROCEDURE DBMS_AW.EIF_IN
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
NAME VARCHAR2 IN
IMPEIF EIF_T IN
DATADFNS BINARY_INTEGER IN DEFAULT
OBJLIST EIF_OBJLIST_T IN DEFAULT
PROCEDURE DBMS_AW.EIF_IN
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SCHEMA VARCHAR2 IN
NAME VARCHAR2 IN
IMPEIF EIF_T IN
DATADFNS BINARY_INTEGER IN DEFAULT
OBJLIST EIF_OBJLIST_T IN DEFAULT
PROCEDURE DBMS_AW.EIF_OUT
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
NAME VARCHAR2 IN
EXPEIF EIF_T OUT
OBJLIST EIF_OBJLIST_T IN DEFAULT
PROCEDURE DBMS_AW.EIF_OUT
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SCHEMA VARCHAR2 IN
NAME VARCHAR2 IN
EXPEIF EIF_T OUT
OBJLIST EIF_OBJLIST_T IN DEFAULT
PROCEDURE DBMS_AW.ENABLE_ACCESS_TRACKING
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
OBJNAME VARCHAR2 IN
FUNCTION DBMS_AW.EVAL_NUMBER RETURNS NUMBER
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CMD VARCHAR2 IN
FUNCTION DBMS_AW.EVAL_TEXT RETURNS VARCHAR2
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CMD VARCHAR2 IN
PROCEDURE DBMS_AW.EXECUTE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CMD VARCHAR2 IN
PROCEDURE DBMS_AW.GATHER_STATS
FUNCTION DBMS_AW.GETLOG RETURNS CLOB
PROCEDURE DBMS_AW.INFILE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
IFILENAME VARCHAR2 IN
PROCEDURE DBMS_AW.INITDRIVER
FUNCTION DBMS_AW.INTERP RETURNS CLOB
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CMD VARCHAR2 IN
FUNCTION DBMS_AW.INTERPCLOB RETURNS CLOB
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CMD_CLOB CLOB IN
PROCEDURE DBMS_AW.INTERP_SILENT
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CMD VARCHAR2 IN
PROCEDURE DBMS_AW.MOVE_AWMETA
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
DEST_TBS VARCHAR2 IN
FUNCTION DBMS_AW.OLAP_ACTIVE RETURNS BOOLEAN
FUNCTION DBMS_AW.OLAP_ON RETURNS BOOLEAN
FUNCTION DBMS_AW.OLAP_RUNNING RETURNS BOOLEAN
FUNCTION DBMS_AW.OLAP_TYPE RETURNS VARCHAR2
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
OTYPE NUMBER IN
PROCEDURE DBMS_AW.PRINTLOG
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
LOG_CLOB CLOB IN
FUNCTION DBMS_AW.PROP_CLOB RETURNS CLOB
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
RID ROWID IN
FUNCTION DBMS_AW.PROP_LEN RETURNS NUMBER
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
RID ROWID IN
FUNCTION DBMS_AW.PROP_VAL RETURNS VARCHAR2
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
RID ROWID IN
PROCEDURE DBMS_AW.RUN
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CMD VARCHAR2 IN
SILENT BOOLEAN IN DEFAULT
PROCEDURE DBMS_AW.RUN
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CMD CLOB IN
SILENT BOOLEAN IN DEFAULT
PROCEDURE DBMS_AW.RUN
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CMD VARCHAR2 IN
OUTPUT VARCHAR2 OUT
PROCEDURE DBMS_AW.RUN
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CMD VARCHAR2 IN
OUTPUT CLOB IN/OUT
PROCEDURE DBMS_AW.RUN
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CMD CLOB IN
OUTPUT VARCHAR2 OUT
PROCEDURE DBMS_AW.RUN
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CMD CLOB IN
OUTPUT CLOB IN/OUT
PROCEDURE DBMS_AW.SHUTDOWN
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
FORCE BOOLEAN IN DEFAULT
PROCEDURE DBMS_AW.SPARSITY_ADVICE_TABLE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
TBLNAME VARCHAR2 IN DEFAULT
PROCEDURE DBMS_AW.STARTUP
PROCEDURE DBMS_AW.TOGGLEDBCREATE
 |
If you like Oracle tuning, see the book "Oracle
Tuning: The Definitive Reference", with 950 pages of tuning tips and
scripts.
You can buy it direct from the publisher for 30%-off and get
instant access to the code depot of Oracle tuning scripts. |
 |
 |
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
