Re: Sizing Temporary Tablespace 11gr2 on Linux
From: David Fitzjarrell <oratune_at_yahoo.com>
Date: Wed, 24 Sep 2014 11:12:14 -0700
Message-ID: <1411582334.55581.YahooMailNeo_at_web124703.mail.ne1.yahoo.com>
No.
Date: Wed, 24 Sep 2014 11:12:14 -0700
Message-ID: <1411582334.55581.YahooMailNeo_at_web124703.mail.ne1.yahoo.com>
No.
The best way is to monitor TEMP usage over time. Also monitor what queries are using large amounts of TEMP space. There is no magic bullet to managing TEMP tablespace sizing.
David Fitzjarrell
Principal author, "Oracle Exadata Survival Guide"
On Wednesday, September 24, 2014 10:00 AM, Bala <oratips_at_gmail.com> wrote:
Gurus,
Is there a quick way to size temporary tablespace size in Oracle 11gr2 for OLTP applications ?
Thank you for any pointers and help
--
Bala Rao
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Sep 24 2014 - 20:12:14 CEST