论坛徽章:: 0

电梯直达

1楼 [收藏(0)] [报告]

发表于 2008-11-13 12:44 |只看该作者 |倒序浏览

我要了解v$sysstat 中的各个种对应该的中文含义，但直释其中很多看起来就很搞笑，请高手帮帮，谢谢了

这样的一夫堆值

opened_cursors_current': 34, 'space_was_not_found_by_tune_down': 0, 'gc_cr_block_flush_time': 0, 'write_clones_created_in_background': 0, 'IPC_CPU_used_by_this_session': 0, 'queue_splits': 0, 'redo_writer_latching_time': 0, 'global_undo_segment_hints_were_stale': 0, 'index_scans_kdiixs1': 26861, 'process_last_non-idle_time': 1226551426, 'java_session_heap_collected_count': 0, 'commit_wait_requested': 0, 'java_call_heap_live_size': 0, 'gc_cr_block_build_time': 0, 'steps_of_tune_down_ret._in_space_pressure': 0, 'total_number_of_slots': 0, 'physical_write_total_bytes': 244715008, 'IMU_ktichg_flush': 0, 'user_calls': 2010, 'buffer_is_not_pinned_count': 86521, 'calls_to_kcmgcs': 139, 'concurrency_wait_time': 1314, 'index_fetch_by_key': 26773, 'write_clones_created_for_recovery': 0, 'redo_log_space_wait_time': 0, 'enqueue_timeouts': 0, 'session_cursor_cache_count': 3657, 'workarea_memory_allocated': 0, 'cleanout_-_number_of_ktugct_calls': 122, 'RowCR_hits': 0, 'DBWR_thread_checkpoint_buffers_written': 0, 'gc_current_block_flush_time': 0, 'java_session_heap_live_object_count_max': 0, 'logons_cumulative': 469, 'DBWR_fusion_writes': 0, 'redo_log_space_requests': 0, 'consistent_gets': 142188, 'physical_reads_for_flashback_new': 0, 'physical_read_total_IO_requests': 9886, 'session_cursor_cache_hits': 12322, 'DBWR_transaction_table_writes': 350, 'IMU_undo_retention_flush': 0, 'sorts_(disk)': 0, 'DBWR_revisited_being-written_buffer': 0, 'gc_claim_blocks_lost': 0, 'pinned_buffers_inspected': 0, 'table_scans_(direct_read)': 0, 'gc_cr_block_receive_time': 0, 'table_fetch_continued_row': 283, 'IMU_mbu_flush': 0, 'CPU_used_by_this_session': 711, 'IMU_undo_allocation_size': 2002040, 'Parallel_operations_downgraded_50_to_75_pct': 0, 'sorts_(memory)': 10639, 'redo_wastage': 514008, 'queue_ocp_pages': 0, 'java_session_heap_live_object_count': 0, 'Parallel_operations_not_downgraded': 0, 'commit_wait/nowait_performed': 0, 'IMU_contention': 0, 'physical_read_total_bytes': 136426496, 'redo_blocks_written': 10062, 'session_uga_memory': 910547633492L, 'db_block_gets': 19208, 'buffer_is_pinned_count': 150503, 'OTC_commit_optimization_attempts': 0, 'Parallel_operations_downgraded_25_to_50_pct': 0, 'java_call_heap_total_size': 0, 'queue_update_without_cp_update': 0, 'local_undo_segment_hints_were_stale': 0, 'java_session_heap_collected_bytes': 0, 'physical_reads_prefetch_warmup': 475, 'physical_writes_direct_(lob)': 1, 'commit_cleanout_failures:_write_disabled': 0, 'Misses_for_writing_mapping': 0, 'total_number_of_undo_segments_dropped': 0, 'session_pga_memory': 214661920, 'prefetch_clients_-_16k': 0, 'logons_current': 16, 'lob_writes': 8, 'RowCR_attempts': 0, 'Parallel_operations_downgraded_to_serial': 0, 'recursive_calls': 292165, 'java_session_heap_used_size_max': 0, 'commit_cleanout_failures:_block_lost': 0, 'flashback_log_writes': 0, 'cold_recycle_reads': 0, 'redo_blocks_read_for_recovery': 320, 'table_scans_(long_tables)': 1, 'PX_local_messages_sent': 58, 'redo_log_switch_interrupts': 0, 'commit_txn_count_during_cleanout': 83, 'native_hash_arithmetic_execute': 0, 'local_undo_segment_hints_helped': 0, 'index_fast_full_scans_(rowid_ranges)': 0, 'bytes_sent_via_SQL*Net_to_dblink': 0, 'table_scan_rows_gotten': 956860, 'bytes_received_via_SQL*Net_from_dblink': 0, 'gc_current_blocks_served': 0, 'java_call_heap_object_count': 0, 'dirty_buffers_inspected': 0, 'table_fetch_by_rowid': 92589, 'IMU_recursive-transaction_flush': 1, 'transaction_lock_foreground_requests': 0, 'prefetch_clients_-_2k': 0, 'session_uga_memory_max': 203807604, 'physical_write_total_multi_block_requests': 1807, 'active_txn_count_during_cleanout': 79, 'redo_size': 4473160, 'serializable_aborts': 0, 'transaction_lock_background_gets': 0, 'Commit_SCN_cached': 0, 'table_scans_(short_tables)': 1968, 'rollbacks_only_-_consistent_read_gets': 19, 'enqueue_conversions': 2663, 'prefetch_clients_-_32k': 0, 'physical_reads_cache': 7760, 'commit_batch_performed': 0, 'queries_parallelized': 0, 'global_enqueue_gets_async': 0, 'cleanouts_and_rollbacks_-_consistent_read_gets': 0, 'DB_time': 1323629, 'space_was_found_by_tune_down': 0, 'index_fast_full_scans_(direct_read)': 0, 'calls_to_get_snapshot_scn:_kcmgss': 39371, 'commit_batch/immediate_performed': 0, 'java_session_heap_object_count': 0, 'DBWR_make_free_requests': 0, 'ges_messages_sent': 0, 'prefetch_clients_-_recycle': 0, 'sql_area_aged': 0, 'workarea_executions_-_onepass': 0, 'parse_count_(total)': 15023, 'no_buffer_to_keep_pinned_count': 1, 'commit_wait_performed': 0, 'parse_time_cpu': 171, 'commit_nowait_performed': 0, 'physical_reads_direct_(lob)': 0, 'physical_writes': 2552, 'java_call_heap_total_size_max': 0, 'calls_to_kcmgrs': 0, 'DBWR_object_drop_buffers_written': 0, 'queue_single_row': 0, 'background_checkpoints_started': 0, 'physical_read_bytes': 63881216, 'tune_down_retentions_in_space_pressure': 0, 'cluster_wait_time': 0, 'commit_cleanouts': 3879, 'execute_count': 31054, 'transaction_lock_foreground_wait_time': 0, 'leaf_node_90-10_splits': 21, 'commit_cleanout_failures:_buffer_being_written': 0, 'physical_reads': 7798, 'user_rollbacks': 32, 'total_number_of_times_SMON_posted': 7, 'physical_writes_direct': 11, 'commit_batch/immediate_requested': 0, 'enqueue_deadlocks': 0, 'gc_blocks_lost': 0, 'physical_write_total_IO_requests': 17117, 'commit_nowait_requested': 0, 'recursive_cpu_usage': 573, 'prefetch_warmup_blocks_aged_out_before_use': 0, 'OTC_commit_optimization_hits': 0, 'physical_reads_retry_corrupt': 0, 'transaction_rollbacks': 0, 'physical_reads_direct_temporary_tablespace': 6, 'physical_writes_from_cache': 2541, 'hot_buffers_moved_to_head_of_LRU': 0, 'gc_current_blocks_received': 0, 'cursor_authentications': 430, 'user_I/O_wait_time': 30661, 'table_scan_blocks_gotten': 13867, 'java_call_heap_gc_count': 0, 'prefetch_clients_-_keep': 0, 'prefetch_clients_-_8k': 0, 'workarea_executions_-_optimal': 5460, 'physical_read_total_multi_block_requests': 321, 'physical_writes_non_checkpoint': 790, 'doubling_up_with_imu_segment': 0, 'instance_recovery_database_freeze_count': 0, 'SQL*Net_roundtrips_to/from_dblink': 0, 'session_stored_procedure_space': 0, 'commit_wait/nowait_requested': 0, 'change_write_time': 49, 'immediate_CR_cleanouts_(index_blocks)': 0, 'prefetched_blocks_aged_out_before_use': 0, 'global_enqueue_gets_sync': 0, 'number_of_map_misses': 0, 'java_call_heap_live_object_count': 0, 'write_clones_created_in_foreground': 0, 'commit_batch_requested': 0, 'no_work_-_consistent_read_gets': 66296, 'transaction_lock_background_get_time': 0, 'recovery_array_reads': 0, 'IMU_bind_flushes': 0, 'lob_reads': 216, 'transaction_tables_consistent_reads_-_undo_records_applied': 0, 'DBWR_undo_block_writes': 581, 'redo_writes': 1714, 'physical_read_IO_requests': 6240, 'gc_current_block_send_time': 0, 'branch_node_splits': 0, 'table_scans_(cache_partitions)': 0, 'physical_reads_cache_prefetch': 1558, 'DFO_trees_parallelized': 0, 'DBWR_tablespace_checkpoint_buffers_written': 0, 'switch_current_to_new_buffer': 268, 'queue_flush': 0, 'commit_cleanout_failures:_cannot_pin': 1, 'commit_cleanout_failures:_hot_backup_in_progress': 0, 'java_session_heap_live_size': 0, 'calls_to_kcmgas': 2422, 'java_call_heap_collected_bytes': 0, 'prefetch_clients_-_default': 0, 'current_blocks_converted_for_CR': 0, 'java_call_heap_object_count_max': 0, 'CR_blocks_created': 19, 'IMU_CR_rollbacks': 0, 'drop_segment_calls_in_space_pressure': 0, 'DBWR_parallel_query_checkpoint_buffers_written': 0, 'lob_writes_unaligned': 8, 'rollback_changes_-_undo_records_applied': 6, 'physical_write_bytes': 20905984, 'global_enqueue_releases': 0, 'native_hash_arithmetic_fail': 0, 'queue_position_update': 0, 'frame_signature_mismatch': 0, 'shared_hash_latch_upgrades_-_wait': 3, 'gc_cr_blocks_served': 0, 'redo_buffer_allocation_retries': 0, 'SMON_posted_for_instance_recovery': 0, 'RowCR_-_resume': 0, 'java_call_heap_collected_count': 0, 'free_buffer_inspected': 0, 'PX_remote_messages_sent': 0, 'commit_cleanout_failures:_callback_failure_': 12, 'java_session_heap_gc_count': 0, 'IMU_Flushes': 61, 'DML_statements_parallelized': 0, 'SMON_posted_for_undo_segment_shrink': 2, 'OTC_commit_optimization_failure_-_setup': 0, 'redo_ordering_marks': 179, 'bytes_received_via_SQL*Net_from_client': 104870, 'heap_block_compress': 61, 'commit_immediate_requested': 0, 'consistent_gets_direct': 1, 'IMU_pool_not_allocated': 0, 'queue_qno_pages': 0, 'CPU_used_when_call_started': 453, 'recovery_blocks_read': 48, 'cluster_key_scan_block_gets': 22045, 'parse_count_(failures)': 0, 'shared_hash_latch_upgrades_-_no_wait': 26945, 'background_checkpoints_completed': 0, 'Cached_Commit_SCN_referenced': 0, 'enqueue_waits': 4, 'prefetch_warmup_blocks_flushed_out_before_use': 0, 'gc_CPU_used_by_this_session': 0, 'table_lookup_prefetch_client_count': 0, 'sorts_(rows)': 80618, 'gc_cr_block_send_time': 0, 'cleanouts_only_-_consistent_read_gets': 16, 'consistent_gets_-_examination': 44392, 'deferred_(CURRENT)_block_cleanout_applications': 2619, 'summed_dirty_queue_length': 0, 'deferred_CUR_cleanouts_(index_blocks)': 0, 'consistent_changes': 25, 'bytes_sent_via_SQL*Net_to_client': 147379, 'sql_area_purged': 21, 'index_fast_full_scans_(full)': 0, 'redo_entries': 9547, 'enqueue_releases': 114450, 'IMU-_failed_to_get_a_private_strand': 0, 'db_block_changes': 20766, 'undo_segment_header_was_pinned': 0, 'exchange_deadlocks': 0, 'background_timeouts': 42096, 'session_pga_memory_max': 254901024, 'gc_blocks_corrupt': 0, 'PX_local_messages_recv_d': 58, 'global_enqueue_get_time': 0, 'db_block_gets_direct': 1, 'leaf_node_splits': 34, 'java_call_heap_live_object_count_max': 0, 'data_blocks_consistent_reads_-_undo_records_applied': 25, 'undo_change_vector_size': 1531004, 'parse_time_elapsed': 7174, 'physical_reads_direct': 37, 'RowCR_-_row_contention': 0, 'rows_fetched_via_callback': 9647, 'Parallel_operations_downgraded_75_to_99_pct': 0, 'java_call_heap_used_size_max': 0, 'workarea_executions_-_multipass': 0, 'IMU_Redo_allocation_size': 140968, 'SMON_posted_for_supplemental_logging_cleanup': 0, 'physical_writes_direct_temporary_tablespace': 0, 'commit_cleanouts_successfully_completed': 3866, 'java_call_heap_used_size': 0, 'SMON_posted_for_dropping_temp_segment': 0, 'prefetch_clients_-_4k': 0, 'DDL_statements_parallelized': 0, 'user_commits': 999, 'DBWR_lru_scans': 0, 'physical_write_IO_requests': 2008, 'immediate_(CR)_block_cleanout_applications': 16, 'consistent_gets_from_cache': 142187, 'DBWR_checkpoint_buffers_written': 2470, 'gc_cr_blocks_received': 0, 'session_connect_time': 1226551426, 'table_scans_(rowid_ranges)': 0, 'gc_current_block_pin_time': 0, 'db_block_gets_from_cache': 19207, 'java_session_heap_object_count_max': 0, 'IMU_commits': 968, 'global_enqueue_CPU_used_by_this_session': 0, 'SMON_posted_for_txn_recovery_for_other_instances': 0, 'java_session_heap_used_size': 0, 'redo_write_time': 487, 'application_wait_time': 0, 'immediate_(CURRENT)_block_cleanout_applications': 510, 'session_logical_reads': 161396, 'gc_current_block_receive_time': 0, 'enqueue_requests': 114463, 'recovery_array_read_time': 0, 'SQL*Net_roundtrips_to/from_client': 748, 'messages_sent': 3757, 'free_buffer_requested': 8446, 'Parallel_operations_downgraded_1_to_25_pct': 0, 'opened_cursors_cumulative': 20497, 'commit_immediate_performed': 0, 'redo_synch_time': 154, 'messages_received': 3761, 'redo_synch_writes': 3462, 'redo_subscn_max_counts': 0, 'cluster_key_scans': 5439, 'PX_remote_messages_recv_d': 0, 'java_call_heap_live_size_max': 0, 'gcs_messages_sent': 0, 'SMON_posted_for_undo_segment_recovery': 0, 'global_undo_segment_hints_helped': 0, 'number_of_map_operations': 0, 'auto_extends_on_undo_tablespace': 0, 'DBWR_checkpoints': 0, 'parse_count_(hard)': 1283, 'transaction_tables_consistent_read_rollbacks': 0, 'java_session_heap_live_size_max': 0