Would love to BUT this is an Oracle Apps 11i database and as such everything connects as the Apps account - even discoverer. >>> Paul Drake <bdbafh@xxxxxxxxx> 5/19/05 11:56:01 AM >>> On 5/19/05, Jeffrey Beckstrom <JBECKSTROM@xxxxxxxxx> wrote: > We are using a dictionary managed tablespace for sorts so that we can > limit the maximum space grabbed by a sort to 1 G. I know it is not > possible after the fact to determine who took all of the sort space, > however, we believe it is Discoverer. We are reluctant to convert to a > temporary tablespace since there is no way to limit sort space with > them. This is an ERP system and we don't want Discoverer grabbing all > of the space and killing payroll, etc. >=20 > Can Discoverer be limited in some way? >=20 > Jeffrey Beckstrom Jeffrey, Create a dedicated (LMT) temporary tablespace with a 1 G tempfile and assign the user(s) to it. Paul --=20 #/etc/init.d/init.cssd stop # f=3Dma, divide by 1, convert to moles. -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l