complete list of the 10g DBA views:
dba_2pc_neighbors
dba_2pc_pending
dba_advisor_actions
dba_advisor_commands
dba_advisor_definitions
dba_advisor_findings
dba_advisor_journal
dba_advisor_log
dba_advisor_object_types
dba_advisor_objects
dba_advisor_parameters
dba_advisor_rationale
dba_advisor_recommendations
dba_advisor_sqla_rec_sum
dba_advisor_sqla_wk_map
dba_advisor_sqla_wk_stmts
dba_advisor_sqlw_journal
dba_advisor_sqlw_parameters
dba_advisor_sqlw_stmts
dba_advisor_sqlw_sum
dba_advisor_sqlw_tables
dba_advisor_sqlw_templates
dba_advisor_tasks
dba_advisor_templates
dba_advisor_usage
dba_alert_history
dba_all_tables
dba_application_roles
dba_apply
dba_apply_conflict_columns
dba_apply_dml_handlers
dba_apply_enqueue
dba_apply_error
dba_apply_execute
dba_apply_instantiated_global
dba_apply_instantiated_objects
dba_apply_instantiated_schemas
dba_apply_key_columns
dba_apply_parameters
dba_apply_progress
dba_apply_table_columns
dba_aq_agent_privs
dba_aq_agents
dba_associations
dba_attribute_transformations
dba_audit_exists
dba_audit_object
dba_audit_policies
dba_audit_policy_columns
dba_audit_session
dba_audit_statement
dba_audit_trail
dba_aw_ps
dba_aws
dba_base_table_mviews
dba_blockers
dba_capture
dba_capture_extra_attributes
dba_capture_parameters
dba_capture_prepared_database
dba_capture_prepared_schemas
dba_capture_prepared_tables
dba_catalog
dba_clu_columns
dba_cluster_hash_expressions
dba_clusters
dba_col_comments
dba_col_privs
dba_coll_types
dba_common_audit_trail
dba_cons_obj_columns
dba_constraints
dba_context
dba_data_files
dba_datapump_jobs
dba_datapump_sessions
dba_db_links
dba_ddl_locks
dba_dependencies
dba_dim_attributes
dba_dim_child_of
dba_dim_hierarchies
dba_dim_join_key
dba_dim_level_key
dba_dim_levels
dba_dimensions
dba_directories
dba_dml_locks
dba_dmt_free_space
dba_dmt_used_extents
dba_enabled_aggregations
dba_enabled_traces
dba_errors
dba_evaluation_context_tables
dba_evaluation_context_vars
dba_evaluation_contexts
dba_exp_files
dba_exp_objects
dba_exp_version
dba_extents
dba_external_locations
dba_external_tables
dba_feature_usage_statistics
dba_fga_audit_trail
dba_free_space
dba_free_space_coalesced
dba_high_water_mark_statistics
dba_hist_active_sess_history
dba_hist_baseline
dba_hist_bg_event_summary
dba_hist_buffer_pool_stat
dba_hist_cr_block_server
dba_hist_current_block_server
dba_hist_database_instance
dba_hist_datafile
dba_hist_db_cache_advice
dba_hist_dlm_misc
dba_hist_enqueue_stat
dba_hist_event_name
dba_hist_filemetric_history
dba_hist_filestatxs
dba_hist_instance_recovery
dba_hist_java_pool_advice
dba_hist_latch
dba_hist_latch_children
dba_hist_latch_misses_summary
dba_hist_latch_name
dba_hist_latch_parent
dba_hist_librarycache
dba_hist_log
dba_hist_metric_name
dba_hist_mttr_target_advice
dba_hist_optimizer_env
dba_hist_osstat
dba_hist_osstat_name
dba_hist_parameter
dba_hist_parameter_name
dba_hist_pga_target_advice
dba_hist_pgastat
dba_hist_resource_limit
dba_hist_rollstat
dba_hist_rowcache_summary
dba_hist_seg_stat
dba_hist_seg_stat_obj
dba_hist_service_name
dba_hist_service_stat
dba_hist_service_wait_class
dba_hist_sessmetric_history
dba_hist_sga
dba_hist_sgastat
dba_hist_shared_pool_advice
dba_hist_snap_error
dba_hist_snapshot
dba_hist_sql_plan
dba_hist_sql_summary
dba_hist_sql_workarea_hstgrm
dba_hist_sqlbind
dba_hist_sqlstat
dba_hist_sqltext
dba_hist_stat_name
dba_hist_sys_time_model
dba_hist_sysmetric_history
dba_hist_sysmetric_summary
dba_hist_sysstat
dba_hist_system_event
dba_hist_tablespace_stat
dba_hist_tbspc_space_usage
dba_hist_tempfile
dba_hist_tempstatxs
dba_hist_thread
dba_hist_undostat
dba_hist_waitclassmet_history
dba_hist_waitstat
dba_hist_wr_control
dba_ind_columns
dba_ind_expressions
dba_ind_partitions
dba_ind_statistics
dba_ind_subpartitions
dba_indexes
dba_indextype_arraytypes
dba_indextype_comments
dba_indextype_operators
dba_indextypes
dba_internal_triggers
dba_java_arguments
dba_java_classes
dba_java_derivations
dba_java_fields
dba_java_implements
dba_java_inners
dba_java_layouts
dba_java_methods
dba_java_ncomps
dba_java_policy
dba_java_resolvers
dba_java_throws
dba_jobs
dba_jobs_running
dba_join_ind_columns
dba_kgllock
dba_libraries
dba_lmt_free_space
dba_lmt_used_extents
dba_lob_partitions
dba_lob_subpartitions
dba_lob_templates
dba_lobs
dba_lock
dba_lock_internal
dba_locks
dba_log_group_columns
dba_log_groups
dba_logmnr_log
dba_logmnr_purged_log
dba_logmnr_session
dba_logstdby_events
dba_logstdby_log
dba_logstdby_not_unique
dba_logstdby_parameters
dba_logstdby_progress
dba_logstdby_skip
dba_logstdby_skip_transaction
dba_logstdby_unsupported
dba_method_params
dba_method_results
dba_mview_aggregates
dba_mview_analysis
dba_mview_comments
dba_mview_detail_relations
dba_mview_joins
dba_mview_keys
dba_mview_log_filter_cols
dba_mview_logs
dba_mview_refresh_times
dba_mviews
dba_nested_table_cols
dba_nested_tables
dba_obj_audit_opts
dba_obj_colattrs
dba_object_size
dba_object_tables
dba_objects
dba_opancillary
dba_oparguments
dba_opbindings
dba_operator_comments
dba_operators
dba_orphan_key_table
dba_outline_hints
dba_outlines
dba_outstanding_alerts
dba_part_col_statistics
dba_part_histograms
dba_part_indexes
dba_part_key_columns
dba_part_lobs
dba_part_tables
dba_partial_drop_tabs
dba_pending_conv_tables
dba_pending_transactions
dba_plsql_object_settings
dba_policies
dba_policy_contexts
dba_policy_groups
dba_priv_audit_opts
dba_procedures
dba_profiles
dba_propagation
dba_proxies
dba_published_columns
dba_queue_schedules
dba_queue_tables
dba_queues
dba_rchild
dba_recyclebin
dba_redefinition_errors
dba_redefinition_objects
dba_refresh
dba_refresh_children
dba_refs
dba_registered_archived_log
dba_registered_mview_groups
dba_registered_mviews
dba_registry
dba_registry_hierarchy
dba_repair_table
dba_resumable
dba_rewrite_equivalences
dba_rgroup
dba_role_privs
dba_roles
dba_rollback_segs
dba_rsrc_consumer_group_privs
dba_rsrc_consumer_groups
dba_rsrc_group_mappings
dba_rsrc_manager_system_privs
dba_rsrc_mapping_priority
dba_rsrc_plan_directives
dba_rsrc_plans
dba_rule_set_rules
dba_rule_sets
dba_rules
dba_scheduler_job_args
dba_scheduler_job_classes
dba_scheduler_job_log
dba_scheduler_job_run_details
dba_scheduler_jobs
dba_scheduler_program_args
dba_scheduler_programs
dba_scheduler_running_jobs
dba_scheduler_schedules
dba_scheduler_window_details
dba_scheduler_window_groups
dba_scheduler_window_log
dba_scheduler_windows
dba_scheduler_wingroup_members
dba_sec_relevant_cols
dba_segments
dba_sequences
dba_server_registry
dba_services
dba_source
dba_source_tables
dba_sql_profiles
dba_sqlj_type_attrs
dba_sqlj_type_methods
dba_sqlj_types
dba_sqlset
dba_sqlset_binds
dba_sqlset_references
dba_sqlset_statements
dba_sqltune_binds
dba_sqltune_plans
dba_sqltune_rationale_plan
dba_sqltune_statistics
dba_stmt_audit_opts
dba_stored_settings
dba_streams_administrator
dba_streams_global_rules
dba_streams_message_consumers
dba_streams_message_rules
dba_streams_newly_supported
dba_streams_rules
dba_streams_schema_rules
dba_streams_table_rules
dba_streams_transform_function
dba_streams_unsupported
dba_subpart_col_statistics
dba_subpart_histograms
dba_subpart_key_columns
dba_subpartition_templates
dba_subscribed_columns
dba_subscribed_tables
dba_subscriptions
dba_synonyms
dba_sys_privs
dba_tab_col_statistics
dba_tab_cols
dba_tab_columns
dba_tab_comments
dba_tab_histograms
dba_tab_modifications
dba_tab_partitions
dba_tab_privs
dba_tab_statistics
dba_tab_subpartitions
dba_tables
dba_tablespace_groups
dba_tablespaces
dba_temp_files
dba_thresholds
dba_transformations
dba_trigger_cols
dba_triggers
dba_ts_quotas
dba_tune_mview
dba_type_attrs
dba_type_methods
dba_type_versions
dba_types
dba_undo_extents
dba_unused_col_tabs
dba_updatable_columns
dba_users
dba_ustats
dba_varrays
dba_views
dba_waiters
dba_warning_settings
dba_xml_schemas
dba_xml_tab_cols
dba_xml_tables
dba_xml_view_cols
dba_xml_views
dbms_alert_info
dbms_lock_allocated
deptree
dict
dict_columns
dictionary
error_size
exceptions
flashback_transaction_query
global_name
hs_all_caps
hs_all_dd
hs_all_inits
hs_base_caps
hs_base_dd
hs_class_caps
hs_class_dd
hs_class_init
hs_external_object_privileges
hs_external_objects
hs_external_user_privileges
hs_fds_class
hs_fds_inst
hs_inst_caps
hs_inst_dd
hs_inst_init
ideptree
ind
index_histogram
index_stats
map_object
nls_database_parameters
nls_instance_parameters
nls_session_parameters
obj
plan_table
pluggable_set_check
product_component_version
proxy_users
pstubtbl
public_dependency
publicsyn
queue_privileges
recyclebin
resource_cost
resource_map
role_role_privs
role_sys_privs
role_tab_privs
seq
session_context
session_privs
session_roles
source_size
stmt_audit_option_map
syn
synonyms
sys_objects
syscatalog
sysfiles
syssegobj
system_privilege_map
tab
table_privilege_map
tabquotas
tabs
trusted_servers
ts_pitr_check
ts_pitr_objects_to_be_dropped
uni_pluggable_set_check
dba_2pc_neighbors
dba_2pc_pending
dba_advisor_actions
dba_advisor_commands
dba_advisor_definitions
dba_advisor_findings
dba_advisor_journal
dba_advisor_log
dba_advisor_object_types
dba_advisor_objects
dba_advisor_parameters
dba_advisor_rationale
dba_advisor_recommendations
dba_advisor_sqla_rec_sum
dba_advisor_sqla_wk_map
dba_advisor_sqla_wk_stmts
dba_advisor_sqlw_journal
dba_advisor_sqlw_parameters
dba_advisor_sqlw_stmts
dba_advisor_sqlw_sum
dba_advisor_sqlw_tables
dba_advisor_sqlw_templates
dba_advisor_tasks
dba_advisor_templates
dba_advisor_usage
dba_alert_history
dba_all_tables
dba_application_roles
dba_apply
dba_apply_conflict_columns
dba_apply_dml_handlers
dba_apply_enqueue
dba_apply_error
dba_apply_execute
dba_apply_instantiated_global
dba_apply_instantiated_objects
dba_apply_instantiated_schemas
dba_apply_key_columns
dba_apply_parameters
dba_apply_progress
dba_apply_table_columns
dba_aq_agent_privs
dba_aq_agents
dba_associations
dba_attribute_transformations
dba_audit_exists
dba_audit_object
dba_audit_policies
dba_audit_policy_columns
dba_audit_session
dba_audit_statement
dba_audit_trail
dba_aw_ps
dba_aws
dba_base_table_mviews
dba_blockers
dba_capture
dba_capture_extra_attributes
dba_capture_parameters
dba_capture_prepared_database
dba_capture_prepared_schemas
dba_capture_prepared_tables
dba_catalog
dba_clu_columns
dba_cluster_hash_expressions
dba_clusters
dba_col_comments
dba_col_privs
dba_coll_types
dba_common_audit_trail
dba_cons_obj_columns
dba_constraints
dba_context
dba_data_files
dba_datapump_jobs
dba_datapump_sessions
dba_db_links
dba_ddl_locks
dba_dependencies
dba_dim_attributes
dba_dim_child_of
dba_dim_hierarchies
dba_dim_join_key
dba_dim_level_key
dba_dim_levels
dba_dimensions
dba_directories
dba_dml_locks
dba_dmt_free_space
dba_dmt_used_extents
dba_enabled_aggregations
dba_enabled_traces
dba_errors
dba_evaluation_context_tables
dba_evaluation_context_vars
dba_evaluation_contexts
dba_exp_files
dba_exp_objects
dba_exp_version
dba_extents
dba_external_locations
dba_external_tables
dba_feature_usage_statistics
dba_fga_audit_trail
dba_free_space
dba_free_space_coalesced
dba_high_water_mark_statistics
dba_hist_active_sess_history
dba_hist_baseline
dba_hist_bg_event_summary
dba_hist_buffer_pool_stat
dba_hist_cr_block_server
dba_hist_current_block_server
dba_hist_database_instance
dba_hist_datafile
dba_hist_db_cache_advice
dba_hist_dlm_misc
dba_hist_enqueue_stat
dba_hist_event_name
dba_hist_filemetric_history
dba_hist_filestatxs
dba_hist_instance_recovery
dba_hist_java_pool_advice
dba_hist_latch
dba_hist_latch_children
dba_hist_latch_misses_summary
dba_hist_latch_name
dba_hist_latch_parent
dba_hist_librarycache
dba_hist_log
dba_hist_metric_name
dba_hist_mttr_target_advice
dba_hist_optimizer_env
dba_hist_osstat
dba_hist_osstat_name
dba_hist_parameter
dba_hist_parameter_name
dba_hist_pga_target_advice
dba_hist_pgastat
dba_hist_resource_limit
dba_hist_rollstat
dba_hist_rowcache_summary
dba_hist_seg_stat
dba_hist_seg_stat_obj
dba_hist_service_name
dba_hist_service_stat
dba_hist_service_wait_class
dba_hist_sessmetric_history
dba_hist_sga
dba_hist_sgastat
dba_hist_shared_pool_advice
dba_hist_snap_error
dba_hist_snapshot
dba_hist_sql_plan
dba_hist_sql_summary
dba_hist_sql_workarea_hstgrm
dba_hist_sqlbind
dba_hist_sqlstat
dba_hist_sqltext
dba_hist_stat_name
dba_hist_sys_time_model
dba_hist_sysmetric_history
dba_hist_sysmetric_summary
dba_hist_sysstat
dba_hist_system_event
dba_hist_tablespace_stat
dba_hist_tbspc_space_usage
dba_hist_tempfile
dba_hist_tempstatxs
dba_hist_thread
dba_hist_undostat
dba_hist_waitclassmet_history
dba_hist_waitstat
dba_hist_wr_control
dba_ind_columns
dba_ind_expressions
dba_ind_partitions
dba_ind_statistics
dba_ind_subpartitions
dba_indexes
dba_indextype_arraytypes
dba_indextype_comments
dba_indextype_operators
dba_indextypes
dba_internal_triggers
dba_java_arguments
dba_java_classes
dba_java_derivations
dba_java_fields
dba_java_implements
dba_java_inners
dba_java_layouts
dba_java_methods
dba_java_ncomps
dba_java_policy
dba_java_resolvers
dba_java_throws
dba_jobs
dba_jobs_running
dba_join_ind_columns
dba_kgllock
dba_libraries
dba_lmt_free_space
dba_lmt_used_extents
dba_lob_partitions
dba_lob_subpartitions
dba_lob_templates
dba_lobs
dba_lock
dba_lock_internal
dba_locks
dba_log_group_columns
dba_log_groups
dba_logmnr_log
dba_logmnr_purged_log
dba_logmnr_session
dba_logstdby_events
dba_logstdby_log
dba_logstdby_not_unique
dba_logstdby_parameters
dba_logstdby_progress
dba_logstdby_skip
dba_logstdby_skip_transaction
dba_logstdby_unsupported
dba_method_params
dba_method_results
dba_mview_aggregates
dba_mview_analysis
dba_mview_comments
dba_mview_detail_relations
dba_mview_joins
dba_mview_keys
dba_mview_log_filter_cols
dba_mview_logs
dba_mview_refresh_times
dba_mviews
dba_nested_table_cols
dba_nested_tables
dba_obj_audit_opts
dba_obj_colattrs
dba_object_size
dba_object_tables
dba_objects
dba_opancillary
dba_oparguments
dba_opbindings
dba_operator_comments
dba_operators
dba_orphan_key_table
dba_outline_hints
dba_outlines
dba_outstanding_alerts
dba_part_col_statistics
dba_part_histograms
dba_part_indexes
dba_part_key_columns
dba_part_lobs
dba_part_tables
dba_partial_drop_tabs
dba_pending_conv_tables
dba_pending_transactions
dba_plsql_object_settings
dba_policies
dba_policy_contexts
dba_policy_groups
dba_priv_audit_opts
dba_procedures
dba_profiles
dba_propagation
dba_proxies
dba_published_columns
dba_queue_schedules
dba_queue_tables
dba_queues
dba_rchild
dba_recyclebin
dba_redefinition_errors
dba_redefinition_objects
dba_refresh
dba_refresh_children
dba_refs
dba_registered_archived_log
dba_registered_mview_groups
dba_registered_mviews
dba_registry
dba_registry_hierarchy
dba_repair_table
dba_resumable
dba_rewrite_equivalences
dba_rgroup
dba_role_privs
dba_roles
dba_rollback_segs
dba_rsrc_consumer_group_privs
dba_rsrc_consumer_groups
dba_rsrc_group_mappings
dba_rsrc_manager_system_privs
dba_rsrc_mapping_priority
dba_rsrc_plan_directives
dba_rsrc_plans
dba_rule_set_rules
dba_rule_sets
dba_rules
dba_scheduler_job_args
dba_scheduler_job_classes
dba_scheduler_job_log
dba_scheduler_job_run_details
dba_scheduler_jobs
dba_scheduler_program_args
dba_scheduler_programs
dba_scheduler_running_jobs
dba_scheduler_schedules
dba_scheduler_window_details
dba_scheduler_window_groups
dba_scheduler_window_log
dba_scheduler_windows
dba_scheduler_wingroup_members
dba_sec_relevant_cols
dba_segments
dba_sequences
dba_server_registry
dba_services
dba_source
dba_source_tables
dba_sql_profiles
dba_sqlj_type_attrs
dba_sqlj_type_methods
dba_sqlj_types
dba_sqlset
dba_sqlset_binds
dba_sqlset_references
dba_sqlset_statements
dba_sqltune_binds
dba_sqltune_plans
dba_sqltune_rationale_plan
dba_sqltune_statistics
dba_stmt_audit_opts
dba_stored_settings
dba_streams_administrator
dba_streams_global_rules
dba_streams_message_consumers
dba_streams_message_rules
dba_streams_newly_supported
dba_streams_rules
dba_streams_schema_rules
dba_streams_table_rules
dba_streams_transform_function
dba_streams_unsupported
dba_subpart_col_statistics
dba_subpart_histograms
dba_subpart_key_columns
dba_subpartition_templates
dba_subscribed_columns
dba_subscribed_tables
dba_subscriptions
dba_synonyms
dba_sys_privs
dba_tab_col_statistics
dba_tab_cols
dba_tab_columns
dba_tab_comments
dba_tab_histograms
dba_tab_modifications
dba_tab_partitions
dba_tab_privs
dba_tab_statistics
dba_tab_subpartitions
dba_tables
dba_tablespace_groups
dba_tablespaces
dba_temp_files
dba_thresholds
dba_transformations
dba_trigger_cols
dba_triggers
dba_ts_quotas
dba_tune_mview
dba_type_attrs
dba_type_methods
dba_type_versions
dba_types
dba_undo_extents
dba_unused_col_tabs
dba_updatable_columns
dba_users
dba_ustats
dba_varrays
dba_views
dba_waiters
dba_warning_settings
dba_xml_schemas
dba_xml_tab_cols
dba_xml_tables
dba_xml_view_cols
dba_xml_views
dbms_alert_info
dbms_lock_allocated
deptree
dict
dict_columns
dictionary
error_size
exceptions
flashback_transaction_query
global_name
hs_all_caps
hs_all_dd
hs_all_inits
hs_base_caps
hs_base_dd
hs_class_caps
hs_class_dd
hs_class_init
hs_external_object_privileges
hs_external_objects
hs_external_user_privileges
hs_fds_class
hs_fds_inst
hs_inst_caps
hs_inst_dd
hs_inst_init
ideptree
ind
index_histogram
index_stats
map_object
nls_database_parameters
nls_instance_parameters
nls_session_parameters
obj
plan_table
pluggable_set_check
product_component_version
proxy_users
pstubtbl
public_dependency
publicsyn
queue_privileges
recyclebin
resource_cost
resource_map
role_role_privs
role_sys_privs
role_tab_privs
seq
session_context
session_privs
session_roles
source_size
stmt_audit_option_map
syn
synonyms
sys_objects
syscatalog
sysfiles
syssegobj
system_privilege_map
tab
table_privilege_map
tabquotas
tabs
trusted_servers
ts_pitr_check
ts_pitr_objects_to_be_dropped
uni_pluggable_set_check
No comments:
Post a Comment