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_SHARED_POOL(十)Oracle
- SQL調優工具包DBMS_SQLTUNE的使用方法SQL
- 使用DBMS_SHARED_POOL包將物件固定到共享池物件
- 壓縮包格式有哪些?壓縮包格式大全
- Javaparse包的使用和講解Java
- 如何在其他php-fpm框架中,使用laravel的限流包?PHP框架Laravel
- Oracle rac使用nid和dbms_backup_restore包修改dbid和dbnameOracleREST
- 【BUILD_ORACLE】使用ASMLib包搭建ASM磁碟UIOracleASM
- Netty 中的粘包和拆包Netty
- 五個常用的爬蟲包爬蟲
- 06、使用Gradle構建的專案如何打jar包和war包GradleJAR
- 前端 npm 安裝包,精選大全前端NPM
- jar包、war包和ear包的介紹與區別JAR
- 【DBMS】Oracle DBMS_OUTOUT程式介紹Oracle
- Go標準包——net/rpc包的使用GoRPC
- 原始碼包和rpm包的區別原始碼
- fmt包的使用
- Nodemon包的使用
- 如果釋出和使用npm包NPM
- oracle定時任務dbms_job與dbms_scheduler使用方法Oracle
- oracle使用DBMS_SCHEDULER排程作業Oracle
- gitmoji表情包使用--github的專屬表情包Github
- 利用DBMS_METADATA包獲取許可權資訊(轉)
- 包裝類的使用
- npm包:moment的使用NPM
- net/rpc包的使用RPC
- Go | 閉包的使用Go
- jar包和war包的介紹與區別JAR
- 第五篇 匿名函式、內建函式、import的使用、包的使用函式Import
- 包、元包和框架(.NET Core 指南)框架
- Composer 包使用
- flag 包使用
- percona-toolkit工具包的安裝和使用
- js閉包及閉包的經典使用場景JS
- 最安全的SRM錢包,SRM冷錢包使用教程
- 最安全的PMEER錢包,PMEER冷錢包使用教程
- [JavaScript閉包]Javascript閉包的判別,作用和示例JavaScript
- Netty入門系列(2) --使用Netty解決粘包和拆包問題Netty
- 高仿包和1:1包區別