Re: [Q] way to shrink temporary tablespace ??
- From: Paul Drake <bdbafh@xxxxxxxxx>
- To: joseph@xxxxxxxxxxxxxx
- Date: Thu, 19 Jan 2006 13:28:36 -0500
On 1/19/06, Joseph Amalraj <joseph@xxxxxxxxxxxxxx> wrote:
>
>
> Probably 2 temporary tablespaces can be created. Users writing poor
queries could be assigned to one of them, and critical applications use the
other temporary tablespace.
>
> Unfortunately Oracle does not allow quotas on temporary tablespace.
>
> Regards
>
> Joseph Amalraj
Joseph,
It "allows" quotas on temporary tablespaces, it just pays no attention to
them. :)
Paul
me@mydb> select * From user_ts_quotas;
TABLESPACE_NAME BYTES MAX_BYTES BLOCKS MAX_BLOCKS
-------------------- ---------- ---------- ---------- ----------
TEMP 0 1073741824 0 131072
TS1 0 268435456 0 32768
TS2 21168128 268435456 2584 32768
Other related posts:
