SQL>SELECT * FROM DBA_PROCEDURES WHERE OBJECT_NAME='DBMS_STATS';
OWNER OBJECT_NAME PROCEDURE_NAME OBJECT_ID SUBPROGRAM_ID OVERLOAD
---------- ------------------------------ ------------------------------ ---------------- ---------------- -----------------------------------
SYS DBMS_STATS ALTER_DATABASE_TAB_MONITORING 4345 64
SYS DBMS_STATS ALTER_SCHEMA_TAB_MONITORING 4345 63
SYS DBMS_STATS ALTER_STATS_HISTORY_RETENTION 4345 93
SYS DBMS_STATS CLEANUP_STATS_JOB_PROC 4345 100
SYS DBMS_STATS CONVERT_RAW_VALUE 4345 22 1
SYS DBMS_STATS CONVERT_RAW_VALUE 4345 23 2
SYS DBMS_STATS CONVERT_RAW_VALUE 4345 24 3
SYS DBMS_STATS CONVERT_RAW_VALUE 4345 25 4
SYS DBMS_STATS CONVERT_RAW_VALUE 4345 26 5
SYS DBMS_STATS CONVERT_RAW_VALUE_NVARCHAR 4345 27
SYS DBMS_STATS CONVERT_RAW_VALUE_ROWID 4345 28
SYS DBMS_STATS COPY_TABLE_STATS 4345 96
SYS DBMS_STATS CREATE_STAT_TABLE 4345 42
SYS DBMS_STATS DELETE_COLUMN_STATS 4345 37
SYS DBMS_STATS DELETE_DATABASE_STATS 4345 41
SYS DBMS_STATS DELETE_DICTIONARY_STATS 4345 77
SYS DBMS_STATS DELETE_FIXED_OBJECTS_STATS 4345 72
SYS DBMS_STATS DELETE_INDEX_STATS 4345 38
SYS DBMS_STATS DELETE_SCHEMA_STATS 4345 40
SYS DBMS_STATS DELETE_SYSTEM_STATS 4345 68
SYS DBMS_STATS DELETE_TABLE_STATS 4345 39
SYS DBMS_STATS DIFF_TABLE_STATS_IN_HISTORY 4345 98
SYS DBMS_STATS DIFF_TABLE_STATS_IN_STATTAB 4345 97
SYS DBMS_STATS DROP_STAT_TABLE 4345 43
SYS DBMS_STATS EXPORT_COLUMN_STATS 4345 45
SYS DBMS_STATS EXPORT_DATABASE_STATS 4345 49
SYS DBMS_STATS EXPORT_DICTIONARY_STATS 4345 78
SYS DBMS_STATS EXPORT_FIXED_OBJECTS_STATS 4345 73
SYS DBMS_STATS EXPORT_INDEX_STATS 4345 46
SYS DBMS_STATS EXPORT_SCHEMA_STATS 4345 48
SYS DBMS_STATS EXPORT_SYSTEM_STATS 4345 70
SYS DBMS_STATS EXPORT_TABLE_STATS 4345 47
SYS DBMS_STATS FLUSH_DATABASE_MONITORING_INFO 4345 62
SYS DBMS_STATS GATHER_DATABASE_STATS 4345 59 1
SYS DBMS_STATS GATHER_DATABASE_STATS 4345 60 2
SYS DBMS_STATS GATHER_DATABASE_STATS_JOB_PROC 4345 99
SYS DBMS_STATS GATHER_DICTIONARY_STATS 4345 75 1
SYS DBMS_STATS GATHER_DICTIONARY_STATS 4345 76 2
SYS DBMS_STATS GATHER_FIXED_OBJECTS_STATS 4345 71
SYS DBMS_STATS GATHER_INDEX_STATS 4345 55
SYS DBMS_STATS GATHER_SCHEMA_STATS 4345 57 1
SYS DBMS_STATS GATHER_SCHEMA_STATS 4345 58 2
SYS DBMS_STATS GATHER_SYSTEM_STATS 4345 65
SYS DBMS_STATS GATHER_TABLE_STATS 4345 56
SYS DBMS_STATS GENERATE_STATS 4345 61
SYS DBMS_STATS GET_COLUMN_STATS 4345 29 1
SYS DBMS_STATS GET_COLUMN_STATS 4345 30 2
SYS DBMS_STATS GET_INDEX_STATS 4345 31 1
SYS DBMS_STATS GET_INDEX_STATS 4345 32 2
SYS DBMS_STATS GET_INDEX_STATS 4345 33 3
SYS DBMS_STATS GET_INDEX_STATS 4345 34 4
SYS DBMS_STATS GET_PARAM 4345 10
SYS DBMS_STATS GET_STATS_HISTORY_AVAILABILITY 4345 95
SYS DBMS_STATS GET_STATS_HISTORY_RETENTION 4345 94
SYS DBMS_STATS GET_SYSTEM_STATS 4345 66
SYS DBMS_STATS GET_TABLE_STATS 4345 35 1
SYS DBMS_STATS GET_TABLE_STATS 4345 36 2
SYS DBMS_STATS IMPORT_COLUMN_STATS 4345 50
SYS DBMS_STATS IMPORT_DATABASE_STATS 4345 54
SYS DBMS_STATS IMPORT_DICTIONARY_STATS 4345 79
SYS DBMS_STATS IMPORT_FIXED_OBJECTS_STATS 4345 74
SYS DBMS_STATS IMPORT_INDEX_STATS 4345 51
SYS DBMS_STATS IMPORT_SCHEMA_STATS 4345 53
SYS DBMS_STATS IMPORT_SYSTEM_STATS 4345 69
SYS DBMS_STATS IMPORT_TABLE_STATS 4345 52
SYS DBMS_STATS INIT_PACKAGE 4345 16
SYS DBMS_STATS LOCK_PARTITION_STATS 4345 81
SYS DBMS_STATS LOCK_SCHEMA_STATS 4345 82
SYS DBMS_STATS LOCK_TABLE_STATS 4345 80
SYS DBMS_STATS PREPARE_COLUMN_VALUES 4345 1 1
SYS DBMS_STATS PREPARE_COLUMN_VALUES 4345 2 2
SYS DBMS_STATS PREPARE_COLUMN_VALUES 4345 3 3
SYS DBMS_STATS PREPARE_COLUMN_VALUES 4345 4 4
SYS DBMS_STATS PREPARE_COLUMN_VALUES 4345 5 5
SYS DBMS_STATS PREPARE_COLUMN_VALUES 4345 6 6
SYS DBMS_STATS PREPARE_COLUMN_VALUES_NVARCHAR 4345 7
SYS DBMS_STATS PREPARE_COLUMN_VALUES_ROWID 4345 8
SYS DBMS_STATS PURGE_STATS 4345 92
SYS DBMS_STATS RESET_PARAM_DEFAULTS 4345 11
SYS DBMS_STATS RESTORE_DATABASE_STATS 4345 88
SYS DBMS_STATS RESTORE_DICTIONARY_STATS 4345 90
SYS DBMS_STATS RESTORE_FIXED_OBJECTS_STATS 4345 89
SYS DBMS_STATS RESTORE_SCHEMA_STATS 4345 87
SYS DBMS_STATS RESTORE_SYSTEM_STATS 4345 91
SYS DBMS_STATS RESTORE_TABLE_STATS 4345 86
SYS DBMS_STATS SET_COLUMN_STATS 4345 17 1
SYS DBMS_STATS SET_COLUMN_STATS 4345 18 2
SYS DBMS_STATS SET_INDEX_STATS 4345 19 1
SYS DBMS_STATS SET_INDEX_STATS 4345 20 2
SYS DBMS_STATS SET_PARAM 4345 9
SYS DBMS_STATS SET_SYSTEM_STATS 4345 67
SYS DBMS_STATS SET_TABLE_STATS 4345 21
SYS DBMS_STATS TO_CASCADE_TYPE 4345 12
SYS DBMS_STATS TO_DEGREE_TYPE 4345 14
SYS DBMS_STATS TO_ESTIMATE_PERCENT_TYPE 4345 13
SYS DBMS_STATS TO_NO_INVALIDATE_TYPE 4345 15
SYS DBMS_STATS UNLOCK_PARTITION_STATS 4345 84
SYS DBMS_STATS UNLOCK_SCHEMA_STATS 4345 85
SYS DBMS_STATS UNLOCK_TABLE_STATS 4345 83
SYS DBMS_STATS UPGRADE_STAT_TABLE 4345 44
SYS DBMS_STATS 4345 0
101 rows selected.
Elapsed: 00:00:00.20
SQL>select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi
PL/SQL Release 10.2.0.5.0 - Production
CORE 10.2.0.5.0 Production
TNS for IBM/AIX RISC System/6000: Version 10.2.0.5.0 - Productio
NLSRTL Version 10.2.0.5.0 - Production
5 rows selected.
Elapsed: 00:00:00.03