Re: Oracle Data Warehousing, UNIX and large file-enabled file systems

Well, since my group largely paid for the development of ROTS and assisted in its design, I am glad to hear of more and more use of the feature being made over the years since 7.1 beta, where we were therefore privileged to play with both ROTS, but more importantly to the core group, all the incredible things we could do with PL/SQL; as Oracle advanced between 7.0 and 7.3.ax, the changes were breathtaking and incredible. And still are, to my mind, remembering 5.0 beta. As I think back, just the changes between the last release of 6 at .36 and moving onward through 7's evolution were exciting. (Like constraints suddenly working that were formerly defined but now were enforced in actuality.)

I guess in the typical old days of big money / buy first it would have just go in the annals of one of my former corporate clients. We paid for a great deal of the development of this feature.

But, of course, now they, and many others, are using it for things we never envisioned, including of course this usage as a way of reducing backup burdens, as well as overhead on the redo/undo/rollback mechanisms. We were thinking of online archiving.

Silly us!

RSH. "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:1017091312.24426.0.nnrp-07.9e984b29_at_news.demon.co.uk...
>
> I won't comment on how, or whether you platform
> can support files larger than 2GB, but as far as
> the number of files is concerned, the issue of checkpoints
> may be irrelevant. If your data has a strong time-element,
> then you may able able to work with time-based tablespaces,
> and then switch tablespaces older than a few weeks to
> readonly mode - at which point they are no longer
> subject to checkpoints and require no further backups.
>
>
> --
> Jonathan Lewis
> http://www.jlcomp.demon.co.uk
>
> Next Seminar - UK, April 3rd - 5th
> http://www.jlcomp.demon.co.uk/seminar.html
>
> Host to The Co-Operative Oracle Users' FAQ
> http://www.jlcomp.demon.co.uk/faq/ind_faq.html
>
> Author of:
> Practical Oracle 8i: Building Efficient Databases
>
>
> Don Gillespie wrote in message
> <6ffd83a6.0203251137.50307a5f_at_posting.google.com>...
> >I am the DBA for a data warehouse environment that is expected to get
> >to about 3TB. That would mean about 1500 or so data files with the
> >2GB file limit. Besides being a nightmare to manage that many files,
> >I anticipate the overhead on checkpoints would be tremendous. The
> >environment is 32-bit Oracle (possibility of 64 bit in the future) on
> >AIX with disk storage on an IBM Shark SAN (RAID5, 32K stripe; no
> >choice here), with a 16K Oracle block size (the max allowed). We are
> >using Journaled File Systems, not raw partitions. I am contemplating
> >the use of large file-enabled JFSs for all JFSs that would contain
> >oracle data files, log files and control files. But I don't know much
> >about them, and I am wondering if there are serious performance, space
> >consumption or administration issues in doing so.
> >
>
>
>
Received on Mon Mar 25 2002 - 17:05:45 CST