Monday, January 19, 2009

V$OBSOLETE_PARAMETER

V$OBSOLETE_PARAMETER displays information about obsolete initialization parameters. If any row of the view contains TRUE in the ISSPECIFIED column, then you should examine why.

Column

Datatype

Description

NAME

VARCHAR2(64)

Name of the parameter

ISSPECIFIED

VARCHAR2(5)

Indicates whether the parameter was specified in the parameter file (TRUE) or not (FALSE)

Note:

1. Obsolete parameters in Oracle 10gR2:

SQL> select NAME from V$OBSOLETE_PARAMETER order by NAME;

NAME

----------------------------------------------------------------

_average_dirties_half_life

_compatible_no_recovery

_db_no_mount_lock

_kspptbl_mem_usage

_lm_direct_sends

_lm_multiple_receivers

_lm_statistics

_oracle_trace_events

_oracle_trace_facility_version

_plsql_conditional_compilation

_seq_process_cache_const

allow_partial_sn_results

always_anti_join

always_semi_join

arch_io_slaves

b_tree_bitmap_plans

backup_disk_io_slaves

cache_size_threshold

cleanup_rollback_entries

close_cached_open_cursors

complex_view_merging

db_block_checkpoint_batch

db_block_lru_extended_statistics

db_block_lru_latches

db_block_lru_statistics

db_block_max_dirty_target

db_file_simultaneous_writes

dblink_encrypt_login

delayed_logging_block_cleanouts

discrete_transactions_enabled

distributed_recovery_connection_hold_time

distributed_transactions

enqueue_resources

fast_full_scan_enabled

freeze_DB_for_fast_instance_recovery

gc_defer_time

gc_latches

gc_lck_procs

gc_releasable_locks

gc_rollback_locks

hash_join_enabled

hash_multiblock_io_count

instance_nodeset

job_queue_interval

job_queue_keep_connections

large_pool_min_alloc

lgwr_io_slaves

lm_locks

lm_procs

lm_procs

lm_ress

lock_sga_areas

log_block_checksum

log_files

log_parallelism

log_simultaneous_copies

log_small_entry_max_size

max_rollback_segments

max_transaction_branches

mts_circuits

mts_dispatchers

mts_listener_address

mts_max_dispatchers

mts_max_servers

mts_multiple_listeners

mts_servers

mts_service

mts_sessions

ogms_home

ops_admin_group

ops_interconnects

optimizer_max_permutations

optimizer_percent_parallel

optimizer_search_limit

oracle_trace_collection_name

oracle_trace_collection_path

oracle_trace_collection_size

oracle_trace_enable

oracle_trace_facility_name

oracle_trace_facility_path

parallel_broadcast_enabled

parallel_default_max_instances

parallel_min_message_pool

parallel_server_idle_time

parallel_transaction_resource_timeout

partition_view_enabled

plsql_native_c_compiler

plsql_native_linker

plsql_native_make_file_name

plsql_native_make_utility

push_join_predicate

row_cache_cursors

row_locking

sequence_cache_entries

sequence_cache_hash_buckets

serializable

shared_pool_reserved_min_alloc

snapshot_refresh_interval

snapshot_refresh_keep_connections

snapshot_refresh_processes

sort_direct_writes

sort_multiblock_read_count

sort_read_fac

sort_spacemap_size

sort_write_buffer_size

sort_write_buffers

spin_count

standby_preserves_names

temporary_table_locks

text_enable

transaction_auditing

undo_suppress_errors

use_ism

113 rows selected.

2. ORA-32004 is usually related obsolete and/or deprecated parameters when attempting to start a database: ORA-32004: obsolete and/or deprecated parameter(s) specified. The parameter initialization file should be checked to see that none of the specified parameters match a parameter name stored in the V$OBSOLETE_PARAMETER view of that same database.

Oracle data dictionary views

Oracle dynamic performance views

V$MVREFRESH

V$MVREFRESH displays information about the materialized views currently being refreshed.

Column

Datatype

Description

SID

NUMBER

Session identifier

SERIAL#

NUMBER

Session serial number, which is used to uniquely identify a session's objects. Guarantees that session-level commands are applied to the correct session objects if the session ends with, and another session begins with, the same session ID.

CURRMVOWNER

VARCHAR2(31)

Owner of the materialized view currently being refreshed. The materialized view resides in this user's schema.

CURRMVNAME

VARCHAR2(31)

Name of the materialized view currently being refreshed

Oracle data dictionary views

Oracle dynamic performance views

V$EXECUTION

V$EXECUTION displays information on parallel execution.

Column

Datatype

Description

PID

NUMBER

Session ID

DEPTH

NUMBER

The depth

FUNCTION

VARCHAR2(10)

Session serial number

TYPE

VARCHAR2(7)

Name of the OBJECT_NODE in plan table

NVALS

NUMBER

Elapsed time for OBJECT_NODE

VAL1

NUMBER

The value for number 1

VAL2

NUMBER

The value for number 2

SEQH

NUMBER

A sequence

SEQL

NUMBER

A sequence

Oracle data dictionary views

Oracle dynamic performance views