Archives of the TeradataForum

Message Posted: Wed, 30 Jun 2004 @ 12:24:04 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Shiva,

I would recommend using dbc.allspace. In the dbc.databasespace table the databasename is only an ID (an integer value), you would have to join to dbc.dbase to get/convert the username to get their ID for the databasespace table. The below query will give you space used by vproc. You can run this while the user query is running and order by 2 desc (currentspool) to see if the query is "hot amping" as well. We typically will clearpeakdisk for a user, have them run their query and monitor during (with currentspool) and after (with peakspool).

     select vproc, sum(currentspool), sum(peakspool), sum(maxspool)
     from dbc.allspace
     where databasename = 'xxxxxxxx'
     group by 1
     order by 3 desc

KRT

	<Prev	Next>		<<First	<Prev	Next>	Last>>