OraFAQ Forum: Server Administration » Need Help for Temp Tablespace

Home » RDBMS Server » Server Administration » Need Help for Temp Tablespace (Unix)

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

Need Help for Temp Tablespace [message #675185]

Wed, 13 March 2019 21:44

Akmmhto
Messages: 38
Registered: September 2018

Member

Dear Team,

I Need some information regarding my below point , Pls contribute your valuable inputs:

a> Do small Temp datafile affects Performance of any query?
b> How to find that my query is generating excess temp?
c> Is there any way to tune any query to generate less Temp?
d> Ideal Temp Tablespace size for a 200GB Database.
e> Sudden increase in temp files , Should we need to resize them or let them be as in their current condition ?

All Above Points i raised because my developers will surely ask me that what he should/can do with his query for less temp usage etc.

Advance Thanks,
Regards
Anup

[Updated on: Wed, 13 March 2019 21:45]

Report message to a moderator

[Message index]

		Need Help for Temp Tablespace By: Akmmhto on Wed, 13 March 2019 21:44
		Re: Need Help for Temp Tablespace By: BlackSwan on Wed, 13 March 2019 22:56
		Re: Need Help for Temp Tablespace By: John Watson on Thu, 14 March 2019 02:27
		Re: Need Help for Temp Tablespace By: Akmmhto on Thu, 14 March 2019 02:46
		Re: Need Help for Temp Tablespace By: EdStevens on Thu, 14 March 2019 06:36

Previous Topic:	How To Get the username that is currently Proxy To
Next Topic:	Corrupted index causing data-integrity issues

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 06:28:30 CDT 2024