Re: System tablespace - help!

Hi
When the system tablespace is used for temporary purpose, the dynamic (dictionary) tables cannot be extended properly during the time of changes to the database and it would get fragmented. Once you fire queries to these dynamic tables, there would be delay in getting replies.
1) Do not use system TS for any purpose. 2) PCT INCREASE SHOULD be 50% only and do not bring down to 0. ramkumar.
3) Alter the user sys and make temporary TS to some thing else. 4) Also ensure you are not having any objects in Temporary TS. RAMKUMAR AT trram_at_yahoo.com

In article <397DFC48.FEF16778_at_demon.co.uk>,   holders <holders_at_demon.co.uk> wrote:
> move everybody OFF the system tablespace. If sys is using SYSTEM as
 its
> temporary tablespace then it wil allocate permanent space on it and
 there
> will be little you can do about it. What is using the system
 tablespace ?
> SH
>
> Sid_James wrote:
>
> > On our db only SYS and SYSTEM use SYSTEM as default tablespace, all
 the
> > others use BESPOKE. SYS uses SYSTEM as its temporary tablespace and
> > SYSTEM uses TEMP.
> >
> > The problem is that the SYSTEM tablespace seems to be using a lot of
> > space far more than usual. Can anyone advise what may be going on?
> >
> > Thx
>
>

--
ramkumar


Sent via Deja.com http://www.deja.com/
Before you buy.