当前位置: 动力学知识库 > 问答 > 编程问答 >

oracle11g - When and from Where to call or use temporary tablespace in database

问题描述:

In my project we have used temporary tablespace say X_TEMP ,assume below is tablepsace code , I have found this code in tablespace section

CREATE TEMPORARY TABLESPACE X_TEMP

TEMPFILE '/oradata/mytemp_01.tmp' SIZE 800M

EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;

Now I want to check how it is getting called and where I have used this X_TEMP in my procedure,functions,code anywhere where ?

Any idea how can find where We have used it ?

网友答案:

The question doesn't make a whole lot of sense.

Unless you happened to create temporary tables in that tablespace (which would be unusual in Oracle but which would let you tie some usage to particular pieces of code), your user's temporary tablespace (I assume that after creating this temporary tablespace you made it the temporary tablespace for some user) would be used whenever Oracle needed to page data to disk. A query that needs to sort data, for example, might use temporary tablespace. Or it might not, execution to execution, depending on data volumes, how much PGA the session is able to get, the query plan used, etc. Any query this user executes could use temporary tablespace at any time. Or none of its queries might use temporary tablespace because they can all be done in memory. Or they might not use temporary tablespace today and start using it tomorrow because someone else is running some code that limits how much PGA Oracle can give the user's sessions.

分享给朋友:
您可能感兴趣的文章:
随机阅读: