This is an Oracle Apps 11i database. The EUL is owned by the Apps acount. All users and Discoverer connect as Apps so can't alter the user id or would affect all users. >>> Steve Rospo <srospo@xxxxxxxxxxx> 5/19/05 12:11:21 PM >>> What about a different user with a dedicated temp tablespace? You can make that temp tablespace as large or as small as you want w/o conflicting the production user. S- On Thu, 19 May 2005, Jeffrey Beckstrom 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. > > Can Discoverer be limited in some way? > > Jeffrey Beckstrom > Database Administrator > Greater Cleveland Regional Transit Authority > 1240 W. 6th Street > Cleveland, Ohio 44113 -- Stephen Rospo Principal Software Architect Vallent Corporation (formerly Watchmark-Comnitel) Stephen.Rospo@xxxxxxxxxxx (425)564-8145 This email may contain confidential information. If you received this in error, please notify the sender immediately by return email and delete this message and any attachments. Thank you. -- //www.freelists.org/webpage/oracle-l