Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Limit sort space used by Discoverer
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
-- http://www.freelists.org/webpage/oracle-lReceived on Thu May 19 2005 - 11:50:44 CDT
![]() |
![]() |