| The Temporary Tablespace?? [message #215029] |
Fri, 19 January 2007 01:03  |
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
|
Senior Member |
|
|
When I tested my DB, I found that temporary tablespace increased over 3.7 GB, I did not how I had had information for the temporary tablespace, and what could I remove from it.
What must I do now??
Thanks for advance!!
|
|
|
|
| Re: The Temporary Tablespace?? [message #215034 is a reply to message #215029] |
Fri, 19 January 2007 01:15  |
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
|
Senior Member |
|
|
You probably have the datafile set to automatically increase as required, and then did a really big sort, hash join, index build, whatever.
Check the manuals for ALTER DATABASE command, you should be able to shrink it now that it is not being used.
Ross Leishman
|
|
|
|
| Re: The Temporary Tablespace?? [message #215042 is a reply to message #215034] |
Fri, 19 January 2007 01:32 |
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
|
Senior Member |
|
|
| rleishman wrote on Fri, 19 January 2007 14:15 | You probably have the datafile set to automatically increase as required, and then did a really big sort, hash join, index build, whatever.
Check the manuals for ALTER DATABASE command, you should be able to shrink it now that it is not being used.
Ross Leishman
|
Thanks for your reply.
1/ The temporary tablespace was default with RDBMS created, then I did not understand that it was managed by LOCAL or AUTOEXTEND. And I checked datafiles corresponding to the Temporary tablespace, some datafile was 2.6GB totally.
2/ Some schemas like that SYS, OUTLN, HR, PERFSTAT and myDB are used, the others was locked. And the plan stability guides SQL statements must be run according to HASH.
3/ I think maybe the DBMS_STAT executes and I will send to you my report.
4/ I am sure for another softwares protected by Kaspersky Antivirus against for increasing OS block.
Thank you very much!
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
