Re: Limit sort space used by Discoverer

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_at_vallent.com> 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_at_vallent.com           (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.




--
http://www.freelists.org/webpage/oracle-l