Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How can find parameter db_file_direct_io_count
"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 ?
>
> thanks
>
> bye
Nicky,
You can query v$parameter to see any parameterīs value.
For instance, enter:
select name, value from v$parameter where name = 'db_file_direct_io_count';
(note: parameter name in lower case, exactly as in the above example.
Received on Thu Sep 09 2004 - 11:27:12 CDT