RE: inittrans on auti segment management

Depends on whether you really mean ASM or ASSM.

As Tanel put it:
"
ASSM - Automatic segment space management.

There is no such thing as freelist for an ass-managed segment, free space is managed using internal indexes and bitmaps within them in ASSM.

If interested in more, check
http://integrid.info/Poder_Freelists_vs_ASSM.ppt for quick review..

Tanel."

You can do manual segment SPACE management with ASM, which decides where to put blocks.

Regards,

mwf

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Leonard, George Sent: Thursday, October 28, 2004 7:01 AM To: oracle-l_at_freelists.org
Subject: inittrans on auti segment management

Hi all

I am sure that inittrans is one of the values controlled by oracle when you are using auto segment management on a locally managed tables.

Am I correct or is this still a DBA managed value

George
=20________________________________________________
George Leonard
Oracle Database Administrator
New Dawn Technologies @ Wesbank
E-mail:gleonard_at_wesbank.co.za
=20

You Have The Obligation to Inform One Honestly of the risk, And As a Person
You Are Committed to Educate Yourself to the Total Risk In Any Activity! Once Informed & Totally Aware of the Risk, Every Fool Has the Right to Kill or Injure Themselves as They See Fit!
=20

_________________________________________________________________________=
__________________________

The views expressed in this email are, unless otherwise stated, those of = the author and not those
of the FirstRand Banking Group an Authorised Financial Service Provider o= r its management.
The information in this e-mail is confidential and is intended solely for=
=20the addressee.

Access to this e-mail by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, distribut= ion or any action taken or=20
omitted in reliance on this, is prohibited and may be unlawful. Whilst all reasonable steps are taken to ensure the accuracy and integrit= y of information and data=20
transmitted electronically and to preserve the confidentiality thereof, n= o liability or=20
responsibility whatsoever is accepted if information or data is, for what= ever reason, corrupted=20
or does not reach its intended destination.

=20 ________________________________

--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l