TEMP tablespace too small

Today I got a mail from my grid control: “Tablespace TEMP1 is 97% full”, acting for one of the single instance servers.

No problem, you may think, this might happen. It’s an OLAP database, so I wasn’t afraid of big numbers as well. But as you can see, using all this huge temp tablespace for – what I discovered later – one single query: It has set our new record mark. Have a look at the units…

Grid Control view to a full TEMP1 tbs

The result is: Provide fast and large machines to the development team, and you will get big, ugly and flesh-eating software. :)

Reagrds
Usn




You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply