Re: dbms_space_admin.segment_moveblocks procedure: purpose ?

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 15 Mar 2007 16:40:13 -0700
Message-ID: <1174002011.414883@bubbleator.drizzle.com>

joel garry wrote:

> On Mar 15, 12:04 pm, "Michel Cadot" <micadot{at}altern{dot}org> wrote:
> 


>> |

>> | Of course, the way some people revel in using undocumented features in

>> | production environs is even worse. It's not only often wrong, but
>> | asking for trouble.
>>
>> That's what I wanted to mean.
>>
>> |
>> | Nothing wrong with learning and exploring though, it should be
>> | encouraged in my view. How one applies such knowledge is what is
>> | important, distinguishing the professional from the poseur. Some
>> | companies base their commercial existence on using obscure features,
>> | which is fine as long as they have the appropriate quality control.
>> | FWIW, IMNSHO I don't think Oracle has appropriate quality control.
>> | The QC of the docs has improved noticeably over time, but it _is_ a
>> | tough, perhaps intractable, problem keeping them totally correct.
>> |
>> | Now, in your first response you said the procedure is not public.
>> | Yet, anyone can look at the script that creates it. What does not
>> | public mean?
>>
>> I never lock the door of my garden, this does not mean you are
>> allowed to enter.

> 
> But if you sell me a habenero, I'm likely to take out the insides.
> 
> jg
> --
> @home.com is bogus.
> http://seeds.thompson-morgan.com/us/en/product/949/1?SA=1113

Last night I added to the PSOUG website the procs missing from the library. Specifically I added demos for:

ASSM_SEGMENT_SYNCHWM
TABLEPACE_DUMP_BITMAPS and I looked at:

SEGMENT_MOVEBLOCKS
SEGMENT_NUMBER_BLOCKS
SEGMENT_NUMBER_EXTENTS

from which I concluded anyone using either of these three deserves what they get.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Thu Mar 15 2007 - 18:40:13 CDT