Tuesday, October 16, 2012

RAC Views

Advanced Queuing

------------------------
gv$aq gv$persistent_publishers gv$qmon_server_stats

gv$aq1 gv$persistent_qmn_cache gv$qmon_task_stats

gv$buffered_publishers gv$persistent_queues gv$qmon_tasks

gv$buffered_queues gv$persistent_subscribers gv$queue

gv$buffered_subscribers gv$qmon_coordinator_stats gv$queueing_mth


Advisors

gv$advisor_current_sqlplan gv$pga_target_advice

gv$advisor_progress gv$pga_target_advice_histogram

gv$java_pool_advice gv$px_buffer_advice

gv$mttr_target_advice


Archive Logging
==========
gv$archive v$proxy_archivelog_details

gv$archive_dest v$proxy_archivelog_summary

gv$archive_dest_status

gv$archive_gap

gv$archive_processes

gv$archived_log

gv$proxy_archivedlog

ASH
======
gv$ash_info gv$active_session_history gv$max_active_sess_target_mth

ASM
====
gv$asm_acfs_encryption_info gv$asm_disk gv$asm_operation

gv$asm_acfs_security_info gv$asm_disk_iostat gv$asm_template

gv$asm_acfssnapshots gv$asm_disk_stat gv$asm_user

gv$asm_acfsvolumes gv$asm_diskgroup gv$asm_usergroup

gv$asm_alias gv$asm_diskgroup_stat gv$asm_usergroup_member

gv$asm_attribute gv$asm_file gv$asm_volume

gv$asm_client gv$asm_filesystem gv$asm_volume_stat


Backup and Recovery (RMAN)
=======================

gv$backup v$backup_archivelog_details

gv$backup_async_io v$backup_archivelog_summary

gv$backup_datafile v$backup_controlfile_details

gv$backup_device v$backup_controlfile_summary

gv$backup_piece v$backup_copy_details

gv$backup_redolog v$backup_copy_summary

gv$backup_set v$backup_corruption

gv$backup_spfile v$backup_datafile_details

gv$backup_sync_io v$backup_datafile_summary

gv$database_incarnation v$backup_files

gv$datafile_copy v$backup_piece_details

gv$db_transportable_platform v$backup_set_details

gv$deleted_object v$backup_set_summary

gv$fast_start_servers v$backup_spfile_details

gv$fast_start_transactions v$backup_spfile_summary

gv$instance_recovery v$block_change_tracking

gv$proxy_datafile gv$copy_corruption

gv$recover_file gv$database_block_corruption

gv$recovery_area_usage v$proxy_copy_details

gv$recovery_file_status v$proxy_copy_summary

gv$recovery_log v$recovery_file_dest

gv$recovery_progress v$rman_backup_job_details

gv$recovery_status v$rman_backup_subjob_details

gv$rman_output v$rman_backup_type

gv$tsm_sessions v$rman_compression_algorithm

v$rman_configuration

v$rman_encryption_algorithms

v$rman_status

v$unusable_backupfile_details

Monday, October 1, 2012

complete list of the 10g DBA views:-

Here is a 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



Wednesday, September 19, 2012

How to take Backup of ORACLE_HOME

$ mkdir $C_ORACLE_HOME


$ chown $ORACLE_OWNER_GROUP $C_ORACLE_HOME

$ cd $O_ORACLE_HOME

$ tar cfp - .
( cd $C_ORACLE_HOME; tar xf - )

$ export ORACLE_HOME=$C_ORACLE_HOME

$ perl $ORACLE_HOME/clone/bin/clone.pl \

ORACLE_BASE=$ORACLE_BASE \

ORACLE_HOME=$C_ORACLE_HOME \

ORACLE_HOME_NAME=$C_ORACLE_HOME_NAME


Non-RAC : How To Perform Out Of Place Patching To Minimize DB Downtime [ID 1389364.1]
https://support.oracle.com/epmos/faces/ui/km/SearchDocDisplay.jspx?_afrLoop=297442591599278&type=DOCUMENT&id=822490.1&displayIndex=7&_afrWindowMode=0&_adf.ctrl-state=gaegyb7tf_78