Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: temporary tablespaces
Sybrand Bakker wrote:
> <snipped>
>
>You are misunderstanding me. Even if every individual user would have
>it's own temporary tablespace, he still would be capable to run out of
>space in that individual tablespace. Autoextend doesn't come into
>play, because the way he is approaching it, he would be also afraid to
>run out of disk space.
>The OP is accomplishing nothing, except *believing* he is reducing
>risks. One adequately configured temporary tablespace will do. He
>doesn't seem to want to take that route though, but rather fight
>symptoms by setting up more tablespaces.
>
>Sybrand Bakker, Senior Oracle DBA
>
>To reply remove -verwijderdit from my e-mail address
>
>
You are correct. And for the same reason Oracle has dropped rollback
segments. It just doesn't work as well to have separate spaces managed
by DBAs as it does to have a single space managed by the kernel.
-- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Sat Sep 13 2003 - 00:58:50 CDT