 Temp Data files Size [message #190083] |
Tue, 29 August 2006 04:22  |
mian imran
Messages: 29
Registered: July 2004
|
Junior Member |
|
|
|
I Have given different database schema's , different temp file due to large sorting of respective databases reports. but now the problem is , it is increasing with rapidly like one of database temp file is increased up to 2 GB and total database schema size was not more than 60 mb. it happen with more than 6 database schema databases. what can i do to reduce this size and what should be the best size of temp file?. any other option for sorting
|
|
|
|
|
|
| Re: Temp Data files Size [message #190274 is a reply to message #190102] |
Wed, 30 August 2006 00:16  |
mian imran
Messages: 29
Registered: July 2004
|
Junior Member |
|
|
Every thing u mentioned is already working. I have not one tablespace. i have multiple table space , separate for every schema and one is default temporary tablespace. Temporary tablespace associated with these separate schema's is due to large sorting of reports , so they not effecting other system schema's . but the MAIN PROBLEM IS there size is increasing up to 2 GB.Auto extend is off. but if this practice is carry on of size increasing it will effect the system in storage because i have 20 different schema's in main data base.
if there is any solution of this or any tip to diagnose this problem , write immediate. thanks
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
