ScriptsForAdmins

How to list all the tables in a MaxDB instance?

In releases < 7.6, you can only see the tables you have privileges on. Starting with release 7.6, the sysdba can see the tables of all users with the following select:

select * from tables

How many user task are running?

select count(*) from SYSMON_TASK where TASKTYPE = 'User'

How many pages a table uses?

For releases < 7.6:

select * from ESTIMATED_PAGES ORDER BY ESTIMATED_PAGES DESC

Starting with release 7.6 the following select should give you exact values (and be at least as fast as the select on ESTIMATED_PAGES):

select * from files f, tables t where f.fileid = t.tableid