Re: utlbstat\utlestat using other than system tablespace?

Just before Running the Utlbstat/Utlestat Scripts , why dont U try to Change the Default Tablespace of the User SYS to a Non System tablespace and then Change it back after the Work is done.

-Thiru

David Spaisman wrote:

> Hello:
>
> I have been running utlbstat and utlestat to check the application we
> purchased to see it needs some tuning. In a related article I recently read
> it was suggested that the temporary tables in utlbstat\utlestat are created
> in the system tablespace and that frequent tuning of these scripts may
> result in a fragmented system tablespace. Yet in looking at the coding for
> these scripts I don't see how to amend the table creates to change the
> tablespace. For the sys user under which I run these scripts the default
> tablespace is system while I have the system
> user defaulting to a tools tablespace.
>
> How do I direct the creates for utlbstat\utlestat to other than the system
> tablespace?
>
> THanks.
>
> David Spaisman
Received on Thu Jun 03 1999 - 16:08:29 CDT