How to limit temporary table file size?
Posted by: Oleksandr Voytsekhovskyy
Date: January 21, 2014 02:33AM

Hi,

sometimes my clients run stupid queries, which create huge temporary tables. Sometimes, they use all available space (100+ Gb). And block all queries from other clients (no space left).

I want to limit max file size for temporary table (or rows) to ~10Gb.

Is there a solution for that?

Maybe there are solution on OS level?

I am running 5.5.31 on Linux.



Edited 1 time(s). Last edit at 01/21/2014 02:56AM by Oleksandr Voytsekhovskyy.

Options: ReplyQuote


Subject
Written By
Posted
How to limit temporary table file size?
January 21, 2014 02:33AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.