Re: Maxextents unlimited on LMT ?

In article <3d2c2384$0$14694$afc38c87_at_news.optusnet.com.au>, Nuno says...
>
>In article <aggfnf01k96_at_drn.newsguy.com>, you said (and I quote):
>
>> Again, you might argue it shouldn't be so, but to me MAXEXTENTS is the wrong
>> thing to do capacity management with anyway. The as yet undocumented MAXSIZE
>>parameter I mentioned in another reply might be better. Of course the fact that
>> it doesn't exist might explain why it's not documented :)
>
>Hmmmmm. So, when is it usable? ;-)
>
>>
>> You want the functionality or not? ;)
>>
>
>Er.... yes.
>
>>My personal viewpoint is that you'll see these packages used by Oracle itself to
>>"self-manage". Doesn't it then make sense that you as an experienced DBA might
>> find them useful too?
>
>Yeah. But I kinda prefer the facility to be there from SQL. Used by
>DBMS packages to self-manage, by all means. And normally optional. But
>leave it there.
>
>The DBMS* packages are too open to doco "misses" and stuff like that.
>IIRC for example, the one that lets you set events to a specific session
>is not documented in 8i AND 9i. Yet, people have been using it since
>8iR3 came out. One way or another it became known.

To a certain extent I can understand this one. You know the company mantra - "thou shalt not set an event without Oracle Support telling thee to".

>
>What I don't like is that it got skipped in the doco. Makes me wonder
>how many more got the same treatment. I still well remember the days
>when Oracle was a closed environment where only selected "luminaries"
>were given access to privileged info. That didn't work then, won't work
>now.
>

Some of these have been left undocumented purely and simply because they're meant for internal use only (i.e. something else in the Oracle code uses it). Whether that makes sense or not is probably not up to me to decide, but there are always going to be people like Jonathan that find out about something like this simply because they see it and play around with it. Sometimes that works out well, sometimes you end up with more myths (like the discussions that have been held here about things like the setting of SPIN_COUNT - not that I'm implying Jonathan had anything to do with this!).
>
>> Ahah! I take back my "experienced DBA" comment! ;)
>
><groan>
>:-)
>

Sorry couldn't resist! :)
>
>--
>Cheers
>Nuno Souto
>nsouto_at_optushome.com.au.nospam

HTH. Additions and corrections welcome.

Pete

SELECT standard_disclaimer, witty_remark FROM company_requirements; Received on Wed Jul 10 2002 - 11:37:38 CDT