Re: ASSM freespace management

From: David Fitzjarrell <oratune_at_yahoo.com>
Date: Fri, 28 Oct 2011 15:09:20 -0700 (PDT)
Message-ID: <1319839760.31768.YahooMailNeo_at_web65402.mail.ac4.yahoo.com>

It appears to be the PID listed in V$PROCESS, an Oracle process id, different from the O/S pid populating the SPID column in the same view.

David Fitzjarrell

From: Rich <richa03_at_gmail.com>
To: Oracle-L Freelists <oracle-l_at_freelists.org> Sent: Friday, October 28, 2011 2:41 PM
Subject: ASSM freespace management

Hi List,
This is 64-bit 11.2.0.2 on RHEL 5.6 x86_64

I believe that ASSM freespace management is (roughly) controlled through PID - ref Tanel Poder's outstanding presentation at www.perfvision.com/docs/Poder_Freelists_vs_ASSM.ppt. Although this presentation is older (2003) and re 9i, I also believe it is still relevant.

Does anyone know if this PID is the OS process PID or something else? (We use dedicated sessions)

Does anyone know the hashing algorithm related to this?

Also, any tracing hints that might be useful (other than the standard 10046, sql_trace, and process level like http://files.e2sn.com/scripts/tpt_public_unixmac.tar.gz)?

We're trying to set up a controlled test for a LOB index segment issue...we have an SR open, however...

Thanks,
Rich
--

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

--

http://www.freelists.org/webpage/oracle-l Received on Fri Oct 28 2011 - 17:09:20 CDT