About

Martin Klier

usn-it.de

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

Cleanly removing an agent or host target from Oracle Grid Control 10.2.0.4
New blood in IT sector (partially German)

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.