Re: Memory leaking when creating views

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: 2000/08/01
Message-ID: <6f9cossa0abgtfk3rsr4r9ubu7etjqrso0@4ax.com>#1/1

Running out of physical memory is not an issue when creating views. Views are simply stored SELECT statements, and it is true that when you select from a view that Oracle will read the view's query into an area of memory known as the Shared Pool. However, this use of memory is minimal. Bottom line, don't worry about creating views, and especially don't worry about only 20 of them.

A good book on tuning that will tell you how to monitor and tune the Shared Pool and other memory structures is Oracle Performance Tuning Tips & Techniques by Richard Niemiec.

regards,

Jonathan

---

jonathan_at_gennick.com
http://gennick.com
Brighten the Corner Where You Are

On Mon, 31 Jul 2000 14:35:25 -0400, Sam Habbab <sam_at_hasc.com> wrote:

>Hi,
>
>I'm just wondering if there is any danger in creating as many views as
>one sees needed.
>So far my system has about 20 views.
Received on Tue Aug 01 2000 - 00:00:00 CDT