Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Limit sort space used by Discoverer
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_at_gmail.com> 5/19/05 11:56:01 AM >>>
On 5/19/05, Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org> 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
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.
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Thu May 19 2005 - 12:11:06 CDT
![]() |
![]() |