Re: How can find parameter db_file_direct_io_count

From: Christian Antognini <christian.antognini_at_trivadis.com>
Date: Thu, 9 Sep 2004 14:51:28 +0200
Message-ID: <414051cd@post.usenet.com>

• Post for FREE via your newsreader at post.usenet.com ****

"Nicky" <fuffaspam_at_quipo.it> wrote in message news:chp6cs$t4e$1_at_newsserver.cilea.it...
> Hello
>
> I need to modifify a parameter that I can't find using using sqlplus->show
> parameter or Enterprise Manamgement Console.
>
> Do you know if this parameter exists ? or maybe it's has been renamed in
> someone other ?

It appends that parameters are removed or make available as undocumented parameters. This is such a case... in 9.2 or 10.1 it is only available as undocumented. With a select like the following one you should be able to find it...

select a.ksppinm "Parameter",
  decode(p.isses_modifiable,'FALSE',NULL,NULL,NULL,b.ksppstvl) "Session",

  c.ksppstvl "Instance",
  p.isses_modifiable "S-Mod",
  p.issys_modifiable "I-Mod"

from x$ksppi a, x$ksppcv b, x$ksppsv c, v$parameter p where a.indx = b.indx and a.indx = c.indx and p.name(+) = a.ksppinm
and a.ksppinm = '_db_file_direct_io_count';

Chris

PS: I don't know why you what to modify it... anyway, I'll not do it without a good reason! Notice that if you get the advice you should modify it, the source is not up to date! In fact, as you have seen, the parameter doesn't exist, officially.

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

• Usenet.com - The #1 Usenet Newsgroup Service on The Planet! *** http://www.usenet.com Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

Received on Thu Sep 09 2004 - 07:51:28 CDT