RE: segment advisor question

Date: Tue, 31 Mar 2009 13:41:33 -0400
Message-ID: <>


I wanted to find the tables so I could create a procedure that run the segment advisor then act on what it finds. I know it could be risky doing this, but if I have a small timeframe in which to shrink space on tables/indexes and it's 2am in the morning, I'd like to have this run automatically. Where I work has an application that likes to insert/delete into tables... Frequently and space is becoming a serious issue for the users. We're not able to get any larger file systems for a while and this is one way that I can manage keeping the space to a minimum.

I will look over the documents.

Thank you,

P Consider the environment. Please don't print this e-mail unless you really need to.

From: Kurt [] Sent: Tuesday, March 31, 2009 1:36 PM
Cc: oracle-l
Subject: Re: segment advisor question

Hi Jeremy,

I'm wondering what problem you're trying to solve?

While not answering your question directly, maybe these two procedures might provide the information you are looking for:



I hope this helps.


The opinions expressed in this email are my own, and not my company's. On Tue, Mar 31, 2009 at 6:31 AM, SHEEHAN, JEREMY <<>> wrote:

Does anyone know where the 10g segment advisor stores it's data?

-- Received on Tue Mar 31 2009 - 12:41:33 CDT

Original text of this message