Thank good for AC!

The summer is definatly here now, temperatures in London touching 34C some days now. Without AC in the office we would get boiled. Now I just need to get one at home as well.
Our India team is reporting +45C temps so perhaps I shouldn't complain. :-)

SQL of the day:
A simple query to give a quick overview of who is using database disk space and also in what tablespace.

column USED format 999,999.99
select 
  owner, 
  tablespace_name, 
  sum(bytes/1024/1024) USED 
from 
  dba_segments 
group by 
  owner, 
  tablespace_name
/