Archives of the TeradataForum
Message Posted: Thu, 16 Oct 2008 @ 14:12:33 GMT
| Subj: || || Re: Getting a session's own resource info |
| From: || || Dieter Noeth |
Levai Akos wrote:
| ||I would like to get a session's consumed resource info (CPU, IOand so on...), within the session through SQL.|| |
| ||It would be important for me the the session sould get these informations itself, and write it to the output.|| |
| ||I would not like to use the DBQL, because the overhead, and the offline postprocessing (matching the query with the DBQL log)|| |
If you run TD12 there's a new set of UDFs to access all the data provided by the PMon-API through SQL.
Of course you'll need another session to access that data for a currently running query.
And if a query is finished you still have to access DBQL, but in TD12 there's a new feature "querybanding" which helps to locate that query