Re: Number of files in an Instance?

S. Snadow wrote:
>
> Is there a limit to the number of files that can be in an Oracle 7.3
> instance?
>
> Can you do union in view across instances and gain the optimizer
> advantages?

  The number of files are bounded by the operating system. Moreover, the MAXDATAFILES parameter (when you create the control file) as well as the DB_FILES set for the session.

  You can union the views across instances by using database link. However, whether it gains the advantage is up to your query because the network overhead.

---
Name   : Lun Wing San (Certified Oracle Database Administrator)

Title  : Oracle Application Developer of Hong Kong Productivity Council
         Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841

This posting represents the personal opinions of the author. It is not the
official opinion or policy of the author's employer. Warranty expired when you
opened this article and I will not be responsible for its contents or use.