 |
 |
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
within DBQL.
Dieter
| |
