Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Displaying the contents of parameter file.....

sgalaxyMar 11 2007 — edited Mar 11 2007

Hi ,
How to display all parameter names and their values in SQL*PLUS ...?????
I have tried the following:

SQL>  show parameter all

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------
fast_start_parallel_rollback         string      LOW
parallel_adaptive_multi_user         boolean     TRUE
parallel_automatic_tuning            boolean     FALSE
parallel_execution_message_size      integer     2148
parallel_instance_group              string
parallel_max_servers                 integer     40
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

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------
recovery_parallelism                 integer     0

but some are displayed... not all...!!!!!

NOTE : I use Oracle 10g v.2 on XP platform...

Thanks , a lot
Simon

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 8 2007

Added on Mar 11 2007

#general-database-discussions

3 comments

387 views