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@xxxxxxxxxx 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@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. **************************************************************************** -- //www.freelists.org/webpage/oracle-l