Re: ASSM freespace management

On 2011-10-28 23:41, Rich wrote:
> 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)?
>
>

Hi,
 You can use
alter session set events '10320 trace name context forever, level 3';
alter session set events '10612 trace name context forever, level 1';

10320 Enable data layer (kdtgrs) tracing of space management calls"
10612  "prints debug information for auto-space managed segments"

But they can produce huge trace files so be prepared .
Above not tested so be warned :).
Regards
GregG





----------------------------------------------------------------
Dom pod miastem lub mieszkanie w centrum znajdziesz wlasnie tu!
http://linkint.pl/f2a58
--
http://www.freelists.org/webpage/oracle-l


Other related posts: