Re: Coalescing Free Space.

Charles

>
> Tony Jambu, John Marvin, et al.,
>
> The ALTER SESSION set events 'immediate trace name coalesce level n' trick is
> quite useful, but I think more info is needed.
>
> I'm running V7.1.6.2.0 on Solaris 2.4. I have a ts w/ 38 free extents (ts#=4)
> and the ALTER session has not done anything.
>
> I changed the default pctincrease on the ts from 0% to 50%
> I tried different values for n using the hex stuff in John Marvin's script
> ( 0038 0004 = 3670020 )
>
> The alter session seems happy "Session altered." -- but nothing happens...
>
> This technique will be quite handy if I can get it to work -- what am I
 missing?

I am not sure if others or myself have replied to you. Are you sure you are refering to the free space and not the number of extents used by the talbe? I am not sure what base number should be provided to the ' immediate trace name coalesce level XXXX'. Try decimal followed by hex. Just a thought.

Let me know if you do get it going.

ta
tony

--

 _____       ________ / ___|Tony Jambu, Database Consultant
  /_  _        /_ __ /     |Wizard Consulting,Aust (ACN 065934778)
 /(_)/ )(_/ \_/(///(/_)/_( |CIS: 100250.2003_at_compuserve.com FAX: +61-3-4163559
 \_______/                 |EMAIL:TJambu_at_wizard.com.au PHONE: +61-3-4122905