OraFAQ Forum: Server Administration » Temporary Tablespace

Home » RDBMS Server » Server Administration » Temporary Tablespace (Oracle 10.2.0.1.0 - windows 2003 64bit)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Temporary Tablespace [message #464526]

Thu, 08 July 2010 05:01

manoj patil
Messages: 3
Registered: July 2010
Location: Pune

Junior Member

Hello all of you
I am oracle DBA (trainee) new in this field & there is no one senior here for me so please tell me following question answer.

Que: Some time my temporary tablespace size suddenly increase from 1gb to 5-6gb why this happend ? I want only reason why it suddenly increase?

Thanks in Advance

[Updated on: Thu, 08 July 2010 05:06]

Report message to a moderator

Re: Temporary Tablespace [message #464529 is a reply to message #464526]

Thu, 08 July 2010 05:06

ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

hi welcome to this forum.

Quote:

Que: Some time my temporary tablespace size increased suddenly from 1gb to 5-6gb why this happend ?

general causes are so many ....
Quote:

All operations that use sorts, including joins, index builds, ordering, computing aggregates (GROUP BY), and collecting optimizer statistics, benefit from temporary tablespace

and we dont know whats happened in your environment.

sriram Smile

Report message to a moderator

Re: Temporary Tablespace [message #464533 is a reply to message #464526]

Thu, 08 July 2010 05:12

manoj patil
Messages: 3
Registered: July 2010
Location: Pune

Junior Member

thanks sriram
but my production database is not more total size is 17gb & filled 8gb my temporary tablespace size is 1 gb

Report message to a moderator

Re: Temporary Tablespace [message #464539 is a reply to message #464533]

Thu, 08 July 2010 05:24

ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

I didn`t get your message,but time to start reading the Oracle manuals.

sriram

Report message to a moderator

Re: Temporary Tablespace [message #464546 is a reply to message #464526]

Thu, 08 July 2010 05:44

rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.

Senior Member

manoj patil wrote on Thu, 08 July 2010 05:01

Hello all of you
I am oracle DBA (trainee) new in this field & there is no one senior here for me so please tell me following question answer.

Que: Some time my temporary tablespace size suddenly increase from 1gb to 5-6gb why this happend ? I want only reason why it suddenly increase?

Thanks in Advance

To Start with...

1/ Check the long running queries.
2/ Check queries which are using Big Result set for Grouping
3/ Check TEMPORARY Tablespaces and TEMPFILES

Report message to a moderator

Re: Temporary Tablespace [message #464658 is a reply to message #464546]

Thu, 08 July 2010 11:37

suntrupth
Messages: 13
Registered: July 2010

Junior Member

Check if you have autoextend on.

V$TEMPSEG_USAGE (10.1+) / V$SORT_USAGE (< 10.1)
This view describes temporary segment usage.

v$sort_segment -> shows the allocated temp space being managed by the server

v$sort_usage, v$tempeg_usage -> shows the space within that allocated temporary segment that is currently being used by some session.

Thanks,
Suntrupth

Report message to a moderator

Re: Temporary Tablespace [message #464713 is a reply to message #464658]

Fri, 09 July 2010 00:24

manoj patil
Messages: 3
Registered: July 2010
Location: Pune

Junior Member

Thanks suntrupth

Report message to a moderator

Previous Topic:	'defaulted/pointed' to the right tablespace
Next Topic:	Weird issue with ORA-30036

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 19 14:00:15 CDT 2024