Here is a small Oracle SQL script that displays some useful statistics of a confluence site. I have used it to clean up a large Confluence installation by removing unused spaces or spaces with only a few articles in them.
set linesize 300
set pagesize 500
column spacename format a60
column creator format a40
column lastmodifier format a40
select
count(content.spaceid) as pagecount,
spaces.spacename as spacename,
spaces.creator as creator,
spaces.creationdate as creationdate,
spaces.lastmodifier as lastmodifier,
spaces.lastmoddate as lastmoddate
from
spaces, content
where
spaces.spaceid = content.spaceid
group by
content.spaceid,
spaces.spacename,
spaces.creator,
spaces.creationdate,
spaces.lastmodifier,
spaces.lastmoddate
order by
lastmoddate;
quit