Oracle Keep Pool
From: The Magnet <art_at_unsu.com>
Date: Mon, 30 Nov 2009 07:33:45 -0800 (PST)
Message-ID: <b99415d8-71b0-4421-8424-0b8b58140a88_at_m11g2000vbo.googlegroups.com>
Date: Mon, 30 Nov 2009 07:33:45 -0800 (PST)
Message-ID: <b99415d8-71b0-4421-8424-0b8b58140a88_at_m11g2000vbo.googlegroups.com>
Hi,
When you issue and ALTER TABLE command and put a table into the KEEP pool, how can you get a list of table that have been put into the keep pool? Is there come X$ view? I cannot find a v$ view.
Also, will these tables automatically reload into the KEEP pool on restart, or do I need a startup trigger? I would think on startup it would be automatic, but I am not sure. Received on Mon Nov 30 2009 - 09:33:45 CST