请教：关于临时表空间的大小

yuxuan

海量数据啊

kdkd

电信级就是很巨很庞大：）

shanghaishiyun

You can estimate how much temp space it needs with explain plan (for 9i and above).

Yong Huang

--------------------------------------
请问Yong Huang怎么计算，或可以到哪查询这方面的资料？？谢谢

Yong Huang

原帖由 shanghaishiyun 于 2008-11-20 07:15 发表
You can estimate how much temp space it needs with explain plan (for 9i and above).

Yong Huang

--------------------------------------
请问Yong Huang怎么计算，或可以到哪查询这方面的资料？？谢谢

There's no magic. Test in 10.2.0.4:

SQL> explain plan for select text from dba_source order by 1;

Explained.

SQL> @?/rdbms/admin/utlxpls

PLAN_TABLE_OUTPUT
------------------------------------------------------------------------------------------------------------
Plan hash value: 455938138

-------------------------------------------------------------------------------------------------------
| Id  | Operation                        | Name       | Rows  | Bytes |TempSpc| Cost (%CPU)| Time     |
-------------------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT                 |            | 97914 |   186M|       | 41849   (1)| 00:08:23 |
|   1 |  SORT ORDER BY                   |            | 97914 |   186M|   382M| 41849   (1)| 00:08:23 |
|   2 |   VIEW                           | DBA_SOURCE | 97914 |   186M|       |   823   (2)| 00:00:10 |
...

You see the TempSpc column?

Yong Huang