Re: ASSM freespace management
- From: Grzegorz Goryszewski <grzegorzof@xxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Sat, 29 Oct 2011 09:19:59 +0200
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
