Re: Number of database files

On Mar 9, 4:45 am, "A.ISS" <a..._at_gee-mail.kom> wrote:
> Hi,
>
> I want to check (Oracle 8.1.7.4 and higher) if the current number of data
> files is nearing the number specified by the db_files parameter.
> To achieve this I have devised the following select:
>
> select  'Number of datafiles ('||a.records_used||') nears db_files parameter ('||b.value||') : '
>        ||(b.value-a.records_used) message
> from V$CONTROLFILE_RECORD_SECTION a,
>      v$parameter b
> where a.type = 'DATAFILE'
>   and b.name = 'db_files'
>   and b.value - a.records_used <= 10
> /
>
> To my understanding increasing the db_files parameter will automatically
> increase the maxdatafiles value in the control file.

True O9&O10: http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/dfiles.htm#sthref1343 Not true O8: http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76956/control.htm#475

See metalink Note:119507.1

jg

--
@home.com is bogus.
http://www.forbes.com/2008/02/24/pollution-baku-oil-biz-logistics-cx_tl_0226dirtycities_slide_20.html?thisSpeed=15000