Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Pinning a large view to memory

Pinning a large view to memory

From: <c_dopp_at_my-deja.com>
Date: 2000/05/05
Message-ID: <8ev9v2$m7q$1@nnrp1.deja.com>#1/1 






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 Fri May 05 2000 - 00:00:00 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US