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

Thread: Hidden parameters

  1. #1
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995

    Hidden parameters

    Just got done applying the april AIVA and during the patch apply, it messes with the
    _system_trig_enabled parameter.
    If you query V$PARAMETER it's not in there. NE1 know what view that bugger is kept so I can look at it? I want to know if the patch put it back to normal after it was done. I have the most sneakest feeling that it didn't because I'm not finding it anywhere in the patch code.
    Oracle it's not just a database it's a lifestyle!
    --------------
    BTW....You need to get a girlfriend who's last name isn't .jpg

  2. #2
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Code:
    select a.ksppinm name, b.ksppstvl value, b.ksppstdf isdefault,
           decode(a.ksppity, 1, 'boolean', 2, 'string', 3, 'number', 4, 'file',
          a.ksppity) type,
           a.ksppdesc description
    from   sys.x$ksppi a, sys.x$ksppcv b
    where  a.indx = b.indx
      and  a.ksppinm like '\_%' escape '\'
    order  by name
    
    ##Execute this query to know all hidden parameters 
    ##connect with sys or internal

    Abhay.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  3. #3
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    Thanks abhaysk! you da man!
    Oracle it's not just a database it's a lifestyle!
    --------------
    BTW....You need to get a girlfriend who's last name isn't .jpg

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