 |
|
Oracle Tips by Burleson |
Show Oracle Parameters
Using the students database, enter the
SQL*Plus utility and issue the appropriate “show parameter” commands
to display the major Oracle components.
Task 1 – Show archiving parameters –
The settings for the archived redo logs are important for Oracle
database roll-forward recovery. Use the “show parameter” command to
display all parameters relating to the archiving of redo log data.
Task 2 – Oracle parallel query is a
great tool for improving the speed of large-table full-table scans.
Find all of the Oracle parameters that relate to parallel features.
ANSWERS
SQL> show
parameter arch
NAME TYPE VALUE
------------------------------------ ----------- ---------------
archive_lag_target integer 0
log_archive_dest string
log_archive_dest_1 string
log_archive_dest_10 string
log_archive_dest_2 string
log_archive_dest_3 string
log_archive_dest_4 string
log_archive_dest_5
string
log_archive_dest_6 string
log_archive_dest_7 string
log_archive_dest_8 string
log_archive_dest_9 string
log_archive_dest_state_1 string enable
log_archive_dest_state_10 string enable
log_archive_dest_state_2 string enable
log_archive_dest_state_3 string enable
log_archive_dest_state_4 string enable
log_archive_dest_state_5 string enable
log_archive_dest_state_6 string enable
log_archive_dest_state_7 string
enable log_archive_dest_state_8
string enable
log_archive_dest_state_9 string enable
log_archive_duplex_dest string
log_archive_format string ARC%S.%T
log_archive_max_processes integer 1
log_archive_min_succeed_dest integer 1
log_archive_start boolean
FALSE
log_archive_trace integer 0
remote_archive_enable boolean
TRUE
standby_archive_dest string
%ORACLE_HOME%\RDBMS
SQL> show
parameter parallel
NAME TYPE VALUE
------------------------------------ -----------
----------------------
fast_start_parallel_rollback string LOW
parallel_adaptive_multi_user boolean
FALSEparallel_automatic_tuning boolean FALSE
parallel_broadcast_enabled boolean
FALSE
parallel_execution_message_size integer
2148
parallel_instance_group string
parallel_max_servers integer 5
parallel_min_percent integer 0
parallel_min_servers integer 0
parallel_server boolean FALSE
parallel_server_instances integer 1
parallel_threads_per_cpu integer 2
recovery_parallelism integer 0
For more details, see the "Easy
Oracle Series" a set of books especially designed by Oracle
experts to get you started fast with Oracle database technology.
|
