Home » RDBMS Server » Server Administration » oracle 9i temp tablespace
oracle 9i temp tablespace [message #53744] Wed, 09 October 2002 03:05 Go to next message
puneet
Messages: 76
Registered: August 2002
Member
Hi ,
i am having a database on oracle9i my problem is it shows my temp tablepsace always 100 % full .even if i increase the space in temp data file its still 100 %
i feel my database is running very slow and this temp table sapce might be a reason..
can any one please help .. ..
thanks in advance ....

Report message to a moderator

Re: oracle 9i temp tablespace [message #53756 is a reply to message #53744] Wed, 09 October 2002 14:04 Go to previous message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
That could be that SMON is trying to clean the temporary segments and cannot keep up with your database activity. Ways to fix that and changesa to made are described:
Here and Here

If that doesn't work, post your statistics that show the problem.

Hope that helps,

clio_usa
OCP - DBA

Visit our Web site

Report message to a moderator

Previous Topic: Oracle 9i Traning (Tuning, DBA) ?
Next Topic: Re: Deleting a datafile
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 14:21:20 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.