DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: show parameter

  1. #1
    Join Date
    Nov 2001
    Location
    Singapore
    Posts
    182

    show parameter

    My oracle database version is IS 7.3.4 if i give show parameter doesnot give any information shows error message given below but samething iam able to get in ver 8.1.7

    OPS3 SQL> show parameter db_block_size
    unknown SHOW option "parameter"
    unknown SHOW option beginning "db_block_s..."

    OPS3 SQL> show sga
    unknown SHOW option "sga"


    OPS3 SQL> show parameter db_block_buffers
    unknown SHOW option "parameter"
    unknown SHOW option beginning "db_block_b..."
    J Gangadhar

  2. #2
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    well i dont have a 7.3 database now..maybe its because in 7.3 that show parameter feature wasnt available :-)

    regards
    Hrishy

  3. #3
    Join Date
    Sep 2002
    Posts
    12
    Show parameter is not available in Oracle 7.3.x

    Corrado
    Corrado Mascioli

  4. #4
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    Hi

    Try SHOW PARAMETER in svrmgrl. It works
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  5. #5
    Join Date
    Oct 2002
    Posts
    391
    possible to get the list of parameters to " show parameter"

    like

    1) show parameter archive
    2) show parameter writer

    and etc..

    thanks

  6. #6
    Join Date
    Jun 2002
    Location
    VA,USA
    Posts
    83
    hi ..
    show parameter is not there in oracle 7.3 ..
    try "select * from v$parameter;".

    thanks
    sarav
    saravana kumar

  7. #7
    Join Date
    Oct 2002
    Posts
    391
    that will list all the parameters ..

    what i meant is groups of values in a parameter value.

    example, show parameter archives, shows those parameters with archives related information

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width