| TEMPORARY TABLESPACE UTILIZATION TREND [message #681896] |
Mon, 07 September 2020 12:20  |
jesuisantony
Messages: 166
Registered: July 2006
Location: Chennai
|
Senior Member |
|
|
Hi All,
We have ETL/reporting application which is supported by the same Oracle DB. At times, we face temp space error and either of the jobs get failed. Hence we have created 2 temporary tablespaces and segregated the DB accounts to have default temporary tablespace to narrow down the issue.
We would like to know the historic utilization/growth for each temporary tablespace. For example, what was the highest utilization for the temporary tablespace each day? Did it hit 90%,50% or less than that. Went through various documentations to find the query which assists in getting the current temp utilization details.
How do we get the historic report on temporary tablespace utilization when we have multiple tablespaces?
Regards,
Antony
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
