OraFAQ Forum: Server Administration » how to show all oracle database parameter ??

Home » RDBMS Server » Server Administration » how to show all oracle database parameter ??

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to show all oracle database parameter ?? [message #150050]

Tue, 06 December 2005 01:45

raddisonlee
Messages: 29
Registered: March 2005

Junior Member

hi ,can anyone could tell me how to show all database parameter including hint parameters.......

best regards ................

Report message to a moderator

Re: how to show all oracle database parameter ?? [message #150055 is a reply to message #150050]

Tue, 06 December 2005 02:01

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

scott@9i > show parameter dump

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
background_core_dump                 string      partial
background_dump_dest                 string      /u01/app/oracle/admin/mutation
                                                 /bdump
core_dump_dest                       string      /u01/app/oracle/admin/mutation
                                                 /cdump
max_dump_file_size                   string      UNLIMITED
shadow_core_dump                     string      partial
user_dump_dest                       string      /u01/app/oracle/admin/mutation
                                                 /udump

which is actaully derived from v$parameter and HINTS are specified in the sql.

Report message to a moderator