Re: Pinning a large view to memory

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/05/06
Message-ID: <957565423.22828.0.pluto.d4ee154e@news.demon.nl>#1/1

Check dbmspool.sql in $ORACLE_HOME/rdbms/admin You should be able to pin a view with dbms_shared_pool.keep.

Hth,

Sybrand Bakker, Oracle DBA

<c_dopp_at_my-deja.com> schreef in berichtnieuws 8ev9v2$m7q$1_at_nnrp1.deja.com...
> Help! We are on 8.0.5 on Solaris 7 and have a monstrous view that is
> taking 40 minutes to load into memory the first time after reboot.
>
> Is there any way to "trick" ORACLE into treating it like a procedure or
> cursor so that I can pin it into memory on startup?
>
> Thanks in advance for your help!
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sat May 06 2000 - 00:00:00 CDT