Re: Sizing Temporary Tablespace 11gr2 on Linux
- From: "David Fitzjarrell" <dmarc-noreply@xxxxxxxxxxxxx> (Redacted sender "oratune@xxxxxxxxx" for DMARC)
- To: "oratips@xxxxxxxxx" <oratips@xxxxxxxxx>, oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 24 Sep 2014 11:12:14 -0700
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@xxxxxxxxx> 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
Other related posts:
