oracle dbms包和其他包的使用大全 (五)
101 DBMS_SQLTUNE
- Using DBMS_SQLTUNE
- Data Structures
- Subprogram Groups
- Summary
of DBMS_SQLTUNE Subprograms
- ACCEPT_SQL_PROFILE Procedure and Function
- ADD_SQLSET_REFERENCE Function
- ALTER_SQL_PROFILE Procedure
- CANCEL_TUNING_TASK Procedure
- CAPTURE_CURSOR_CACHE_SQLSET Procedure
- CREATE_SQLSET Procedure and Function
- CREATE_STGTAB_SQLPROF Procedure
- CREATE_STGTAB_SQLSET Procedure
- CREATE_TUNING_TASK Functions
- DELETE_SQLSET Procedure
- DROP_SQL_PROFILE Procedure
- DROP_SQLSET Procedure
- DROP_TUNING_TASK Procedure
- EXECUTE_TUNING_TASK Procedure
- INTERRUPT_TUNING_TASK Procedure
- LOAD_SQLSET Procedure
- PACK_STGTAB_SQLPROF Procedure
- PACK_STGTAB_SQLSET Procedure
- REMAP_STGTAB_SQLPROF Procedure
- REMAP_STGTAB_SQLSET Procedure
- REMOVE_SQLSET_REFERENCE Procedure
- REPORT_TUNING_TASK Function
- RESET_TUNING_TASK Procedure
- RESUME_TUNING_TASK Procedure
- SCRIPT_TUNING_TASK Function
- SELECT_CURSOR_CACHE Function
- SELECT_SQLSET Function
- SELECT_WORKLOAD_REPOSITORY Functions
- SQLTEXT_TO_SIGNATURE Function
- UNPACK_STGTAB_SQLPROF Procedure
- UNPACK_STGTAB_SQLSET Procedure
- UPDATE_SQLSET Procedures
102 DBMS_STAT_FUNCS
103 DBMS_STATS
- Using DBMS_STATS
- Summary
of DBMS_STATS Subprograms
- ALTER_DATABASE_TAB_MONITORING Procedure
- ALTER_SCHEMA_TAB_MONITORING Procedure
- ALTER_STATS_HISTORY_RETENTION Procedure
- CONVERT_RAW_VALUE Procedures
- CONVERT_RAW_VALUE_NVARCHAR Procedure
- CONVERT_RAW_VALUE_ROWID Procedure
- CREATE_STAT_TABLE Procedure
- DELETE_COLUMN_STATS Procedure
- DELETE_DATABASE_STATS Procedure
- DELETE_DICTIONARY_STATS Procedure
- DELETE_FIXED_OBJECTS_STATS Procedure
- DELETE_INDEX_STATS Procedure
- DELETE_SCHEMA_STATS Procedure
- DELETE_SYSTEM_STATS Procedure
- DELETE_TABLE_STATS Procedure
- DROP_STAT_TABLE Procedure
- EXPORT_COLUMN_STATS Procedure
- EXPORT_DATABASE_STATS Procedure
- EXPORT_DICTIONARY_STATS Procedure
- EXPORT_FIXED_OBJECTS_STATS Procedure
- EXPORT_INDEX_STATS Procedure
- EXPORT_SCHEMA_STATS Procedure
- EXPORT_SYSTEM_STATS Procedure
- EXPORT_TABLE_STATS Procedure
- FLUSH_DATABASE_MONITORING_INFO Procedure
- GATHER_DATABASE_STATS Procedures
- GATHER_DICTIONARY_STATS Procedure
- GATHER_FIXED_OBJECTS_STATS Procedure
- GATHER_INDEX_STATS Procedure
- GATHER_SCHEMA_STATS Procedures
- GATHER_SYSTEM_STATS Procedure
- GATHER_TABLE_STATS Procedure
- GENERATE_STATS Procedure
- GET_COLUMN_STATS Procedures
- GET_INDEX_STATS Procedures
- GET_PARAM Function
- GET_STATS_HISTORY_AVAILABILITY Function
- GET_STATS_HISTORY_RETENTION Function
- GET_SYSTEM_STATS Procedure
- GET_TABLE_STATS Procedure
- IMPORT_COLUMN_STATS Procedure
- IMPORT_DATABASE_STATS Procedure
- IMPORT_DICTIONARY_STATS Procedure
- IMPORT_FIXED_OBJECTS_STATS Procedure
- IMPORT_INDEX_STATS Procedure
- IMPORT_SCHEMA_STATS Procedure
- IMPORT_SYSTEM_STATS Procedure
- IMPORT_TABLE_STATS Procedure
- LOCK_SCHEMA_STATS Procedure
- LOCK_TABLE_STATS Procedure
- PREPARE_COLUMN_VALUES Procedures
- PREPARE_COLUMN_VALUES_NVARCHAR2 Procedure
- PREPARE_COLUMN_VALUES_ROWID Procedure
- PURGE_STATS Procedure
- RESET_PARAM_DEFAULTS Procedure
- RESTORE_DATABASE_STATS Procedure
- RESTORE_DICTIONARY_STATS Procedure
- RESTORE_FIXED_OBJECTS_STATS Procedure
- RESTORE_SCHEMA_STATS Procedure
- RESTORE_SYSTEM_STATS Procedure
- RESTORE_TABLE_STATS Procedure
- SET_COLUMN_STATS Procedures
- SET_INDEX_STATS Procedures
- SET_PARAM Procedure
- SET_SYSTEM_STATS Procedure
- SET_TABLE_STATS Procedure
- UNLOCK_SCHEMA_STATS Procedure
- UNLOCK_TABLE_STATS Procedure
- UPGRADE_STAT_TABLE Procedure
104 DBMS_STORAGE_MAP
105 DBMS_STREAMS
- Using DBMS_STREAMS
- Summary
of DBMS_STREAMS Subprograms
- COMPATIBLE_10_2 Function
- COMPATIBLE_10_1 Function
- COMPATIBLE_9_2 Function
- CONVERT_ANYDATA_TO_LCR_DDL Function
- CONVERT_ANYDATA_TO_LCR_ROW Function
- CONVERT_LCR_TO_XML Function
- CONVERT_XML_TO_LCR Function
- GET_INFORMATION Function
- GET_STREAMS_NAME Function
- GET_STREAMS_TYPE Function
- GET_TAG Function
- SET_TAG Procedure
106 DBMS_STREAMS_ADM
- Using DBMS_STREAMS_ADM
- Summary
of DBMS_STREAMS_ADM Subprograms
- ADD_COLUMN Procedure
- ADD_GLOBAL_PROPAGATION_RULES Procedure
- ADD_GLOBAL_RULES Procedure
- ADD_MESSAGE_PROPAGATION_RULE Procedure
- ADD_MESSAGE_RULE Procedure
- ADD_SCHEMA_PROPAGATION_RULES Procedure
- ADD_SCHEMA_RULES Procedure
- ADD_SUBSET_PROPAGATION_RULES Procedure
- ADD_SUBSET_RULES Procedure
- ADD_TABLE_PROPAGATION_RULES Procedure
- ADD_TABLE_RULES Procedure
- CLEANUP_INSTANTIATION_SETUP Procedure
- DELETE_COLUMN Procedure
- GET_SCN_MAPPING Procedure
- MAINTAIN_GLOBAL Procedure
- MAINTAIN_SCHEMAS Procedure
- MAINTAIN_SIMPLE_TABLESPACE Procedure
- MAINTAIN_SIMPLE_TTS Procedure
- MAINTAIN_TABLES Procedure
- MAINTAIN_TABLESPACES Procedure
- MAINTAIN_TTS Procedure
- POST_INSTANTIATION_SETUP Procedure
- PRE_INSTANTIATION_SETUP Procedure
- PURGE_SOURCE_CATALOG Procedure
- RECOVER_OPERATION Procedure
- REMOVE_QUEUE Procedure
- REMOVE_RULE Procedure
- REMOVE_STREAMS_CONFIGURATION Procedure
- RENAME_COLUMN Procedure
- RENAME_SCHEMA Procedure
- RENAME_TABLE Procedure
- SET_MESSAGE_NOTIFICATION Procedure
- SET_RULE_TRANSFORM_FUNCTION Procedure
- SET_UP_QUEUE Procedure
107 DBMS_STREAMS_AUTH
108 DBMS_STREAMS_MESSAGING
109 DBMS_STREAMS_TABLESPACE_ADM
110 DBMS_TRACE
111 DBMS_TRANSACTION
- Using DBMS_TRANSACTION
- Summary
of DBMS_TRANSACTION Subprograms
- ADVISE_COMMIT Procedure
- ADVISE_NOTHING Procedure
- ADVISE_ROLLBACK Procedure
- BEGIN_DISCRETE_TRANSACTION Procedure
- COMMIT Procedure
- COMMIT_COMMENT Procedure
- COMMIT_FORCE Procedure
- LOCAL_TRANSACTION_ID Function
- PURGE_LOST_DB_ENTRY Procedure
- PURGE_MIXED Procedure
- READ_ONLY Procedure
- READ_WRITE Procedure
- ROLLBACK Procedure
- ROLLBACK_FORCE Procedure
- ROLLBACK_SAVEPOINT Procedure
- SAVEPOINT Procedure
- STEP_ID Function
- USE_ROLLBACK_SEGMENT Procedure
112 DBMS_TRANSFORM
113 DBMS_TDB
114 DBMS_TTS
115 DBMS_TYPES
116 DBMS_UTILITY
- Using DBMS_UTILITY
- Summary
of DBMS_UTILITY Subprograms
- ACTIVE_INSTANCES Procedure
- ANALYZE_DATABASE Procedure
- ANALYZE_PART_OBJECT Procedure
- ANALYZE_SCHEMA Procedure
- CANONICALIZE Procedure
- COMMA_TO_TABLE Procedures
- COMPILE_SCHEMA Procedure
- CREATE_ALTER_TYPE_ERROR_TABLE Procedure
- CURRENT_INSTANCE Function
- DATA_BLOCK_ADDRESS_BLOCK Function
- DATA_BLOCK_ADDRESS_FILE Function
- DB_VERSION Procedure
- EXEC_DDL_STATEMENT Procedure
- FORMAT_CALL_STACK Function
- FORMAT_ERROR_BACKTRACE Function
- FORMAT_ERROR_STACK Function
- GET_CPU_TIME Function
- GET_DEPENDENCY Procedure
- GET_HASH_VALUE Function
- GET_PARAMETER_VALUE Function
- GET_TIME Function
- INVALIDATE Procedure
- IS_CLUSTER_DATABASE Function
- MAKE_DATA_BLOCK_ADDRESS Function
- NAME_RESOLVE Procedure
- NAME_TOKENIZE Procedure
- PORT_STRING Function
- TABLE_TO_COMMA Procedures
- VALIDATE Procedure
117 DBMS_WARNING
118 DBMS_WORKLOAD_CAPTURE
119 DBMS_WORKLOAD_REPOSITORY
- Using DBMS_WORKLOAD_REPOSITORY
- Summary
of DBMS_WORKLOAD_REPOSITORY Subprograms
- ASH_REPORT_HTML Function
- ASH_REPORT_TEXT Function
- AWR_DIFF_REPORT_HTML Function
- AWR_DIFF_REPORT_TEXT Function
- AWR_REPORT_HTML Function
- AWR_REPORT_TEXT Function
- AWR_SQL_REPORT_HTML Function
- AWR_SQL_REPORT_TEXT Function
- CREATE_BASELINE Function and Procedure
- CREATE_SNAPSHOT Function and Procedure
- DROP_BASELINE Procedure
- DROP_SNAPSHOT_RANGE Procedure
- MODIFY_SNAPSHOT_SETTINGS Procedures
120 DBMS_WM
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/90618/viewspace-630645/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- oracle dbms包和其他包的使用大全Oracle
- oracle dbms包和其他包的使用大全 (十二)Oracle
- oracle dbms包和其他包的使用大全 (十一)Oracle
- oracle dbms包和其他包的使用大全 (十)Oracle
- oracle dbms包和其他包的使用大全 (九)Oracle
- oracle dbms包和其他包的使用大全 (八)Oracle
- oracle dbms包和其他包的使用大全 (七)Oracle
- oracle dbms包和其他包的使用大全 (六)Oracle
- oracle dbms包和其他包的使用大全 (四)Oracle
- oracle dbms包和其他包的使用大全 (三)Oracle
- oracle dbms包和其他包的使用大全(二)Oracle
- oracle dbms包和其他包的使用大全(一)Oracle
- oracle dbms_stats 包Oracle
- DBMS_SESSION包小議(五)Session
- Oracle dbms_stats包和analyze 的比較Oracle
- Oracle 11g DBMS_FGA包的使用Oracle
- dbms_sqltune包的使用SQL
- Oracle DBMS_STATS 包 和 Analyze 命令的區別Oracle
- Oracle DBMS_STATS 使用大全Oracle
- Oracle物化檢視DBMS_MVIEW.EXPLAIN_MVIEW包的使用OracleViewAI
- Oracle系統包dbms_randomOraclerandom
- oracle常用包之dbms_jobOracle
- 【dbms包】dbms_redefinition
- 【dbms包】DBMS_MONITOR
- DBMS_APPLICATION_INFO包的使用APP
- oracle系統包——dbms_random用法Oraclerandom
- oracle系統包——dbms_transaction用法Oracle
- oracle系統包——dbms_alert用法Oracle
- oracle系統包——DBMS_PIPE用法Oracle
- oracle系統包—-dbms_output用法Oracle
- oracle的dbms_stats包詳細解說Oracle
- oracle 11g DBMS_SQLTUNE 包的使用方法介紹OracleSQL
- 【dbms包】DBMS_APPLICATION_INFOAPP
- 【dbms包】DBMS_ADVANCED_REWRITE
- Oracle10g新增DBMS_MONITOR包Oracle
- DBMS_NETWORK_ACL_ADMIN 包的使用
- 【DBMS_RANDOM】使用 DBMS_RANDOM包生成隨機字串random隨機字串
- Oracle 11g系統調優之dbms_sqltune包的使用OracleSQL