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

Thread: init parameters

  1. #1
    Join Date
    Apr 2002
    Posts
    135
    hello,

    Will init.ora parameters will be stored in a table.
    if so in which table ??

    thanks
    Good Judgement comes from Experience.
    Experience comes from Bad Judgement

  2. #2
    Join Date
    Apr 2002
    Posts
    291
    In v$parameter.
    PNRDBA

  3. #3
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    v$parameter

  4. #4
    Join Date
    Jul 2002
    Posts
    3
    it will store in some x$table but
    for system specific it will store in v$system
    _parameter view and session specific in v$parameter;

  5. #5
    Join Date
    May 2002
    Posts
    2,645
    With RDBMS version of SQL*Plus, you can also type "show parameter" at the SQL> prompt to see all parameters, and you can do "show parameter parameter_name" to see all parameters that have "parameter_name" in them. For example,

    SQL> show parameter dump

    NAME TYPE VALUE
    ------------------------------------ ------- --------------
    background_core_dump string partial
    background_dump_dest string ?/rdbms/log
    core_dump_dest string ?/dbs
    max_dump_file_size string 10240
    shadow_core_dump string PARTIAL
    user_dump_dest string ?/rdbms/log

  6. #6
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    maybe you should look at v$parameter
    Jeff Hunter

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