Re: ASSM freespace management
From: Grzegorz Goryszewski <grzegorzof_at_interia.pl>
Date: Sat, 29 Oct 2011 09:19:59 +0200
Message-ID: <4EABA91F.10305_at_interia.pl>
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)?
>
>
Dom pod miastem lub mieszkanie w centrum znajdziesz wlasnie tu! http://linkint.pl/f2a58
Date: Sat, 29 Oct 2011 09:19:59 +0200
Message-ID: <4EABA91F.10305_at_interia.pl>
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-lReceived on Sat Oct 29 2011 - 02:19:59 CDT