What You Should Know Before Installing Performance Analyst
Go Up to Welcome to Performance Analyst
When you install the Analyst, several IDERA-generated stored objects are pushed onto the database server:
These objects are as follows:
ORACLE PROCEDURES
Procedures
ALL_TABLESPACES |
ALL_USERS |
HOTTESTDBFILES |
INSTANCESTARTUP |
IO_DD_ACCESSPATTERNDETAIL |
IO_DD_ACTIVEROLLBACKDETAILS |
IO_DD_ARCHIVELOGMODE |
IO_DD_CURRENTDISKSORTS |
IO_DD_DAILYARCHIVELOGSUMMARY |
IO_DD_DATAFILEIO |
IO_DD_DBWRDETAIL |
IO_DD_ESTPHYSICALIOBYTABLE |
IO_DD_JOBQUEUESUMMARY |
IO_DD_LGWRDETAIL |
IO_DD_PROBLEMJOBS |
IO_DD_REDOWASTAGE |
IO_DD_REDOWASTAGE2 |
IO_DD_ROLLBACKIO |
IO_DD_RUNNINGJOBSDETAIL |
IO_DD_SESSIONROLLBACKACTIVITY |
IO_DD_SESSIONSORTDETAIL |
IO_DD_TABLESPACEIO |
MEMORY_DD_BUFFERCACHERATIO |
MEMORY_DD_BUFFERCACHEUTIL |
MEMORY_DD_BUFFERPOOLHITRAT |
MEMORY_DD_BUFFERPOOLMEMCONF |
MEMORY_DD_BUFFERPOOLOBJASS |
MEMORY_DD_CACHEDBLOCKSBYTS |
MEMORY_DD_CACHEDTABLES |
MEMORY_DD_DATADICTDETAILS |
MEMORY_DD_LATCHDETAILS |
MEMORY_DD_LATCHRATIOS |
MEMORY_DD_LIBCACHEHITRATIO |
MEMORY_DD_LIBCACHEPERF |
MEMORY_DD_PGADETAIL |
MEMORY_DD_PGAOVERVIEW |
MEMORY_DD_PGAWORKAREA |
MEMORY_DD_PINNEDOBJECTS |
MEMORY_DD_SHAREDPOOLFRAG |
MEMORY_DD_SHAREDPOOLUSAGE |
MEMORY_DD_SHAREDPOOLUTIL |
NOT_WAITING_SESSIONS_COUNT |
OBJECT_DD_GLOBALOBJSUM |
OBJECT_DD_HOTCODE |
OBJECT_DD_HOTTABLES |
OBJECT_DD_INDEXES |
OBJECT_DD_INVALIDOBJDET |
OBJECT_DD_INVALIDOBJSUM |
OBJECT_DD_REORGANALYSIS |
OBJECT_DD_TABLESINSAMETS |
OBJECT_DD_USEROBJSUM |
OBJECTBUFFERPOOLPLACEMENT |
RAC_LOCKS_CONVERT |
RAC_LOCKS_DLM |
RAC_LOCKS_LATCH |
RAC_LOCKS_PCM |
RAC_MEMORY_ANALYSIS |
RAC_MEMORY_DATACACHE |
RAC_MEMORY_KEYRATIO |
RAC_MEMORY_LIBRARYCACHE |
RAC_OVERVIEW_CONFLICTS |
RAC_OVERVIEW_INSTANCE |
RAC_OVERVIEW_RATIOS |
RAC_OVERVIEW_WAITS |
RAC_OVERVIEW_WORKLOAD |
RAC_PING_DATAFILE |
RAC_PING_INSTANCE |
RAC_PING_OBJECT |
RAC_SESSIONS_BLOCKS |
RAC_SESSIONS_TOP |
RAC_SESSIONS_USER |
RAC_SESSIONS_USERWAITS |
RESPONSETIME_CURRENT_RESTIME |
RESPONSETIME_CURRENTWORKLOAD |
RESPONSETIME_HISTLISTEVENT |
RESPONSETIME_HISTORY |
RESPONSETIME_HISTORYFILE |
RESPONSETIME_HISTORYOBJECT |
RESPONSETIME_HISTORYSESSION |
RESPONSETIME_HISTORYSQL |
RESPONSETIME_HISTORYSUMMARY |
RESPONSETIME_LASTHOUR |
RESPONSETIME_LASTHOURDETAIL |
RESPONSETIME_LISTMETRIC |
RESPONSETIME_SESBOTTLENECK |
RESPONSETIME_SESBOTTLENECKDTL |
RESPONSETIME_SESBOTTLENECKHIST |
RESPONSETIME_SESSIONTIME |
RESPONSETIME_SYSBOTTLENECKHIS |
RESPONSETIME_SYSTEMBOTTLENECK |
RESPONSETIME_SYSTEMTIME |
RESPONSETIME_WAITHISTOGRAM |
RESPONSETIME_WAITHISTOLIST |
RETRIEVEHOMEPAGE |
RETRIEVEHOMERATIOS |
RETRIEVEIOPAGE |
RETRIEVEMEMORYPAGE |
RETRIEVEMEMORYRATIOS |
RETRIEVEOBJECTPAGE |
RETRIEVEOBJECTRATIOS |
RETRIEVESPACEPAGE |
RETRIEVEUSERPAGE |
RETRIEVEUSERRATIOS |
SESSION_DD_ALLLOCKS |
SESSION_DD_BLKLOCKS |
SESSION_DD_CRNTWAITS |
SESSION_DD_CURRENTSQL |
SESSION_DD_CURRENTSQLSTAT |
SESSION_DD_HISTWAITS |
SESSION_DD_OPENCURSORS |
SESSION_DD_OTHERSQL |
SESSION_DD_OVERVIEW |
SESSION_DD_OVERVIEWSTAT |
SESSION_DD_TRANSACTIONS |
SESSION_LAST_TEN_WAIT |
SESSION_TIME_SUMMARY |
SPACE_DD_ACCOBJECTGRID |
SPACE_DD_DATAFILEDETAIL |
SPACE_DD_DATAFILEFRAG |
SPACE_DD_EXTENTANALYSIS |
SPACE_DD_SPACEBYOBJECT |
SPACE_DD_SPACEBYUSER |
SPACE_DD_TABLESPACEFRAG |
SPACE_DD_TABLESPACEGROWTH |
SPACE_DD_TABLESPACEMAP |
SPACE_DD_TABLESPACEOBJSUM |
SPACE_DD_TOPUSERS |
SPACEANALYSIS |
SQLANALYSIS_HOME |
SQLANALYSIS_IO |
SQLANALYSIS_MEMORY |
SQLANALYSIS_OBJECT |
SQLANALYSIS_SPACE |
SQLANALYSIS_USER |
TABLEHIGHWATERMARKPROBLEMCOUNT |
TOP_SYSTEM_BOTTLENECKS_10G |
TOPCPUPROCESS |
TOPDBFILEWAITS |
TOPDISKSORTPROCESS |
TOPFRAGMENTEDDATAFILES |
TOPIOHOGS |
TOPIOPROCESS |
TOPLARGESCANPROCESS |
TOPLATCHMISSES |
TOPLOGFILEWAITS |
TOPMEMORYHOGS |
TOPMEMORYPROCESS |
TOPPARSEPROCESS |
TOPSESSIONBOTTLENECKS |
TOPSESSIONS |
TOPSESSIONS_10G |
TOPSPACEHOGS |
TOPSQL_DETAILS |
TOPSQL_RECENT_HISTORY |
TOPSQL_SQLTEXT |
TOPSQL_STATS |
TOPSQL_SUMMARY_DETAILS |
TOPSYSTEMBOTTLENECKS |
USERACTIVITYANALYSIS |
USERS_DD_ALL_LOCKS |
USERS_DD_BLK_LOCKS |
USERS_DD_BY_TIME_WAITED |
USERS_DD_BY_TOTAL_WAITS |
USERS_DD_CRNTWAITS |
USERS_DD_HISTWAITS |
USERS_DD_HISTWAITS_10G |
USERS_DD_SYSTEMWAITS_10G |
VERSION |
WAITING_SESSIONS_COUNT |
WORSTSCHEMAFORCHAINEDROWTABLES |
WORSTSCHEMAFOREXTENTPROBLEMS |
WORSTSCHEMAFORINVALIDOBJECTS |
SQL SERVER
Procedures
sp_embt_pa_all_database_enumerrorlog |
sp_embt_pa_all_database_list |
sp_embt_pa_current_sq |
sp_embt_pa_database_analysis |
sp_embt_pa_database_bottleneck |
sp_embt_pa_database_drill_backups_db |
sp_embt_pa_database_drill_backups_detail |
sp_embt_pa_database_drill_backups_log |
sp_embt_pa_database_drill_config_detail |
sp_embt_pa_database_drill_config_server |
sp_embt_pa_database_drill_error_log_content |
sp_embt_pa_database_drill_error_log_detail |
sp_embt_pa_database_drill_error_log_volume |
sp_embt_pa_database_drill_obj_index_det |
sp_embt_pa_database_drill_obj_summ |
sp_embt_pa_database_drill_obj_table_det |
sp_embt_pa_database_drill_overview |
sp_embt_pa_database_drill_replication_agent |
sp_embt_pa_database_drill_replication_thruput |
sp_embt_pa_database_drill_sqlagent_alrtdet |
sp_embt_pa_database_drill_sqlagent_alrtsum |
sp_embt_pa_database_drill_sqlagent_jobdet |
sp_embt_pa_database_drill_sqlagent_jobsum |
sp_embt_pa_database_drill_sqlagent_status |
sp_embt_pa_database_errorlog |
sp_embt_pa_db_requiring_backup |
sp_embt_pa_db_workload_analysis |
sp_embt_pa_home_active_processes |
sp_embt_pa_home_activity_metrics |
sp_embt_pa_home_bottleneck_waits |
sp_embt_pa_home_bottlenecks |
sp_embt_pa_home_storage_database_count |
sp_embt_pa_home_storage_totals |
sp_embt_pa_instance_startup |
sp_embt_pa_io_access_ratios |
sp_embt_pa_io_activity_metrics |
sp_embt_pa_io_bottlenecks |
sp_embt_pa_io_drill_database |
sp_embt_pa_io_drill_file |
sp_embt_pa_io_drill_system_awe |
sp_embt_pa_io_drill_system_io |
sp_embt_pa_io_drill_system_physical |
sp_embt_pa_io_drill_system_space |
sp_embt_pa_io_drill_user_lock |
sp_embt_pa_io_drill_user_obj |
sp_embt_pa_io_drill_user_sql |
sp_embt_pa_io_drill_user_temp |
sp_embt_pa_io_get_file_stats |
sp_embt_pa_io_hottest_files |
sp_embt_pa_io_ratios |
sp_embt_pa_io_top_processes |
sp_embt_pa_memory_analysis |
sp_embt_pa_memory_drill_bcache |
sp_embt_pa_memory_drill_buffer |
sp_embt_pa_memory_drill_buffer_page_activity |
sp_embt_pa_memory_drill_log_details |
sp_embt_pa_memory_drill_log_instances |
sp_embt_pa_memory_drill_proc_detail |
sp_embt_pa_memory_drill_proc_summary |
sp_embt_pa_memory_latch_stats |
sp_embt_pa_memory_ratio_mem |
sp_embt_pa_memory_sql_analysis |
sp_embt_pa_memory_top_latch_waits |
sp_embt_pa_memory_workload_analysis |
sp_embt_pa_space_bottlenecks |
sp_embt_pa_space_drill_filegroups |
sp_embt_pa_space_drill_files |
sp_embt_pa_space_drill_object_summary |
sp_embt_pa_space_drill_objects_index_det |
sp_embt_pa_space_drill_objects_table_det |
sp_embt_pa_space_drill_server_by_db |
sp_embt_pa_space_drill_server_summary |
sp_embt_pa_space_drill_vlogs |
sp_embt_pa_space_free_disk_space |
sp_embt_pa_space_main |
sp_embt_pa_space_used_disk_space |
sp_embt_pa_top_sql_database |
sp_embt_pa_top_sql_details |
sp_embt_pa_top_sql_home |
sp_embt_pa_top_sql_query |
sp_embt_pa_top_sql_refresh |
sp_embt_pa_top_sql_space |
sp_embt_pa_top_sql_start |
sp_embt_pa_top_sql_stop |
sp_embt_pa_top_sql_trace |
sp_embt_pa_user_bottleneck_activities |
sp_embt_pa_user_bottleneck_sessions |
sp_embt_pa_user_drill_locks_by_db |
sp_embt_pa_user_drill_locks_by_locktype |
sp_embt_pa_user_drill_locks_detail |
sp_embt_pa_user_drill_session_waits_by_time |
sp_embt_pa_user_drill_session_waits_by_type |
sp_embt_pa_user_drill_session_waits_detail |
sp_embt_pa_user_drill_system_waits_by_time |
sp_embt_pa_user_drill_system_waits_by_total_waits |
sp_embt_pa_user_drill_system_waits_detail |
sp_embt_pa_user_drill_top_sessions |
sp_embt_pa_user_drill_top_sessions_detail |
sp_embt_pa_user_ratio_login |
sp_embt_pa_user_ratio_process |
sp_embt_pa_user_workload |
sp_embt_pa_version |
Sybase ASE
Procedures
sp_embt_pa_actsql_drill |
sp_embt_pa_actsql_drill_det |
sp_embt_pa_current_sql |
sp_embt_pa_db_backup |
sp_embt_pa_db_bnecks |
sp_embt_pa_db_drill_cb_filter |
sp_embt_pa_db_drill_cb_idx |
sp_embt_pa_db_drill_cb_tbl |
sp_embt_pa_db_drill_cnfg |
sp_embt_pa_db_drill_dbs |
sp_embt_pa_db_drill_engines |
sp_embt_pa_db_drill_obj_filter |
sp_embt_pa_db_drill_obj_idx |
sp_embt_pa_db_drill_obj_suspct |
sp_embt_pa_db_drill_obj_tbl |
sp_embt_pa_db_drill_opt |
sp_embt_pa_db_drill_overview |
sp_embt_pa_db_drill_sus_filter |
sp_embt_pa_db_engines |
sp_embt_pa_db_max_engines= |
sp_embt_pa_db_metadata |
sp_embt_pa_db_obj_space |
sp_embt_pa_db_srv_bnecks |
sp_embt_pa_db_workload |
sp_embt_pa_dbspace |
sp_embt_pa_home_act_metrics |
sp_embt_pa_home_bottlenecks |
sp_embt_pa_home_storage_tot |
sp_embt_pa_instance_startup |
sp_embt_pa_io_anlysis |
sp_embt_pa_io_bottlenecks |
sp_embt_pa_io_drill_dbs |
sp_embt_pa_io_drill_device_rt |
sp_embt_pa_io_drill_device_sum |
sp_embt_pa_io_drill_device_typ |
sp_embt_pa_io_drill_engine |
sp_embt_pa_io_drill_net_eng |
sp_embt_pa_io_drill_net_ses |
sp_embt_pa_io_drill_object |
sp_embt_pa_io_hottest_devices |
sp_embt_pa_io_key_system |
sp_embt_pa_io_network |
sp_embt_pa_io_trans_log |
sp_embt_pa_io_workload |
sp_embt_pa_mem_activity |
sp_embt_pa_mem_analysis |
sp_embt_pa_mem_bottleneck |
sp_embt_pa_mem_eff_ratios |
sp_embt_pa_mem_mdcache |
sp_embt_pa_mem_workload |
sp_embt_pa_memory_drill_dc_act |
sp_embt_pa_memory_drill_dc_cfg |
sp_embt_pa_memory_drill_dc_eff |
sp_embt_pa_memory_drill_dc_obj |
sp_embt_pa_memory_drill_pc_act |
sp_embt_pa_memory_drill_pc_det |
sp_embt_pa_memory_drill_pc_use |
sp_embt_pa_monitor |
sp_embt_pa_space_bottlenecks |
sp_embt_pa_space_db_analysis |
sp_embt_pa_space_db_dev_cnt |
sp_embt_pa_space_dev_analysis |
sp_embt_pa_space_drill_db_sum |
sp_embt_pa_space_drill_dev_det |
sp_embt_pa_space_drill_dev_sum |
sp_embt_pa_space_drill_indexes |
sp_embt_pa_space_drill_tables |
sp_embt_pa_space_indexs_filte |
sp_embt_pa_space_tables_filter |
sp_embt_pa_user_activity |
sp_embt_pa_user_bottlenecks |
sp_embt_pa_user_drill_lcks_db |
sp_embt_pa_user_drill_lcks_tp |
sp_embt_pa_user_drill_locks |
sp_embt_pa_user_drill_seswait |
sp_embt_pa_user_drill_syswait |
sp_embt_pa_user_drill_trans |
sp_embt_pa_user_drill_ts |
sp_embt_pa_user_drill_ts_procs |
sp_embt_pa_user_index_scans |
sp_embt_pa_user_process |
sp_embt_pa_user_transactions |
sp_embt_pa_user_workload |
sp_embt_pa_userdet_io |
sp_embt_pa_userdet_locks |
sp_embt_pa_userdet_objects |
sp_embt_pa_userdet_sql |
sp_embt_pa_userdet_waits |
sp_embt_pa_version |