SMALLFILE TEMP / Temporary Tablespace Groups
Date: Tue, 4 Oct 2011 19:25:19 +0000
Message-ID: <EDA437CAA8612C418E013CDA4B4A7551535460B2_at_CWYIGMBCRP01.Corp.Acxiom.net>
TIA guys.
At an EXADATA install we're using BIGFILES except for TEMP. Where are using SMALLFILE (X-Team recommended many smallfiles for TEMP). I didn't get why. That's because?
We are not using Temporary Tablespace Groups. The reason we are not using them is that a single query is limited to one TEMP tablespace. ALTER USER scott TEMPORARY TABLESPACE temp_ts_group; Doesn't specify limitation. Is this limitation accurate?
LAWRENCE WOLFSON
ORACLE DBACS1 Team
Acxiom Corporation
EML LAWRENCE.WOLFSON_at_Acxiom.com
TEL 630.944.2028
MBL 630.944.2028
1501 Opus Place 7th Floor, Downers Grove, IL, 60515 USA
WWW.ACXIOM.COM<http://WWW.ACXIOM.COM>
[Description: Description: Description: Friend Us on Facebook]<http://www.facebook.com/acxiomcorp> [Description: Description: Description: Link Us on LinkedIn] <http://www.linkedin.com/groupRegistration?gid)01735> [Description: Description: Description: Follow Us on Twitter] <http://twitter.com/acxiom>
[Description: cid:image021.png_at_01CB9AD5.A73522A0]
RANKED #1 IN CUSTOMER SATISFACTION FOR IT OUTSOURCING BY<http://www.acxiom.com/news/press_releases/2011/Pages/ACXIOMRATEDNO1INCUSTOMERSATISFACTION.aspx>
THE BLACK BOOK OF OUTSOURCING, 2010 <http://www.acxiom.com/news/press_releases/2011/Pages/ACXIOMRATEDNO1INCUSTOMERSATISFACTION.aspx>
The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged.
If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited.
If you have received this communication in error, please resend this communication to the sender and delete the original message or any copy of it from your computer system.
Thank You.
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Oct 04 2011 - 14:25:19 CDT